Learn many of Excel’s advanced tools for analyzing and reporting on your data
Excel 365 gives experienced users a set of tools that reach beyond basic formulas and formatting into automated analysis and dynamic reporting. Dynamic array functions let a single formula return results across a range of cells, and newer lookup and filtering functions such as XLOOKUP and FILTER pull and arrange data while leaving the original source intact. Combined with data validation, controls, and interactive filters, these features let practitioners build workbooks that stay accurate and update themselves as the underlying data changes. This course brings those capabilities together for users who already work comfortably in Excel and want to handle larger datasets efficiently and with greater accuracy.
The program works through advanced functions including SORTBY, MATCH, INDEX, SUMIFS, CONCAT, RANDARRAY, FILTER, and XLOOKUP, along with the criteria-based family of SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS. It shows how to bring external data into a workbook through the Text Import Wizard and the comma separated values (CSV) format, and how to keep that data consistent using data validation. Participants add interactivity with slicers, timelines, and form controls, and present results through radar, combo, and dual axis charts. The course also covers building reusable templates, recording and running macros while accounting for the security risks of code from outside sources, and formatting PivotTables. It closes with guidance on accessibility checking, keyboard shortcuts, and the recording habits that keep a workbook accurate.
Learning Objectives
This course is designed for experienced Excel users working in Microsoft 365. It assumes familiarity with basic formulas, formatting, and PivotTables, and reflects the features available in the 2025 version of the application.
9 activities • 42 videos • duration: 4h 23m
Powering Productivity, One Brain at a Time!
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.
Certified Trainer
Kathy is a Microsoft Certified education/training professional with experience in all aspects of training. Her strengths include classroom presentations, organizational skills, problem-solving, program design and development, and interpersonal communication.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
