Microsoft Excel Advanced Level 2 – 3hr

½ 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:

  • Nesting Functions using IF and AND/OR
  • Working with Text functions
  • Concatenate
  • Proper
  • Text to Columns
  • Paste Values
  • Advanced Filtering
  • Data Base Functions – DSUM, DAVERAGE
  • Scenario Manager
  • Goal Seek

Download this outline as a PDF.

Microsoft Excel Advanced Level 2 – 3hr