Module 01 – ANALYZE DATA

  1. Workbook (Pdf)
  2. Overview
  3. Sort And Filter
  4. Conditional Formatting
  5. Outline And Subtotals
  6. Tables
  7. Data Tables
  8. Consolidate Data
  9. Scenarios
  10. Goal Seek
  11. Remove Duplicates
  12. Advanced Filter
  13. Review Quiz (Number of attempts allowed: Unlimited)

Module 03 – COLLABORATION AND SECURITY

  1. Workbook (Pdf)
  2. Shared Workbooks
  3. Track Changes
  4. Data Validation
  5. Workbook Security
  6. Document Properties
  7. Review Quiz (Number of attempts allowed: Unlimited)

Module 02 – GRAPHICAL ELEMENTS

  1. Workbook (Pdf)
  2. Image: Basics
  3. Images: Format
  4. Shapes: Add And Format
  5. Shapes: Multiple Shapes And Icons
  6. Smart Art
  7. Create An Invitation
  8. Review Quiz (Number of attempts allowed: Unlimited)

Module 04 – ADDITIONAL TOPICS

  1. Workbook (Pdf)
  2. Customize Interface
  3. Review Quiz (Number of attempts allowed: Unlimited)