Microsoft Excel - Intermediate

This course is aimed at users who have a basic knowledge of Microsoft Excel and would like to progress in this area.

Description

  • V-Lookup 
  • IF Statements 
  • Sum-IF
  • Count-IF
  • Text Formula 
  • Linking Spreadsheets 
  • Advanced sort options 
  • Filters 
  • Subtotals 
  • Pivot Tables 
  • Modifying Pivot Tables 
  • Updated Pivots 
  • Conditional Formatting 
  • Protecting Data 
  • Hide and Unhide Data 
  • Named Ranges 
  • Working with Dates 
  • Working with comments 
  • Data Validation 
  • Headers and Footers