Microsoft Excel Level 2 Training - Virtual

This course builds on foundational Excel skills. Participants will expand their ability to manage larger data sets, apply advanced formulas and functions, work with tables and lists, create more complex charts, and use Excel’s built-in analysis tools. By the end of this course, users will be equipped to analyze, summarize, and present data in ways that support more effective business decisions.

Note: This is a virtual course delivered online. Access details and joining instructions will be emailed to registered participants prior to the session.

Course Content:

Lesson 1: Working with Functions

Work with Ranges

Use Specialized Functions

Work with Logical Functions

Work with Date and Time Functions

Work with Text Functions

Lesson 2: Working with Lists

Sort Data

Filter Data

Query Data with Database Functions

Outline and Subtotal Data

Lesson 3: Analyzing Data

Create and Modify Tables

Apply Intermediate Conditional Formatting

Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

Create Charts

Modify and Format Charts

Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

Create a PivotTable

Analyze PivotTable Data

Present Data with PivotCharts

Filter Data by Using Timelines and Slicers

Who Is This For?

This training is for anyone who wants to increase their Microsoft Excel skills.

Frequently asked questions

Where will the workshop take place?
This is a virtual course delivered online. Access details and joining instructions will be emailed to registered participants prior to the session.

What time zone is the course scheduled in?
All sessions are delivered in Central Standard Time (CST).

Virtual Event Access?

This course will be delivered live via Microsoft Teams. The Microsoft Teams meeting link will be shared with registered participants prior to the event. Please ensure you have access to Microsoft Teams and a stable internet connection on the day of the session.

Is lunch provided?
No. As this is a virtual course, lunch is not provided.

What do I need to participate?
You will need:

• A computer with Microsoft Excel installed (any current version of Microsoft Office)
• A stable internet connection
• Speakers or headphones

Will I receive joining instructions?
Yes. A calendar invitation and virtual meeting link will be sent to you ahead of the course.

Can I pay by cheque or invoice?

To offer a more streamlined experience, as of April 1, 2025, we are only accepting credit card payments for our conferences. Contact us for more information.