Supercharge Excel with Dynamic Array Functions & Formulas
Author:
Categories:
Last updated:
April 2025
Overview
Structure
Total sections: 3
Total lessons: 20
1. Introduction
2 lessons
2. Dynamic Array Functions in Excel
5 lessons
3. Where To Go From Here?
0 lessons
4. Combining FILTER, CHOOSECOLS and SORT
lessons
5. FILTER II
lessons
6. FILTER III
lessons
7. Refactoring with Tables
lessons
8. Refactoring with LET
lessons
9. Project 1 - Introduction
lessons
10. Project 1 - Solution
lessons
11. Combining FILTER, UNIQUE and SORT
lessons
12. Referencing Dynamic Arrays I
lessons
Author
Price
Custom ZTM course completion certificates
Live career advice sessions with mentors, every month
Full access to all future courses, content, and features
Access to our private Discord with 450,000+ members
Unlimited access to all bootcamps, bytes, and projects, and career paths
Access to our private LinkedIn networking group with 100,000+ members
Custom ZTM course completion certificates
Live career advice sessions with mentors, every month
Full access to all future courses, content, and features
Access to our private Discord with 450,000+ members
Unlimited access to all bootcamps, bytes, and projects, and career paths
Access to our private LinkedIn networking group with 100,000+ members
Custom ZTM course completion certificates
Live career advice sessions with mentors, every month
Full access to all future courses, content, and features
Access to our private Discord with 450,000+ members
Unlimited access to all bootcamps, bytes, and projects, and career paths
Access to our private LinkedIn networking group with 100,000+ members
Frequently asked questions
- It's helpful to have some familiarity with Excel formulas and functions prior to starting.
- You'll need to have access to any version of Excel (we will be using Excel 365 for our examples).
Absolutely! We issue beautiful certificates of completion. Plus, you'll have the opportunity to showcase Zero To Mastery Academy on your LinkedIn profile under the education section.
Indeed! We offer high-quality subtitles available in 11 languages: English, Spanish, French, German, Dutch, Romanian, Arabic, Hindi, Portuguese, Indonesian, and Japanese.
You can even customize the font size, color, background, and more to ensure the subtitles suit your preferences perfectly!
If you have further inquiries about the Academy membership, don't hesitate! We have more answers for you here.
Guaranty
Guaranty period is 30 days, beginning from the purchase day.
Supercharge Excel with Dynamic Array Functions & Formulas
