Courses My learning

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-6-2 · Dynamic arrays

13 min

FILTER

Log in to open this lesson

Students log in to see their lessons and progress.

Email or username

Password

Remember Me

© 2026 Excel at Excel