Complete Guide To Next Gen Excel Formulas For Data Analysts By Microsoft Press
 

Discover a comprehensive guide to modern Microsoft Excel formulas, in this course designed uniquely for data analysts by Alan Murray.
Course details
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 LAMB DA 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 LAMB DA to build custom functions.This course was created by Alan Murray and Microsoft Press. We are pleased to host this training in our library.