Mastering Excel - the easy way...

Learn using Excel charts, functions and dashboards

Pages

Showing posts with label Charts. Show all posts

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 conveni...
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,...
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 t...
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 sug...
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 da...
Future Value in Excel 2007

Excel 2007 helps me estimate the amount I need to invest, in order to realize my dreams
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 ...
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…
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....