The Time Saver in MS Excel      

Powerutils Addin
 

Home Page

Powerutils Help

DownLoad

Tips & Tricks

Great Links

Excel Learnings

 Powerutils 1.9 is now available for download containing 99 utils.

Tutorials for Excel & Visual Basic for Application.

Tutorials for the below given topics are available here. Attempt has been made to keep the language simple so that even a new Excel User can become an expert in a very quick span of time.

Excel Functions

Srl No. Topic Status/Link
1. Vlookup - Used for looking up data from a large data range in Excel.

Complete

2. If , And , Or - These are very useful excel functions to get data based on multiple criteria.

Complete

3. Sumif and Countif Functions

Complete

4. Sumproduct  
5. String manupulation & Concatenation  
6.    

Visual Basic For Application

Srl No. Topic Status/Link
1. 1st Day with Excel Programming in VBA (Very basic tutor) Will be done by Aug'04
2. Working with Cells, Range ... Copying and Moving data.  
3. Moving from Cell to Cell ... various methods  
4. Cell Data Analysis  
5. Looping and Decision making  
6. Arrays