Excel 365 in 30 Minutes – Advanced Functions Part 1 (Advanced 2 of 11)

In this Bigger Brains course, you’ll learn how to use dynamic arrays and modern lookup functions to retrieve, analyze, and manage data more efficiently. You’ll explore what dynamic array functions are, how they behave, and why they change the way formulas work in Excel. You’ll see how to use powerful functions like SORT, SORTBY, and SEQUENCE to automatically organize and generate data without complex formulas or manual updates.

You’ll also learn how lookup functions support real-world analysis and reporting. You’ll see how VLOOKUP can be used to combine data from multiple tables and support basic dashboards, along with a clear explanation of its limitations. Then you’ll explore why XLOOKUP adds flexibility and reliability, and you’ll learn how to use both required and optional arguments, advanced search modes, and range-based returns. Designed for advanced Excel 365 users, this fast-paced course helps you apply expert-level tools confidently—perfect for professionals who want to get better results in less time. 

Topics covered include: 

• Defining a dynamic array function 

• Listing the characteristics of dynamic arrays 

• Using the SORT, SORTBY, and SEQUENCE functions 

• Using the VLOOKUP function to combine data from multiple tables 

• Using the VLOOKUP function to create a dashboard 

• Describing the limitations of the VLOOKUP function 

• Explaining the added value of using XLOOKUP 

• Using XLOOKUP to find data using required arguments 

• Using XLOOKUP to find data using optional arguments 

• Using XLOOKUP to find data using search mode 

• Using XLOOKUP in a column format and to return a range 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.