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.
Mastering Excel - the easy way...
Learn using Excel charts, functions and dashboards
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.
Subscribe to:
Posts (Atom)