Dynamic Array Formulas

Dynamic Array Formulas are one of the biggest changes to Excel ever. They completely change the way you solve hard problems in Excel, with excellent new functions and an upgraded formula engine that can return multiple results at the same time. With Dynamic Arrays, you can extract unique values, sort and filter data, look up multiple values, split text values effortlessly, and build dynamic lists that instantly respond to new information. This course covers new functions in Excel that leverage dynamic arrays directly, including FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, RANDARRAY, TEXTAFTER, TEXTBEFORE, TEXTSPLIT, and XLOOKUP. It also covers Boolean logic, a useful way to perform conditional sums and counts in modern array formulas. Note: Dynamic Array Formulas are only available in Excel 365 and Excel 2021.