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 |
|
|