Intermediate Excel

Microsoft Office

Intermediate Excel

Master Excel tables with structured references — deepen your table fluency with structured references and calculated columns; build table-aware formulas that automatically expand as your data grows; eliminate the brittleness of cell-range formulas in long-lived models
Build advanced formulas with conditional logic and modern dynamic arrays — write SUMIFS, COUNTIFS, AVERAGEIFS, and IF combinations for real business logic; use modern dynamic array functions (UNIQUE, FILTER, SORT) to produce self-updating spilled results without copying formulas down columns
Filter, validate, and govern worksheet data — apply advanced filters and slicers; enforce data entry standards with Data Validation rules; protect downstream calculations from upstream bad data so reports stay trustworthy
Reorder and summarize with sort, custom lists, and subtotals — sort by multiple keys and custom orderings such as business-defined region or priority sequence; use outline and subtotal to summarize structured data without writing a single formula
Combine data across sources with XLOOKUP and lookup functions — use XLOOKUP (the modern default), VLOOKUP, and HLOOKUP to merge data from multiple tables, worksheets, or workbooks; consolidate split data sources into single analytical tables
Collaborate, protect, and ship workbooks for distribution — manage comments and tracked changes; protect workbooks and worksheets; finalize and distribute as protected files, PDFs, or shareable templates; produce work ready for executive review, compliance, or audit