City of St. Catharines Learning & Development

To take this course you must know and be confident with the topics in Excel Course 11.

This course builds on your foundation with Dynamic Arrays and introduces more practical ways to use them in everyday work. You’ll explore how they interact with other Excel tools, learn the difference between regular and array formulas, and try out new functions like TRIMRANGE to help you shape your data faster and easier.

Dynamic Arrays

• Implicit Intersection
• Compatibility with other Features
• Forward & Backward Compatibility
• Array Constants
• DA Formulas with Regular Functions

Array Functions

• SUMPRODUCT vs SUM
• TRANSPOSE & FREQUENCY Now Easy

Dynamic Array Functions

• SortBy
• RandArray
• TextSplit
• Expand
• ToRow / ToCol
• ByRow / ByCol
• WrapRows / WrapCols
• Take / Drop
• ChooseRows / ChooseCols
• ArrayToText
• TrimRange