Quick, clean, and to the point
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Dynamic Array Formulas

Dynamic Array Formulas

Dynamic Arrays are a huge upgrade that makes Excel formulas more powerful than ever. With Dynamic Arrays, you can extract unique values, sort and filter data, lookup multiple values, and build dynamic lists that instantly respond to new information. This course covers new functions in Excel that leverage dynamic arrays directly (FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, RANDARRAY, and XLOOKUP) and Boolean algebra, the logic used to apply criteria in modern formulas.

Note: Dynamic Array Formulas are only available in Excel 365/2021.


Your Satisfaction Guaranteed