Ashraf_Ali Profile

Ashraf
Join Date:
2012-06-28
Blogs Owned
1. Mastering Excel - the easy way...
Excel functions and charts aims to help and assist all the Microsoft excel user - the easy way... in their presentations and day to day work.
Latest Blog Posts
- Creating Tables in Excel that are dynamic in natureon Jun 29, 2012 in Benefit from thisExcel 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. To insert a table in your spreadsheet do the foll...
- Concatenate function in MS Excel to join text stringson Jun 22, 2012 in FunctionsData management becomes a tiresome task if we are unaware of some really useful functions in Excel.Concatenate function is used to join two or more text strings in Excel. For example, if we have certain strings in different cells as given below...
- IF function in MS Excelon Jun 21, 2012 in FunctionsIF 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. Syntax of the IF functi...
- Filter in MS Excel 2007on Jun 18, 2012 in FunctionsFilter 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. Imagine a file of 2500 rows having data of...
- Future Value in Excel 2007on Jun 15, 2012 in FunctionsExcel 2007 helps me estimate the amount I need to invest, in order to realize my dreams You always plan to save for your favorite car, marriage, child education, getting that glittering diamond ring, purchasing your dream house, etc. But do not k...
- Thermometer charts in MS Excelon Jun 11, 2012 in ChartsThermometer charts are very effective ways of presenting data in MS Excel as they facilitate data analysis and reporting in a very convenient manner. Thermometer charts are used to analyze set targets against the individual/team performances. To...
- Camera in Excel - Awesomeon Jun 7, 2012 in Discover ExcelHave you been through this Camera in MS Excel?Have you heard of this? If yes, that’s excellent. If no then read on… Your MS Excel 2007 has a built in hidden camera. This camera may be used to capture the images of data in an excel sheet. You...
- Using SUMPRODUCT in MS EXCELon Jun 6, 2012 in FunctionsUsing 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. SUMPRODUCT can also be used to f...
- Today's gift to youon Jun 5, 2012 in Discover ExcelMy today's gift to you..... You always thought of making PDFs on your own but couldn't find the source to do so. Find below the link for PDF plugin for MS office 2007 and enjoy saving your files as PDF. Click to download Post download r...
- Using SUMPRODUCT in MS Excel effectivelyon Jun 5, 2012 in FunctionsMicrosoft 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...
- Health Insurance - a boonon Jun 3, 2012 in Benefit from thisMany people I come across tell me that health insurance is of no use. In their opinion since most of the Health policies are useless just because they do not cover expenses incurred on medical examinations for diagnosis until and unless the patient...
- Insuranceon Jun 2, 2012 in Benefit from thisInsurance – an easy or a tough decision This time I am going to talk to you about life insurance. How many of you understand probability? Probability is defined as the chance of happening of a certain event. You must be wondering how insura...
- Is firing the only solution????on Jun 2, 2012 in Benefit from thisIs firing the only solution???? Corporate sector has finally started to feel the heat of global slowdown. Financial results for the first three quarters of 2011-12 were disheartening. Although the fourth quarter has seen some improvement...