Advertisements

Excel Tutorial: Introduction to VLOOKUP, INDEX and MATCH functions

Excel has several  lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH.

Advertisements

Recover MS Word and MS Excel password Easily

If you have lost your password for any MS Word or Excel document and are unable to recover it, try using this Free Word / Excel Password Recovery application. It’s a freeware product and all you need to do is install it, open the file that you need to recover. Choose the character set “a to z” and the expected lenght of your password and click GO.

Excel Tutorial: SUMIF with Multiple Conditions

The title of the post is a bit of a misnomer because the SUMIF function in Excel does not allow you to have more than condition. Excel 2007 introduced the SUMIFS function which allowed for multiple conditions. However, if you are using any version prior to Excel 2007 or if the persons who will be using your Excel workbook will be using a version prior to Excel 2007, then the SUMIF function will throw up an error.