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 (located on the second floor of the Supreme Steel building)
Note: Lunch is included with your registration.
Course Content:
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.
Who Is This For?
This training is for anyone who wants to increase their Microsoft Excel skills.
Note: We are currently in the process of making our Learning Centre wheelchair-accessible. To help us prepare for your attendance, please contact us regarding mobility needs before registering. Email us at info@morrisinteractive.ca or call (866) 955-3006.
Frequently asked questions
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?
Yes. Lunch is included with your registration.
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.
Is the Morris Interactive Learning Centre wheelchair accessible?
At this time, the Morris Interactive Learning Centre is not wheelchair accessible. We sincerely apologize for this limitation and want to make sure all attendees are informed in advance.