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

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.