Advanced Excel: 

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.

The course covers:

  • 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

    Please contact us for further information or you can book below via Eventbrite to secure your place on our next course.