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.
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 be taking 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).
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, and speakers or headphones
If I don’t attend, will I get a refund?
To offer a more streamlined experience for all participants, we do not offer refunds.
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 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. Contact us for more information.
Which course platform will be used?
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.