Excel features
Draft. This page's introduction is a placeholder until the launch batch writes it.
A feature guide explains one of the big tools from the start and links every task that belongs to it. Small features do not get a guide of their own: they are a single how-to.
Linked guides are ready. Names in grey are still being written.
Sheet basics
- Formula basics
- Rows and columns
- Formatting
- Protection
- Printing
- Files
Working with data
- Data validationData validation limits what can be typed into a cell. This guide covers drop-down lists, number and date rules and error messages.
- Sorting and filtering
- Data cleaning
- Tables
- Conditional formatting
Analysis
- Pivot tables
- Charts
- Dynamic arrays
- What-if analysis
- Dashboards
Automation
- Power Query
- Macros
- Copilot
Practice it for real
Short drills in an Excel-style grid, checked the moment you press Enter.