Skip to main content

Posts

Showing posts from January, 2015

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

Google Docs - Manage your Documents Online . . .

We're just at the beginning of cloud computing. And I think many of you are familiar with the applications of Google Drive. With Google Drive apps, you can perform almost all tasks of Microsoft Office. Today I would like to talk about Google Docs which can be used as a perfect alternative of Microsoft Word.


Features & Advantages A 100% free tool for collaboration (Share with anyone, work at the same time)No need to purchase software or renew licenseAccess your documents from any device (Phone, Tablet, PC) anywhereThousands of options to organize and decorate your documentsDocuments are automatically saved to drive!!Compatible with Microsoft Word (Open and edit MS Word Files)No unnecessary options 

Requirements
Basically it's a browser based application. For best performance, you must use the latest version of Google Chrome. And the connection speed should be more than 256 kbps to load the page properly. 


How to Use Google Docs?
All you need is just a Google ID. If you've a G…

Setting up Custom Domain for Blogger Blog

Blogger allows you to run a blog at free of cost. Unlike WordPress, you can use all the features and benefits from blogger without spending a single dollar. But if you would like to use a custom domain for your blog, then you have to purchase it from a third party domain registrar. 
Few years ago, blogger had its own domain registrar and the users could purchase a domain from blogger dashboard. And it was very easy for the users to set a custom domain that time. But later blogger stopped providing custom domain service. So, the bloggers who would like to use custom domain for the blogs, should purchase domains from third party. 

Setting up Custom Domain
Well for the new users domain set up process is little bit complex. But if you go step by step, then it wouldn't be so difficult. 
First, you need to purchase a custom domain (Choose a domain name and register it. Before that, make sure the domain is available) from a domain provider. As you know, there are numerous domain hosting site…

Beginning of the End of Internet Explorer . . .

This is gonna be the goodbye message to Internet Explorer (IE) from Marks PC Solution. Released with Windows 95, Internet Explorer is still holding the position of default browser in Windows Operating Systems. After running for the 20 years, Internet Explorer is now too old to use. 
Windows 10 (Technical Preview) users are still using Internet Explorer 11. But in Windows 10 Consumer Preview, Internet Explorer may no longer be available. Currently Microsoft is developing a new browser with the codename Spartan. If the codename is not changed, then Spartan will be the default browser of Windows 10. 


What Does the Word Spartan Mean?
The citizen of Sparta is called Spartan. Sparta was a prominent city in ancient Greece. But I really don't know where the codename Spartan come from. 



Why Microsoft is Terminating the IE?
In fact, the termination of Internet Explorer is the demand of time. As I mentioned in my browser review post, Internet Explorer is losing market share to Chrome and Firefox,…

Perform Basic Calculations in MS Word Table

The general idea about MS Word is that, it's all about typing. Most of the users think that it's nothing but a word processor. Of course they are not wrong. But you can perform some basic calculations in MS Word while you're working with a table. It allows you to perform logical comparisons too!


Intermediate level users should already know this trick. But the basic users may not have any knowledge about MS Word Table Function. That's why I'm sharing this little trick. 


Applies to:
Word XP/ 2003Word 2007Word 2010/ 2013
Note: This tutorial is prepared based on MS Word 2010. So you may notice slight changes in other versions.



How to Perform Calculations?
To perform basic calculations in MS Word, you have to create a table. After creating the table, input numbers there. Have a look at the illustration below:

Product January February March Total A 12 12 15
B 8 9 10
C 23 22 25 Total

Suppose you've to sum up the values of rows and columns of this table. And for this work, yo…

Browser Review - A look back to 2014 . . .

Another year has gone from our calendar. And we're one more year close to the final day. 2014 was really a nice year with some technological breakthroughs. Actually we have innovations in every moment. Today I would like to write a review on Internet Browsers. In this post, I want you have a look back to the 2014.    


Look at the following table: 

BrowserStatistics (2014) Statistics by Marks PC (2013-2014) Google Chrome56% 48% Firefox26% 28% Internet Explorer9% 13% Opera2% 4% Apple Safari4% 2% Others1% 5%

Here you get two statistics side by side. The first one is published by w3schools.com. You know they publish statistics month by month. I've summed them up to show you the yearly users of the popular browsers. 

And the second one is the statistics by Marks PC Solution itself. It's generated from Blogger Dashboard. Here I've included the statistics of two years - 2013 & 2014. The browsers used by the visitors of Marks PC Solution from 2013 to 2014 are shown here. 


I've also crea…