Search

Microsoft Office Excel 2019/2021 – Part 3

CODE: ITMS03

DURATION: 3 Days/5 Days

CERTIFICATIONS: CPD

  • Modern facilities
  • Course materials and certificate
  • Accredited international trainers

3 Days

$ 2690

5 Days

$ 3310

Course Overview

This course builds on foundational and intermediate Excel knowledge, helping you maximize your Excel skills. You’ll learn to collaborate, automate tasks, and use conditional logic and dynamic arrays for advanced formulas. By automating complex tasks, you can focus on analyzing your organization’s data. The course prepares you for the Excel Associate (MO-200) and Excel Expert (MO-201) certifications.

Course Delivery

This course is available in the following formats:

Virtual

Classroom

Request this course in a different delivery format.

Course Outcomes

Upon successful completion of this course, you will be able to:

Perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Work with multiple worksheets and workbooks.

Share and protect workbooks.

Automate workbook functionality.

Use Lookup functions, dynamic arrays, and formula auditing.

Forecast data.

Create sparklines and map data.

Key Course Highlights

At the end of this course, you’ll understand:

  • Building on foundational and intermediate Excel knowledge
  • Collaborating with colleagues using advanced Excel features
  • Automating complex or repetitive tasks
  • Using conditional logic and dynamic arrays to construct elaborate formulas
  • Focusing on extracting meaningful insights from large data sets
  • Preparing for the Excel Associate (MO-200) and Excel Expert (MO-201) certifications
  • Enhancing Excel skills to work efficiently with extensive data and automate processes
Who Should Attend

This course is intended for delegates who are experienced Excel 2021 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

Upcoming Course Dates

Delivery Format: Classroom & Virtual

Date: 02/06/2025

Location: London

Delivery Format: Classroom & Virtual

Date: 06/10/2025

Location: London

Microsoft Office Excel 2019/2021 – Part 3

✓ Modern facilities

✓ Course materials and certificate

✓ Accredited international trainers

✓ Training materials and workbook

✓ Access to online resources

Your request has been sent the team will get back to you within 24 hours

Download Course Detail