Creating Tables in Excel that are dynamic in nature


Excel tables are dynamic in nature. Table helps to enter and format the data easily in the desired manner. Table feature helps the user to apply already used formats to newly created columns and rows.

IF function in MS Excel

IF function is used to test a given condition i.e. true or false in Excel.If the condition holds true, the function returns a value as suggested by the user and if the condition holds false then also function returns a value.

Filter in MS Excel 2007

Filter in MS excel 2007 enables a user to have a compact and a more relevant view of the data. It allows a user to choose the desired data for analysis and hides data not required for current analysis.

Future Value in Excel 2007

Excel 2007 helps me estimate the amount I need to invest, in order to realize my dreams

Thermometer charts in MS Excel

Thermometer charts are very effective ways of presenting data in MS Excel as they facilitate data analysis and reporting in a very convenient manner.

Camera in Excel - Awesome

Have you been through this Camera in MS Excel?Have you heard of this? If yes, that’s excellent. If no then read on…

Using SUMPRODUCT in MS EXCEL

Using SUMPRODUCT in MS EXCEL alternatively….


In my previous post I took you through the basic use of SUMPRODUCT. In this post, I will explain how to use SUMPRODUCT effectively and alternatively in MS EXCEL.