Why 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.

Will the course work for both Windows and Mac?

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.

Do you have a guarantee?

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.

How do I access the course content?

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.

Why short videos?

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.