City of St. Catharines Learning & Development

To take this course you must have a solid understanding of Excel formulas and functions is required. You must have at least the knowledge covered in Excel 1B, 3, and 4 before enrolling in this course.

Take your Excel skills further by exploring some of its most powerful and flexible functions. This course covers tools like INDIRECT, LET, LAMBDA and more—along with tips on recalculation, performance, and making the most of Range Names. You’ll get a solid grasp of how these features work together to make your workbooks smarter and more efficient.

Functions Covered

• INDIRECT / MOD
• ROW / ROWS / COLUMN / COLUMNS
• SEQUENCE / SHEET / SHEETS
• TEXTBEFORE / TEXTAFTER
• TEXTJOIN / ARRAYTOTEXT
• CELL / LET / LAMBDA

About Formulas

• Manual Recalculation
• What are Volatiles
• Improving Performance

Advanced Range Names

• Range Name Constants
• Relative Range Names
• About Dynamic Range Names