Microsoft Excel 2021365 - Beginner to Advanced - Section Introduction - 3

Deborah Ashby introduces an advanced Excel 2021 course aimed at transforming intermediate users into Excel gurus. The course covers dynamic array functions, statistical and math functions, advanced pivot table features, and data import techniques. It also includes new functions like Let and Lambda, and explores automation with macros and VBA. Course files are available for download, and exercises are provided for practice.

What is the primary focus of the initial part of the Excel 2021 Advanced course?

• Basic Excel functions

• Dynamic array functions

• Excel for beginners

• Excel VBA programming

Which new Excel function allows you to create custom functions without programming knowledge?

• Let

• ROUND

• Lambda

• AGGREGATE

What advanced feature is covered in the second section of the course?

• Basic chart creation

• Advanced pivot table techniques

• Excel for Mac

• Simple data entry

What tool is used for transforming data in the final section of the course?

• Power Query

• Conditional Formatting

• Excel Solver

• Data Analysis Toolpak

Which method is introduced for automating tasks in Excel?

• Macros and VBA

• Manual data entry

• Using templates

• Conditional formatting