Course 2 of 6 on the Data Analyst path
Excel for analysts
Work like an analyst in Excel: formulas, IF logic, SUMIFS and COUNTIFS, XLOOKUP, text and date functions, pivot tables, slicers and pivot charts.
- 8 lessons
- About 59 min reading
- Beginner
- Updated 13 Nov 2026
After this course you can
- Write formulas with correct references and logic
- Summarise with SUMIFS, COUNTIFS and AVERAGEIFS
- Look up values with XLOOKUP and know when VLOOKUP and INDEX/MATCH still matter
- Clean text and dates with functions
- Build pivot tables, grouped fields, calculated fields, slicers and pivot charts
Before you start: nothing. Microsoft 365 or Excel 2021 is best because XLOOKUP and dynamic arrays need them.
Lessons
Formulas
Pivot tables and charts
Putting it together
Know it, or think you know it?
Take a free mock interview on Excel for analysts for Data Analyst: 3 questions, a score and feedback on each, in about 10 minutes.