Ashraf_Ali Profile

Latest Blog Posts

• Creating Tables in Excel that are dynamic in nature
  on Jun 29, 2012 in Benefit from this
  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. To insert a table in your spreadsheet do the foll...
• Concatenate function in MS Excel to join text strings
  on Jun 22, 2012 in Functions
  Data 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 Excel
  on Jun 21, 2012 in Functions
  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. Syntax of the IF functi...
• Filter in MS Excel 2007
  on Jun 18, 2012 in Functions
  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. Imagine a file of 2500 rows having data of...
• Future Value in Excel 2007
  on Jun 15, 2012 in Functions
  Excel 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 Excel
  on Jun 11, 2012 in Charts
  Thermometer 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 - Awesome
  on Jun 7, 2012 in Discover Excel
  Have 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 EXCEL
  on Jun 6, 2012 in Functions
  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. SUMPRODUCT can also be used to f...
• Today's gift to you
  on Jun 5, 2012 in Discover Excel
  My 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 effectively
  on Jun 5, 2012 in Functions
  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...
• Health Insurance - a boon
  on Jun 3, 2012 in Benefit from this
  Many 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...
• Insurance
  on Jun 2, 2012 in Benefit from this
  Insurance – 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 this
  Is 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...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment

Log in or Register to place a comment