Excel

3 Nifty Ways to Change date Formats In Excel

Change date format mm/dd/yyyy to dd/mm/yyyy in excel This problem is faced by many Indian users as the U.S system of mm/dd/yyyy is quite strange to them and for them it creates problem each time they look at it. So here i am sharing some tips to fix it.   Without using any code or Macro First i am taking here an example of date 9/23/2015 now to convert it into dd/mm/yyyy use this. Right click that particular cell in…

Read More

Excel Drag Not Working 2007 and 2010

Following are the tips that can be used to make drag function work properly in MS excel. In 2007 or 2008 version You have to open excel and click on options > it is beneath the file menu. You can see in this image. Now click on Advanced category, under Editing options. Now you have to clear the Enable fill handle ( Follow the images to understand it better) and change the cell drag-and-drop check box to turn on or…

Read More

Best Software To Recover Severely Corrupted Ms Excel File ?

There are plenty of Excel spreadsheet recovery software’s out there which one is your favorite ? I am including some of them here,their features along with their prices. It is not a review exactly for these tools but you can help me here by posting your comments and tell us which one is best? and why i should pay or not for that software. 1. Cimaware’s Excel fix : It comes with a price tag of €79. Developers say that…

Read More

Quiz Template Download Without Any Hassle !!!

This spreadsheet template allows user to fill in quiz data. It is easier to understand first of all you have to type in the quiz name.After it you can fill in questions and the answers. Nice and easy template. You can even print this template after filling.     Here is a Power point template User has to fill in the questions and place the answers in text box as they are labelled where to put right and where to…

Read More

Convert Excel sheet to Google Spreadsheet and Make It Editable

It is very simple to make your spreadsheet editable for many other users via Google docs.  Users will be able to edit and update the worksheet from any place. Following are the steps :   Open Google Docs spreadsheet homepage click here . In the page click the folder icon (See image) Create and choose Files…>> upload After uploading file click it and open it. Now how to make it shareable and editable for any other person Now to share this…

Read More

Example of Creating A Population Pyramid In Excel

This one is a fine sample spreadsheet to construct a population pyramid in excel sheet, user have to fill in data in % divided into males and females along with their age.After the data input chart will be automatically constructed in the same sheet but in different tab provided. Easy to understand and use and understand. If you have data of actual males and females instead of percent you  can arrange the data according to this tutorial.It is quite easy…

Read More

Downloadable Cue Sheet Template

I am sharing few blank cue sheet template’s with you. These can be downloaded and filled by the user information such as publisher and composer is needed to be filled in these sheets.     Here is another one it is sports music sheet as it is uploaded to onedrive. You have to click on more… and then  choose download option  

Read More

Purchase Request Form In Excel

Track your purchase per item wise using these worksheets. They support most of the spreadsheet programs like excel,google sheets and others. You can convert them to open office format also. There are various tools available online that can do this for you in few minutes.   MAC users try this : You can download these sheets and upload them to Office web Apps that will allow you to edit files and save them online. For it you need a Live…

Read More

Do you like to read Ms excel tutorials or watch ?

I have lots of Ms access and Excel tutorials resources (links from internet,videos and PDF’s along with templates and example sheets, some of them are really important and can help a lot, but the thing is that I want to know which one works for you. I basically hate reading long tuts as well as long videos as they consume a lot of time and in the end you might get the desired result or not. I will be making…

Read More