This is a hands-on, project-based course designed to teach you some of Excel's most powerful dynamic array functions, including:
- SORT
- SORTBY
- FILTER
- UNIQUE
- SEQUENCE
- RANDARRAY
- And more...
We'll introduce dynamic array behavior and spill range properties, then review some of the most common array functions in Excel. From there we'll practice nesting functions to create more advanced formulas, and combine them with other functions like FREQUENCY, CHOOSE and LET to create dynamic drop-downs, conditional formats, custom charts, Top N calculations, and more.
Throughout the course, you'll play the role of Business Intelligence Analyst for Maven Recruiters, a job placement agency based in the United States. Using data from Glassdoor.com, your role is to use dynamic array formulas to explore the job landscape, compare salaries across roles, and identify key growth areas for the agency.
If you're looking to master Excel's most powerful dynamic array formulas for data analysis, you've come to the right place.
IMPORTANT NOTES & PREREQUISITES:
- You will need a compatible version of Excel to follow along (Office 365 or Excel 2021)
- Experience with basic Excel formulas is strongly recommended
- Course includes a PDF ebook and downloadable Excel project files containing all demos and assignments
WHO SHOULD TAKE THIS COURSE:
- Microsoft Excel users looking to build expert-level skills
- Data professionals who use Excel for analytics or business intelligence
- Anyone seeking to master some of Excel’s most powerful formulas
