Microsoft Excel 2016 - Advanced

I.T. Training

Course Duration: One day

Course Overview

Our Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyse worksheet data, utilise data tools, collaborate with others, and create and manage macros.


Module 1 – Nested IF/Lookups

  • IF Functions recap
  • Nested IF
  • Lookup
  • Match/Index

Module 2 – Pivot Tables and Auditing
  • Subtotal/Pivot Tables
  • Subtotal
  • Pivot Tables
  • Pivot Charts
  • Auditing
  • Precedents/Dependants
  • Error Checking
  • Calculate Formula
  • Watch Window

Module 3 – WHAT IF
  • Goal Seek
  • Solver
  • Scenario Manager
  • Data Tables

Module 4 – Macros (Optional for In-house delivery)
  • Security
  • Recording & Running Macros
  • Macro Buttons/Toolbars
  • Relative References
  • Modifying VBA Code

Learning outcomes

Who should attend


Course benefits

Pre-course work

Other courses to consider


Microsoft excel advanced training near me

Looking For Pricing Information?

Call +44 (0) 28 9043 9624
Or Book Online

View Full Course List

View Full Course List

Microsoft Excel 2016 - Advanced

Book Now

We are here to help!

For any queries regarding any of our courses please Contact us at enquiries@cosensa.co.uk

Please click here for more information on how we use cookies on this website