Excel tutorial

Short, clear lessons by topic. Each topic ends with a simulator where you try it yourself.

Formatting

Soon
Formatting basics
Format Painter
Colors
Fonts
Borders
Number formats
Gridlines
Sizes and settings

Data analysis

Soon
Sort
Filter
Tables
Conditional formatting
Highlight cell rules
Top/bottom rules
Data bars
Color scales
Icon sets
Manage rules
Charts

PivotTables

Soon
PivotTable intro
Create a PivotTable
PivotTable values
PivotTable filter
PivotTable group
Calculated field
PivotChart

Functions

21 / 50
ANDAVERAGE
AVERAGEIF
AVERAGEIFS
CONCAT
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DATEDIF
FILTER
HLOOKUP
IF
IFERROR
IFS
INDEXINDEX MATCHLEFTLEN
LOWER
MATCHMAX
MEDIAN
MID
MIN
MODE
NETWORKDAYS
NPV
ORPROPER
RAND
RIGHT
ROUND
SORT
STDEV.P
STDEV.S
SUBSTITUTE
SUMSUMIF
SUMIFS
SUMPRODUCT
TEXTJOIN
TODAY
TRIM
UNIQUE
UPPERVLOOKUPXLOOKUP
XOR

How to

Soon
Convert time to seconds
Difference between times
NPV (net present value)
Remove duplicates