Skip to main content

Posts

Showing posts from October, 2013

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

Sitemap: Informs Search Engines About Pages

All of you are familiar with maps. City Map, World Map etc. etc. But how many of you know about sitemap? Though it's a very common term to the webmasters, general people hardly know about this. Even new bloggers are not conscious about sitemap. The fact is that it's an important part of SEO. Let's take a brief idea on Sitemap.


Well a sitemap is something like City Map! What does a city map tell you? You can find the park, bus stand, university or any other important places from the map. From a World Map, you can find the nations of the world. Similarly, a sitemap includes the posts or pages of a blog or website.


Simply a sitemap can be defined as a list of pages of a site. A sitemap gives access search engines to crawl those pages. And it also let the visitors easily navigate throughout the site. If you submit your site's map to search engines (Google, Bing, Yahoo etc.) then it will be easier to index the site. Search position of the site will also be improved.


Search e…

Creating Column, Bar & Pie Chart in MS Excel (With Sheet)

Hello Dudes! Hopefully you're alright and also hope you're enjoying my posts. After a long time, I've come with MS Excel Tips. Couple of Months ago, I shared an Excel Sheet with you that includes - Salary Sheet, Result Sheet, Electric Bill etc. Today I've come with another sheet which will help you to learn how to create Column, Bar and Pie Chart in MS Excel. 

Actually I was planning to share this tips with you for a long time. But I couldn't understand how to start and what to write. Finally, I've decided to share a sheet with you as example. And I will also try to clarify how to create charts in MS Excel. 

Applies to: Office 2007Office 2010Office 2013But I've used Office 2010. So there might be some changes in other versions. 

Download Column, Bar & Pie Chart Sheet

For your convenience, you can download the above file and have a look before we start. It's just 22 KB! Remember, it is an .xlsx file and can only be opened with Office 2007 or above. Three …

Microsoft Office Screen Clipping Tool

You can easily insert a screenshot to your Microsoft Office file. Maybe you've many other options to capture screen and then place it to a required place. But isn't it handier if you can do so without leaving your file? In March, 2012, I wrote about Snipping Tool, which is used to take screenshot. And this tool is really handy to work with images also. But when you're working with documents and workbooks, the use of snipping tool is somewhat difficult. First you have to capture the screen and then you have to save it, and finally you paste it. But many people don't know that Office 2010 & 2013 have screen clipping tool! Today, I'm gonna write about this . . .

Applies to:Microsoft Office 2010Microsoft Office 2013
Microsoft Word, Excel, PowerPoint & Outlook have screen clipping tool. Whenever you need to insert any part of your screen, you can use this tool. You should also know some tips to use it perfectly. Instruction:Open any of the said programs - I'm …

Scroll to Top Buttons for Blogger

After a long time, I'm come with a nice widget for blogger. Maybe you've already got an idea what my today's post is about. From the post title and the image, it is clear enough to guess that you're getting a Scroll to Top script for your blogger blog. I'm gonna share some buttons too. But you can easily replace the default button with your custom image. This is the default button of the script I'm sharing here. You can view the demo at the bottom right corner of the page. Just scroll down and see the button. Then hit on this to back to the top.  But if you don't like it, or if you wanna use your own button, then you can replace this one. Now follow the procedure below (as simple as adding a JavaScript): Make sure you're signed in to your blogger account.Now go to your blogger Dashboard or Control Panel or whatever you call it.Go to the Layout, and hit on the Add a Gadget button from anywhere.Choose HTML/ JavaScript gadget.Copy the following code and pa…

Convert DOCX to DOC Online - 100% Free !!!

Hello Guys! Eid Greetings for you! Today I'm gonna share a nice tool with you. This is actually based upon the request of Marija Petrovska, an agent of investintech.com. You people know that I often write about PDF tools which are free to use. But she requested to write about a soft which is premium but having much advantages. It's size is 16 MB (Approx). As I like light software, I denied to write about it. Later she shared some light tools with me. And I promise that, I must write about these tools for my valued visitors. And this is the first one you're getting now! 


