Pivot table is great tool in Excel to create reports and analyze data. Go thru the simple exercise below to understand the concept Continue reading »
Sep 212009
Aug 212009
When you need to verify data that can go in a cell, Data validation is the function in Excel to use. Continue reading »
Aug 142009
Conditional Formatting allows changing appearance (different color, font, format etc) of cell based on certain condition. For example you can show employees with Salary Higher than 100000 USD in Red. This makes easy and visually appealing to read and interpret data. Continue reading »
Jun 282009
A data type communicates to program what kind of variable is needed in operation.
Here is a quick list of data types. Continue reading »
Jun 212009
Excel 2007 comes with the option of querying web to export table data from internet. This is a very good option if you rely on constantly updated data such as exchange rates etc. Continue reading »
Jun 092009
Here is a quick reference of important formulas in MS Excel. Functions are pre-defined formulas in Excel and can be interchangeably used with term Formula. The list has been prepared using Excel 2007. But most of the formulas should be applicable to other versions as well. Continue reading »
Feb 282009
Name range in Excel is a way to define a range to be used in Formula. Continue reading »
Feb 112009
There are different ways a cell can be referenced or called in Excel. Continue reading »
Jan 082009
You can use Scenarios to see what would happen to your bottom line figure if you change certain values. Continue reading »
Dec 062008
When you know the result but are not sure of the input that would bring the desired result, Goal Seek function can help. Goal Seek is one of the” What If” analysis functions in Excel. Continue reading »
Nov 262008
If you want to use values from one worksheet to another, you would need to use a reference to the worksheet. Continue reading »
Nov 082008
Microsoft introduced new format with Office 2007. Word 2007 saves file as .docx. Excel 2007 saves file as .xlsx and so on. But most of the world is still using old versions of Office. These people might have trouble accessing your files. So, for the time being it might still make sense to save files in old doc or xls format. Continue reading »
Oct 162008
Here is a look at changes introduced with MS Office 2007. Continue reading »