Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This seminar focuses on getting in depth with some of Excel’s most powerful features, mostly introduced through Office 365. It begins with advanced spreadsheet concepts. The seminar then moves on to advanced formula building with some of the most powerful functions ever to be introduced in Excel. We round off with an in-depth look at Power Pivot and the powerful features that come with it when used with Pivot Tables. This seminar is ideal for those who have a fair degree of proficiency in Excel already.
Schedule
- August 13, 2026, 8:30 a.m. - 12:30 p.m.
- August 14, 2026, 8:30 a.m. - 12:30 p.m.
Key Takeaways
By the end of this course, participants will be able to understand:
- Advanced Spreadsheet Concepts – Named Ranges, Structured References, Array Constants, Logic Statements.
- Advanced Formula Types – Introducing the newer Dynamic Array Formula, Spill ranges and references.
- Dynamic Array Functions – Exploring a range of functions like VSTACK, SEQUENCE, FILTER, XLOOKUP, LAMBDA and more.
- Power Tools – Exploring the power of Power Pivot and the Data Model and their use when working with multiple data sets.
- Power Tools – Getting to grips with advanced features like Measures, DAX functions, and Named Sets when using Pivot Tables and Power Pivot.
Who Will Benefit
This course is expected to benefit those who have proficiency in Excel and are comfortable with various formulas and Pivot Tables. It will help those who find existing formulas and processes cumbersome in analysing large amounts of data.
How to Access the Course
This course is delivered as a live webinar. To receive verifiable CPD hours, you must attend the session live. We recommend joining at least 5 minutes before the scheduled start time. For the best interactive experience, please use a computer equipped with a camera and microphone.
A reminder email with the Zoom link and course details will be sent two business days before the session. If you do not receive it, please check your spam or junk folder.
The same information, including any available materials, will also be posted in advance on our Blackboard LMS.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Paul Mascarenhas, BSc. MBA., President of Avancer Learning Inc., is a specialist in Strategic Analysis, and Communications. Paul has conducted his much sought after brand of hands-on IT Skills workshops, to globally renowned names as the Canadian Forces, Canadian Tire, Carlson Wagonlit, SKF Bearings (I) Ltd, CGI Inc, Scotiabank, Colgate Palmolive GSSO, Tetra Pak (I), ICICI Prudential, to name a few.