Table of Contents

  1. Overview of Excel 2016 
  2. Cell References and Range
  3. Working with Formulas and Functions 
  4. Data Validation 
  5. Protection 
  6. Sorting a Database
  7. Filtering a Database 
  8. Subtotals
  9. Pivot Tables 
  10. Conditional formatting 
  11. What-if-Analysis Tools  
  12. Working with Multiple Worksheets, Workbooks and Applications
  13. Working with Charts 
  14. Macros