We have created 15 movies which you can play, pause and replay to study Excel step-by-step at your leisure. Each movie deals with a unique topic. The movies cover most aspects of Excel that a user needs in day to day work. More movies will be added from time to time to help you master Excel. Enjoy!
If you have an idea how to improve or correct any existing errors, we would love to hear from you.
1. Introduction to Excel
2. Basic Excel Calculations
3. Using AutoFill in Excel
4. AutoFilter
5. Advanced Filter
6. Creating a chart in Excel
7. Conditional Formatting
8. 'IF' Function
9. Multiple 'IF'
10. Calculation of equal monthly instalments on a loan taken - the 'PMT' function in Excel
11. Using Solver
12. Recording a macro
13. Checking the code of the recorded macro
14. writing own VBA Macro code
15. Pivot Tables
Family Computer Club,
no.9, Savitri Cinema Commercial Complex,
Greater Kailash-2,
New Delhi-110048 Ph: 29213339 Mobile: 9810081867
Contact person: Dr. Dinesh K Takyar
Any Queries?
Good learning solutions!