You've already got an idea about today's post. And you know this is a really really a boring problem that belongs to the file format of Microsoft Office 2007 and 2010. 


Problem Description:
Most of you are familiar with this issue. Those of you are using MS Word 2003 or earlier version normally don't face it. But if you're using Word 2007 or later version, you might have faced this problem some…

Portable Oxford Pocket Dictionary - Free Download !!!

You know the OXFORD is the world's most trusted dictionaries. Maybe many of you got this on your reading table. And some of you may have it in your mobile or computer. But I'm gonna share the Oxford Dictionary (Pocket) with those people who don't have this. 

Advantages: No installation required - PortableSmall Download Size - Less than 3 MBRich- Includes More than 1,40,000 DefinitionsConverter - Length, Area, Volume, Speed, Temperature, Pressure etcNo Special Requirements - Works with most of the Operating Systems 


Download OXFORD Dictionary


Manual: 
This dictionary is very easy to navigate as well as operate. But I'd like to introduce the operation for some users who are not familiar with such software.  Download the zipped file from the above link and then unzip it.Double click on POD.EXE and wait a moment for the screen to be appeared.You will see a small search box to find the words. As soon as you type in the box, the word with definitions will appear. But first time, y…

Free PDF to Word Converter !!

Hello Guys! It's been a long time since I wrote about any software. Today I've come with a great tool for you. With this tool, you can easily convert your PDF Document into editable Word Document! And certainly you get this for free!

Look at the screenshot below:


Instruction:
After installing the software you will get desktop icon. Double click on it to run the software. Then you will get the screen like the image above. Then complete your task as below: Choose the source file (PDF) from the left box.Select the destination folder from the right box.Limit the number of pages from General Options. It could be All Pages or specific range of pages (suppose 1 to 10).Unmark the options (Retains Shapes and Uses Text Box) to avoid unnecessary boxes in the converted document. You can choose either Times New Roman or Arial as the conversion font. Later you can change it while editing. As Doc Reader, you can choose either Word Pad or MS Word as your necessity. When you're ready to go, si…

XPS Documents- Alternative to PDF

An XML Paper Specification (XPS) is a document format that you can use to share documents with others. Except few dissimilarities, it is exactly similar to a PDF document. More than a year back, I discussed about PDF file and I've also discussed about how to create PDF file. Today I'd like to talk about XPS. 

Applies to:  Windows 7 Windows 8Windows 8.1

Though XPS is also available with Windows Vista since 2006, still this is not a popular way of sharing documents due to the widely accepted PDF documents. PDF is being used for a long time. Thousands of tools (either Premium, Freeware, Shareware or even Open Source) are available throughout the web for handling PDF documents.
You should notice, PDF viewer is available with any smart phone, tablet, laptop or desktop. It is supported by any operating system. But XPS is not so cheap. It's exclusive for Windows Vista or Above. And that's why it is not a widely accepted medium of sharing documents. 

While most of the people even d…

HTML Tutorial 7: Creating HTML List

Hello Guys! This is my tutorial number 7 on HTML. If you would like to read the previous 6 tutorials then please use the search box above, type HTML and get the HTML tutorials list. 
Today I will discuss about a simple topic of HTML. Really this is as simple as I say! :) Okay let's start.

Practice Rules
Practice rules are as usual. Use notepad and a web browser. Save the file with .htm or .html extension. 

HTML List: Ordered and Unordered
There are mainly two types of lists can be created by HTML code. The first one is ordered list and the other is unordered list. 

Ordered List:
In an ordered list, the list items are marked by numbers. This exactly looks like a numbered list created by Microsoft Word or other text editing programs. 
An ordered list starts with <ol> tag and ends with </ol> tag. Each item of the list starts with <li> tag and ends with </li> tag. Look at the code below:
<ol> <li>Apple</li>
<li>Google</li>
<li>Microsoft&…