Microsoft Excel Training Level 2- Saskatoon

This course builds on the foundational skills from Excel Level 1. 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.

‍

Location:

Morris Interactive Learning Centre (Inside the Supreme Steel building)

1 North Corman Industrial Park, Saskatoon, SK S7K 8C1

‍

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

‍

*Please note No Laptop Required. A laptop with the required system pre-installed will be provided for you, along with a charger.

‍

Who Is This For?

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

‍

Frequently asked questions

Where will the conference be taking place?

At the Morris Interactive Learning Centre (inside the Supreme Steel building) 1 North Corman Industrial Park, Saskatoon, SK S7K 8C1

Will lunch be served?

No (but there will be coffee, tea, and muffins) We recommend bringing your own lunch or going to a nearby restaurant.

Do we have to pay for parking?

No, the Morris Interactive Learning Centre (inside the Supreme Steel building) has free parking.

What do I need to bring?

You don’t need to bring anything. A laptop with the required system pre-installed will be provided for you, along with a charger.

If I don’t attend, will I get a refund?

To offer a more streamlined experience for all participants, we do not offer refunds.

Can I bring a friend or colleague with me?

Of course! As long as they have been registered at least 2 weeks prior and paid for their seat. (Unless the workshop is at capacity).

Can I pay for my seat after attending the training?

Sorry, your seat is only confirmed once payment has been received.

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.

‍