Modelling and Spreadsheets

Basic (Level 1)

• Basic Functions and formula
  • Sum
  • Count
  • Count if
  • If
  • Average
  • Min
  • Max
• Modifying data types
• printing - page setup features
• logical operators
• Graphs and charts
• Table
• Basic filters

Advanced (Level 2)

• Sort / Filter
• Text manipulation formulae
• Mail merge

Complex (Level 3)

• Managing multiple worksheets
• Lookup tables
• Financial formulae