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
- September 15, 2025, 8:30 a.m. - 12:30 p.m.
- September 16, 2025, 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 a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
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.