City of St. Catharines Learning & Development

To take this course participants must have 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.

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.

Advanced IF Function

• Nesting IF’s
• Conditional Formatting with IF
• Multiple Conditions with AND/OR
• Using Wildcards
• The IFS Function
• The SWITCH Function

Advanced XLOOKUP

• Automated Lookups / TRIMRANGE and dot
• Approximate Match / Other Arguments

Conditional Functions

• Criteria Data Types
• Advanced Use Examples

More Range Names

• Create from Selection
• Range Name Constants
• File to File Copy