This lesson is part of the paid course

Sign in to check whether your enrollment covers this lesson.

Sign inFree lessons
Module 02 · Excel & Google Sheets for Analysts21 min

Text, Date and Aggregate Functions

TEXTSPLIT, TRIM, DATEDIF, SUMIFS, COUNTIFS and AVERAGEIFS in real cleanup work.

By the end of this lesson you can

  • Split and standardise messy text
  • Aggregate with multiple criteria

Know someone who should take this course?

They will land on the course page with the free lessons open to them.

Lesson feedback

No ratings for this lesson yet.

Sign in to rate this lesson.

Lookups — XLOOKUP, VLOOKUP and INDEX/MATCHPivot Tables from Zero