Over the years, Microsoft Excel has evolved from a simple spreadsheet tool into an extremely powerful calculation engine. In this course, instructor Alan Murray helps you learn how to use modern features like dynamic arrays, LET, and LAMBDA to write cleaner, more efficient formulas for data analysis. Build a foundation with Excel tables and structured references, then explore functions like FILTER, SORT, and UNIQUE for dynamic results. The course also covers data-shaping tools like CHOOSECOLS and XMATCH, combining datasets with TRIMRANGE and VSTACK, and iterative functions—BYROW, MAP, and SCAN—for row-wise calculations without helper columns. You’ll finish by learning how to use LET for reusable formulas, GROUPBY and PIVOTBY for single-cell reporting, and LAMBDA to build custom functions.
This course was created by Alan Murray and Microsoft Press. We are pleased to host this training in our library.
Learn More