City of St. Catharines Learning & Development

Continue from Courses 3 and 4 and take your formula skills to the next level. This course explores a bit more depth with some of Excel’s most commonly used functions, helping you build confidence with practical techniques you can apply right away.

Includes:

• Advanced IF Function
• Advanced XLOOKUP
• Conditional Functions
• More Range Names

Knowledge of the topics covered in Excel Course 3 and Course 4 is required for this course, which focuses on the advanced application of functions learned in those courses.