Topics covered in this workbook...

  • Templates
  • Worksheet Techniques
  • Worksheet Tables
  • Conditional Formatting
  • Special Pasting
  • Number Formatting Techniques
  • Sorting Data
  • Filtering Data
  • Summarising and Subtotalling
  • Data Consolidation
  • Data Linking
  • Pivot Tables
  • PivotTable Techniques
  • Validating Data
  • Importing and Exporting
  • Recorded Macros
  • Charting Techniques
  • Labels and Names
  • Text Functions
  • Date and Time Functions
  • Maths Functions
  • Statistical Functions
  • Financial Functions
  • Lookup Functions
  • Logical Functions
  • Advanced Filters
  • Formula Techniques
  • Formula Referencing
  • Data Tables
  • Formula Auditing
  • Scenarios
  • Protecting Data
  • Sharing Workbooks