MS Excel Intermediate Online.

This course will look specifically at :

• Creating Advanced Formulas
  • Apply range names
  • Use specialised functions
  • Link cells in different workbooks
• Analysing Data with Logical and Lookup Functions
  • Use text functions
  • Use logical functions
  • Use lookup functions
  • Use date functions
  • Use financial functions
• Organising Worksheet Data with Tables
  • Create and modify tables
  • Use Subtotal and Database functions to calculate data
• Analysing data with Pivot Tables
  • Create basic pivot table
• Enhancing Workbooks
  • Apply conditional formatting
  • Customise workbooks

In addition to the above, the trainer will focus on specific topics/queries that participants have.