SUMIF & COUNTIF
Calculate using one condition
Learning path 02
Connect the dots.
Answer more useful questions with conditional calculations, lookups and analysis tools.
Comfortable with basic formulas13 lessons in the curriculum13 available now
SUMIFS & COUNTIFS
Analyze multiple conditions
XLOOKUP essentials
Find the value you need
VLOOKUP & compatibility
Work confidently with existing files
IF, AND & OR
Build clear decision rules
Clean and combine text
TRIM, LEFT, RIGHT, MID and TEXTJOIN
Dates & time
TODAY, DATE, EOMONTH and workdays
Conditional formatting
Make patterns and exceptions visible
Data validation
Guide input and reduce mistakes
PivotTables essentials
Summarize without complex formulas
Charts for analysis
Compare trends, mix and relationships
IFERROR & ROUND
Handle exceptions and precision
Project: a sales report
Build a reusable monthly analysis