Professional Training

Microsoft Excel 2016 - Advanced

Cosensa Learning and Development, In Belfast (+15 locations)
1 day
245 GBP excl. VAT
Next course start
26 June, 2024 (+4 start dates)
Course delivery
Virtual Classroom, Classroom
1 day
245 GBP excl. VAT
Next course start
26 June, 2024 (+4 start dates)
Course delivery
Virtual Classroom, Classroom
Leave your details so the provider can get in touch

Course description

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.

Upcoming start dates

Choose between 4 start dates

26 June, 2024

  • Virtual Classroom
  • Online
  • English

13 September, 2024

  • Virtual Classroom
  • Online
  • English

27 November, 2024

  • Classroom
  • Aberdeen
  • English

Enquire for more information.

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?

This course is ideally suited for individuals who have completed the Intermediate level programme and are determined to get the most out of this powerful spreadsheet and database package.

Outcome / Qualification etc.

On completion, delegates will be able to:

  • Create pivot tables and charts
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros
  • Import and export data

Training Course Content

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

Course delivery details

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.

In addition, the course is also suitable for those looking to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2016, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Request info

Contact course provider

Fill out your details to find out more about Microsoft Excel 2016 - Advanced.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Cosensa Learning and Development
Innovation Factory
385 Springfield Road
BT12 7DG Belfast

Cosensa Learning and Development Training Courses

Cosensa Learning & Development offers training courses for professionals and organisations throughout the public, private and third sectors. All Cosensa trainers are highly qualified, with extensive experience in training and coaching. Cosensa's wide range of open courses are delivered throughout...

Read more and show all courses with this provider