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.
Dynamic Array formulas are only available in Excel Office 365. This is is the subscription version of Excel, which always has the latest features. An easy way to check if you are using this version of Excel is check if you have the UNIQUE function. If you have UNIQUE, you have Dynamic Arrays.
Dynamic Arrays are the coolest and most useful addition to Excel formulas in years, maybe ever. Dynamic Arrays make it easy to build array formulas to handle multiple values at the same time, solving many complex problems in an elegant way. You can now build formulas that filter, sort, and extract data with a clean, logical syntax. Dynamic Arrays are the future of reports, models, and dashboards that need to respond to changes instantly.
Yes. Dynamic Array formulas work on both Windows and the Mac, as long you use the 365 version of Excel. Videos were recorded in Excel 365 on Windows 10. All videos show shortcuts for both Windows and Mac.
Of course! If you aren't satisfied, just let us know within 30 days and we'll issue a full refund. We want you to be completely happy.
When you purchase the course, an account will be created for you automatically on the Exceljet website. You will receive an email immediately with login information. When you log in, you'll have full access to all videos and practice worksheets.
You must learn Excel by doing, there is no other way. Our videos are short and focused, so you can immediately practice what you've learned, and come back any time for a quick refresher.