free Excel training

Free Excel training videos including Macros

"One cannot learn anything so well as by experiencing it oneself." - Albert Einstein

We have created 63 videos (including Macros) which you can play, pause and replay to study Excel step-by-step at your leisure. Each movie deals with a unique topic in Excel. The videos cover most aspects of Excel that a user needs. More movies will be added from time to time to help you master Excel. To achieve best results in your study of Excel, please keep your MS-Excel 2003 open for immediate reference. Also please remember that some videos are large files and may take some time to download. Be patient and enjoy! Our Excel training videos are also available on youtube.com or at our blog. You can write to us if you have any queries regarding Excel.

1. Introduction to Excel
2. Basic Excel Calculations
3. Using AutoFill
4. AutoFilter
5. Advanced Filter
6. Creating a chart
7. Conditional Formatting
8. 'IF' Function
9. Multiple 'IF'
10. Calculation of equal monthly installments
11. Using Solver
12. Recording a macro
13. Checking the code of the recorded macro
14. Writing VBA Macro code
15. Pivot Tables
16. Array Formulas
17. Importance of 'correct' data entry
18. Data validation
19. Validation using 'lists'
20.Importing Text files
21. Importing Data from MS-Access
22. Using 'named' ranges
23. DSUM - a versatile function
24. Vlookup
25. Text Manipulations
26. Macros - A 'do while loop
27.Forecast worksheet function
28. Calculation of 'depreciation' of an asset
29. Calculation of 'Growth'
30. Exporting Data from Tally 9 (Accounts)
31. Exporting Excel charts to PowerPoint
32. Calculating Time
 33. Working with dates
34. Macros: Creating a new workbook with code
35. Macros: Opening a workbook
36. Macros: Referring to sheets by Index Number
37. Macros: Referring to sheets by name
38. Macros: Referring to cells and ranges using the A1 notation
39. Macros: Referring to cells using index numbers
40. Macros: Referring to rows and columns
41. Macros: Referring to cells by using shortcut notation
42. Macros: Referring to named ranges
43. Macros: Referring to cells relative to other cells
44. Macros: Referring to cells by using a range object
45. Macros: Referring to all cells on the worksheet
46. Macros: Referring multiple ranges
47. Macros: Looping through a range of cells
48. Macros: Selecting and activating cells
49. Macros: Working with 3-D Ranges
50. Working with active cells
51. Using a command button in an Excel document
52. Macros: Calling a Worksheet Function
53. Macros: Calculating Equal Monthly Instalments (EMIs)
54. Macros: Creating a custom dialog box - Step 1
55.Macros: Adding controls to a user form
56. Macros: Adding code to controls on a user form
57. Macros: Calendar tool
58. Macros: Using the date and time picker tool
59. Creating an interactive web page
60. Analyzing Access data
61. Macros: An interesting 'for' loop
62. Another interesting 'for' loop
63. Macros: Using a 'for' loop with the CurrentRegion property
64.Macros: Saving a Document as a Web Page


Family Computer Club,
no.9, Savitri Cinema Commercial Complex,
Greater Kailash-2, New Delhi-110048, India
Get in touch!

My Search

Best viewed with IE with a screen resolution of 1280x768