City of St. Catharines Learning & Development

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.

Required Prior Knowledge: 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.