Advanced Microsoft Excel

The course is designed for delegates who have a very good knowledge of Excel, or who have attended the Intermediate course.

At the end of the course delegates will be able to use different ways to consolidate and link data, use advanced functions and other powerful features to summarise, analyse and query data

  • Create and use templates
  • Recap absolute cell references and naming cells
  • Use advanced functions
  • Financial functions
  • Database functions
  • Lookup tables
  • Sub-total data
  • Create and use pivot tables and charts
  • Add data validation to a worksheet
  • Understand the different ways of consolidating and linking data; using the Data Consolidate feature
  • Protect cells and workbook
  • Create and use Hyperlinks
Level: Advanced