City of St. Catharines Learning & Development

To take this course participants should have a solid understanding of Excel Course 1A, Excel Course 1B and Excel Course 3 topics needed. Helpful if you have knowledge of Excel Course 2A and 2B topics.

Learn how to get quick, reliable results in Excel—without jumping through hoops. This course explores powerful tools like conditional functions, INDEX MATCH, XLOOKUP, and formula linking to help you work smarter and solve complex problems with ease.

Conditional Functions

• SUMIF / SUMIFS
• COUNTIF / COUNTIFS
• AVERAGEIF / AVERAGEIFS
• MINIFS / MAXIFS
• Bonus: The SUBTOTAL Function

Using XLOOKUP

• XLOOKUP instead of VLOOKUP
• (Knowledge of VLOOKUP required)

Formulas Between Sheets

• Link to a Cell on Another Sheet
• Formulas that Reference Other Sheets
• Creating 3D Formulas

Linking Formulas to Other Files

• Create Linking Formulas
• Working in Linked Files
• The Workbook Links Pane