City of St. Catharines Learning & Development

To take this course you must be an Excel 365 user who is already familiar with basic and intermediate formulas and functions. You should at least know the topics covered in Excel Course 1B, Excel Course 3, and Excel Course 4.

This course is essential for every Excel user today. With Excel’s new Calculation Engine and Dynamic Arrays at the heart of many modern functions, you’ll learn how to work faster, smarter, and more efficiently—without getting lost in complexity. It’s the update everyone should understand.

Arrays

• What is an Array
• Old CSE Arrays vs DA Arrays
• How to “Spill” a Formula
• The #SPILL! Error

Dynamic Reports

• Creating Reports with DA Functions
• Creating Dynamic Charts

Dynamic Array Functions

• Sort
• Filter
• Unique
• Sequence
• GroupBy
• PivotBy
• VStack
• HStack