Excel at Excel
CoursesMy learning
Log in
Excel PowerUp
Smarter data entry
  • Data validation rules
  • Drop-down lists and dependent lists
  • Input messages and error alerts
  • Validation with formulas
  • Named ranges
Logic and text
  • IF, AND, OR and NOT
  • IFS, SWITCH and IFERROR
  • Cleaning text with TRIM, CLEAN and SUBSTITUTE
  • Splitting and joining text
  • Text to Columns and Flash Fill
Dates and times
  • How Excel stores dates
  • TODAY, NOW, DATE, YEAR, MONTH and DAY
  • DATEDIF and age calculations
  • WORKDAY, NETWORKDAYS and EOMONTH
  • Working with time
Lookups
  • XLOOKUP
  • XMATCH, INDEX and MATCH
  • VLOOKUP and HLOOKUP in older files
  • Approximate matches and lookup tables
  • Fixing lookup errors
Conditional summaries
  • SUMIF and SUMIFS
  • COUNTIF and COUNTIFS
  • AVERAGEIFS, MAXIFS and MINIFS
  • Wildcards and flexible criteria
  • Subtotals and grouping
Dynamic arrays
  • How spilled formulas work
  • FILTER
  • SORT and SORTBY
  • UNIQUE and SEQUENCE
  • Combining dynamic array functions
Bringing in data
  • Importing CSV and text files
  • Get and Transform: your first query
  • Linking to other workbooks
  • Refreshing and exporting data
  • Consolidating data from several sheets
PivotTables and quick analysis
  • Your first PivotTable
  • Rows, columns, values and filters
  • Grouping dates and numbers
  • Summary statistics: MEDIAN, STDEV and PERCENTILE
  • Project: a sales tracker

P-2-5 · Logic and text

9 min

Text to Columns and Flash Fill

Log in to open this lesson

Students log in to see their lessons and progress.

Get the bundle

© 2026 Excel at Excel