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 (located on the second floor of the Supreme Steel building)
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.
This training is for anyone who wants to increase their Microsoft Excel skills.
Where will the workshop be taking place?
At the Morris Interactive Learning Centre (located on the second floor of the Supreme Steel building).
Map Links: Google Maps Link / Apple Maps Link
Will lunch be served?
No, but there will be coffee break refreshments. We recommend bringing your own lunch as we only have a half hour break to go to a nearby restaurant.
Do we have to pay for parking?
No, the Morris Interactive Learning Centre (located on the second floor of 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.
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 1 week 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. Contact us for more information.
.svg){kind=small}
