Menu

Excel

Microsoft Excel Topics

Excel Basic CourseĀ 

  1. What is Excel?
  2. Open Excel Sample Files
  3. Excel Interface
  4. Adding Buttons to QAT
  5. Customizing the Ribbon
  6. Open Workbook (New-Existing- Temp)
  7. Saving a workbook
  8. Data Selection & Navigation
  9. Split & Freeze
  10. Enter, Edit & Delete data
  11. Find, Replace, Proofing
  12. Copy, Cut & Paste
  13. Formatting (FANS)
  14. Styles & Themes
  15. Conditional Formatting
  16. Basic Formulas
  17. Basic Charting
  18. Printing: Page Layout – Header
  19. Page Break Preview
  20. Getting Help with Excel

 

Excel Intermediate Course

  1. What is a Formula?
  2. Basic Formulas
  3. Order of Operation
  4. Relative & Absolute Reference
  5. Basic & Intermediate Functions
  6. Formula Auditing
  7. Naming
  8. Sort & Custom Lists
  9. Filtering Data
  10. Data Validation
  11. Lists & Tables
  12. Structured Reference
  13. Illustrations – Smart Art
  14. File Properties & Info Panel
  15. Hiding Workbooks
  16. Advanced Customization
  17. Protecting Sheets
  18. Protecting Workbook
  19. Hiding Formulas
  20. Custom Views

Excel Advanced Course

  1. Summarizing data using Outline
  2. Summarizing data using Subtotal
  3. Combining data using Consolidation
  4. Pivot Tables
  5. Pivot Charts
  6. Advanced Pivot Tables
  7. Filtering Pivot Tables
  8. Sparklines
  9. Create Scenarios
  10. Using Goal Seek
  11. Variable Data Tables
  12. Using the Solver
  13. Linking & Embedding
  14. Getting External Data
  15. Sharing – Tracking Changes
  16. Combining Worksheets
  17. Creating Macros
  18. Advanced Macros
  19. Creating Forms
  20. Assign a Macro To a Control