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.
Using SUMPRODUCT in MS Excel effectively
Microsoft Excel is a magical platform made by Microsoft. But unfortunately many of us fail to harness its utility.
Today I am going to explain you how to use the SUMPRODUCT function of excel and reduce your precious time while working on MS Excel.
Today's gift to you
My today's
gift to you.....
You always thought of making PDFs on your own but couldn't find
the source to do so.
- Post download run the downloaded file. Open MS Word or Excel
- Click on File
- Choose Save as (choose location where you wish to save you PDF)
- Select PDF
- Click Publish
Enjoy making PDFs..
Subscribe to:
Posts (Atom)