This course builds on the skills from Excel Level 2. Participants will work across multiple sheets and workbooks using links, external references, and 3D references, then consolidate data for clear reporting. They will collaborate on shared files and apply protection to keep content secure. They will streamline work with data validation, find and fix invalid entries and errors, and record simple macros to automate steps. They will deepen analysis with lookup functions and dynamic arrays, and use formula auditing tools to trace, watch, and evaluate results. They will explore what if analysis with data tables, scenarios, and goal seek, forecast trends, and present insights with sparklines and maps. By the end of this course, users will manage complex workbooks with confidence, automate routine tasks, audit formulas, and present findings that support better decisions.
Location:
Morris Interactive Learning Centre (Inside the Supreme Steel building)
1 North Corman Industrial Park, Saskatoon, SK S7K 8C1
Lesson 1: Working with Multiple Worksheets and Workbooks
Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macros
Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Topic A: Use Lookup Functions
Topic B: Use Dynamic Arrays and Dynamic Array Functions
Topic C: Trace Cells
Topic D: Watch and Evaluate Formulas
Lesson 5: Forecasting Data
Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends
Lesson 6: Creating Sparklines and Mapping Data
Topic A: Create Sparklines
Topic B: Map Data
*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 Excel skills.
Where will the workshop 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 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 (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.
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. Contact us for more information.
.svg){kind=small}
