Available courses

T001_Excel Basic

This course will deal with the following topics:

  1. Excel Interface
  2. Excel Options
  3. Mouse Pointer Shapes
  4. Mouse Selection Techniques
  5. Entering and Editing of Data
  6. Working with Sheets
  7. Working with Rows and Columns
  8. Copy and Paste and Insertion of Text
  9. Autofill
  10. Formatting of Cells
  11. Basic Calculations
  12. Working with Functions
  13. Sorting
  14. Paste Special

T002_Excel Intermediate

This course will deal with the following topics:

  1. Cell References
  2. Count
  3. Logical Functions
  4. PMT Function
  5. What-IfAnalysis (Goal Seek)
  6. What-IfAnalysis Data Tables)
  7. Validation
  8. Filter
  9. Conditional Format
  10. Charts
  11. Headers and Footers
  12. Subtotals
  13. Links
  14. Printing
  15. Protection
  16. Switch between Excel Spreadsheets only
  17. Use Ctrl +Enter to Fill an Entire Range
  18. Copy Formula on Clipboard to be used later
  19. Finding and Removing Blanks
  20. Snap Objects to Cell Borders
  21. Sort According to a Custom List
  22. Enter Bullets in Excel
  23. Autofil Growth Trend

T003_Excel Advanced

This course will deal with the following topics:

  1. Freeze Panes
  2. Removing Duplicates
  3. Match
  4. Logical Functions
  5. Count
  6. Lookups
  7. Tables
  8. Slicers
  9. Sparklines
  10. SheetVeryHidden
  11. Pivot Tables
  12. Macro's
  13. Join the content of two or more cells
  14. IFERROR Function
  15. Enable date entry only when the previous cell is filled
  16. Random Numbers
  17. Conditional Validation or Dependent drop down list
  18. Flash Fill
  19. Most Frequently Occuring Value