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. Shapes: Add And Format
  14. Review Quiz (Number of attempts allowed: Unlimited)

Module 03 – COLLABORATION AND SECURITY

  1. Workbook (Pdf)
  2. Shared Workbooks
  3. Track Changes
  4. Collaborate With Co-Authoring
  5. Co-Authoring: Troubleshooting
  6. Co-Authoring: Troubleshooting Part 2
  7. Version History
  8. Data Validation
  9. Workbook Security
  10. Document Properties
  11. Review Quiz (Number of attempts allowed: Unlimited)

Module 02 – GRAPHICAL ELEMENTS

  1. Workbook (Pdf)
  2. Images: Basics
  3. Images: Format
  4. Arrange Images And Shapes
  5. SmartArt
  6. 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)