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

1284 - Excel Course 4: Criteria, XLOOKUP & Links (Previously: More Useful Formulas)