Excel – Advanced

½ Day [3hrs] Hands On Training Course

Designed for experienced users of Excel this session jumps straight into more advanced tools in Excel such as creating templates, protecting sheets and cells and templates and macros to automate common tasks.


This session is best run hands on with participants utilising a computer

What You Will Cover:

  • Security & Protection including protecting worksheets
  • Circular References and auditing tools
  • Linking multiple sheets and files
  • Editing & Changing links
  • Data consolidation
  • Importing & Exporting
  • Pivot Tables
  • Macros

Download this outline as a PDF.

Microsoft Excel Advanced – 3hr