I still remember the time when me and Ashish were roommates, and he used to maintain a small diary of expenses, in which he used to keep the details of his day to day expenses, and at the every month end he use to analyze it, in order to cut down some extra expenses for [...]

Lets say you have lots of project tables in excel which contains break up of each phase man hours i.e. coding, deployment etc. Now if you  have 10 projects like this and you would like to see a consolidated value of all these projects with header labels ( Project name ) and Phase labels i.e. [...]

his is a very handy trick if you just want to copy comment from already filled in and formatted cell to another cell in excel without additional formatting. The fist step is to copy the cell completely. Then select the cell where you would like to paste the comment. Now right click and click paste special and select [...]

Named Ranges are set of selected cells in Microsoft office excel 2007 which can be identified by a unique name. These serve a good purpose when you want to refer across sheets or even when you create protection of parts of excel files for different users.
Now lets assume you have a very large excel files [...]

This is a nice  office trick if you want to transpose or change set of cells in excel files from row to column or column to row quickly.  Here are the steps

Select the cells and copy it.
Now select anywhere you want to transpose and hit ALT + E > S  and then select Transpose.

Related : [...]

his is an excellent way in case you have big excel sheets and you need to move from one part of sheet to another to check or pickup data. I came out with this when I was working with excel sheets ( MS Office 2007 )  in sharepoint 2007  where named ranges are actually helpful [...]

Welcome to Office Tips and in this post we will learn about some of the features, tips and tricks of Microsoft Office 2007 Excel Sheets which we usually miss or don’t bother to use without even knowing how beneficial they can be. Here are some useful points which definitely ads on to your excel skills. [...]