Skip to main content

Posts

Showing posts from September, 2014

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'…

Complete Tutorial on Facebook Open Graph

Facebook Open Graph allows you to use custom site title, URL, description and even a custom image when you share your page. If you use Facebook Open Graph code on your site, every time when you share any page, it will be counted directly for your home page. Suppose, if I share the following URL on Facebook - 
http://www.markspcsolution.com/2014/09/complete-tutorial-on-facebook-open-graph.html
The sharing/ like will be counted for - 

http://www.markspcsolution.com/

But If there is no open graph code on my site, the sharing of the first URL will be counted individually. And the sharing will not be counted for your home page. Now I guess, you've understood the importance of open graph. It's really helpful to increase facebook likes of your site rapidly. 


Couple of days ago, I discussed about how to claim a site on Facebook. Following the same method, you can place Facebook Open Graph code on your site. Open graph code is as follows:



<meta property="og:title" content="…

Convert VCF to CSV by Contact Converter

Contact Converter is the most reliable tool to convert vCard File (.vcf) to .csv file which can be opened by MS Excel. Contact Converter allows you to convert unlimited number of contacts. It's a 100% free software, easy to use and supports Google Contacts. 


Background Story 
Yesterday, one of my colleagues told me that he has a back up of his iPhone contacts in a pen drive. He wanted to know, how to print those contacts. Then I asked him to show me the file.  I opened the file in a PC and saw there are over 600 .vcf files!
And to be honest, I never work with .vcf files. I even didn't know what type of file this is before writing this post! Then I took his pen drive to my home though I was sure that I couldn't do anything! 
Last night, I googled and found a software named Contact Converter. And with this tool, my task got easier. Within few minutes I converted the vCard files to CSV. Then I've edited the CSV file in Excel and printed the document without any problem!


What i…

How to Print Word Document as Booklet?

You can print your Word Document as book. In MS Word, the term is known as Book Fold which can be found in the Page Setup dialogue box. If you want a document to be printed as a booklet, you must set up the document at first. Otherwise your document settings may change too much. And this will take a huge time to fix the settings. 

For last few days, I've published several posts on Excel. Now it's time to write something on MS Word. What do you think? :)

Applies to All Versions of MS Word

Word XP, 2003Word 2007, 2010, 2013


What does Book Fold Do?
It's a good question to begin the discussion. Suppose you have a document with 4 pages. If you want the printed document to be looked like a book, you can use the booklet option. The Word will print your document as show in the image below:

And if you print the two pages in both sides of a single paper, it will be like a book! What if you have 8 pages? Then it will be printed as below:

That means the last page of the document will be prin…

Divide Excel Worksheet into Pages!!

If you're using Excel 2010/ 2013, you can divide your worksheet into individual pages. This exciting feature was unthinkable even on Excel 2003. At first, Microsoft introduced this Page Layout feature in Excel 2007. And it's available in Excel 2010 and 2013 too. 

Almost all of you are familiar with the Print Layout view of Microsoft Word. Excel Page Layout view does the same job here. If you enable Page Layout view in a worksheet, you can easily understand your print area with header and footer. And it also makes your printing task easier




Applies to:
Excel 2007Excel 2010Excel 2013

Advantages of Page Layout
You can view how your printed document will lookCheck where your page begins and endsView headers and footers of the pagePrint the worksheet page by page
How to Enable Page Layout View
You can enable page layout view as below: Open any worksheet or create a new oneGo to the View Tab > Workbook Views > Page Layout


You can also use the keyboard shortcuts:
Press Alt Key > Then…

How to Claim a Site in Facebook?

Do you know, you can claim your domain/site in Facebook to get insights? If you register your site on Facebook, you can view analytics for referral traffic, stories, user engagement and other related information. And definitely this will help you to take better actions for your site. 

I always say, if Facebook were a country, it could be the most populated state of the world. It's a site with the most registered active users. No other site, even Google and Twitter can't attract users as much as Facebook. Most of the users waste their valuable time on Facebook.  

But as a blogger/ web developer/ app developer, you can't either waste your time or avoid Facebook. You can take advantage of the popularity of Facebook. You can promote your website/ blog/ app on Facebook. You can do this in your way. I'm not gonna interfere there! 

Today I'm writing about - claiming/ registering a site on Facebook. You can do this easily. All you need is just adding a simple meta tag before …

How to Print Headings on Every Page in Excel?

Sometimes you may need to print same column headers on every page in Microsoft Excel. And to do so, you don't need to manually copy the headers on every page. You can simply set a command from page setup option to print column headers on every page automatically! 
In my previous post, I discussed about how to lock or freeze column headers. By freezing rows or columns, you can just show headers at the time of scrolling. But they will be printed on the first page only.  In this tutorial, you will learn - how to print same column headers on every page automatically .  .  .

Applies to: MS Excel 2000/ XPMS Excel 2007/ 2010/ 2013Note: This tutorial has been prepared using Excel 2013. So, few options may differ slightly.

Let's start -  Open a previously saved worksheet or create a new one in MS Excel.Go to the Page Setup option from Page Layout Tab (Office XP/ 2000 users should find it under Edit Menu).Go to the Sheet tab from Page Setup.Look at the Print titles option: Rows to repeat and…

How to Lock Rows/ Columns in Excel?

When you are preparing a large statement or table in Excel, the column headings at the top usually disappear when you scroll down. And this is really troublesome when you need to input data under several headings. Couple of months ago, I faced the same problem. And just 2 days ago, one of my relatives questioned me how to create static/ fixed column header in Microsoft Excel. 

Then I explored the topic and found the solution from Excel help and Microsoft Support Page. So, in this post, you are getting another important excel tutorial - How to Lock/ Fix/ Freeze Rows or Columns in excel while scrolling throughout the worksheet.


Lock/ Fix/ Freeze Rows or Columns

In Excel, the term is known as Freeze Panes. With this option, you can freeze a row or column that you want visible even when scrolling down or right. 

Suppose, you preparing a salary sheet that contains hundreds of rows. And you can view only 25/30 rows in a view. When you scroll down, the column headings will disappear. If you want…