⚡
Module 8: Modern Excel Features
Dynamic arrays and XLOOKUP, the Intelligent Services, icons and drawing tools, and co-authoring — the features that distinguish a current release from Excel 2019.
3
Lessons
45
Minutes
Practice
Files Included
Advanced
Level
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Lesson 1⏱ 15 min
⚡Dynamic Arrays & XLOOKUP
Use the modern formula engine: one formula that returns many results, and the lookup function that replaces VLOOKUP.
Lesson 2⏱ 15 min
⚡Intelligent Services: Data Types & Analyze Data
Use Excel's connected data types and its automated analysis, and learn where both need checking.
Lesson 3⏱ 15 min
⚡Icons, Drawing Tools & Modern Collaboration
Add scalable icons and annotations to a workbook, and work in a shared file without getting in anyone's way.