Learn Excel, one lesson at a time
Short lessons with real formulas. Each one starts with tips at every step and ends with you writing the formula yourself.
01Adding up+, SUM, SUMIF, SUMIFS
02CountingCOUNT, COUNTA, COUNTIF, COUNTIFSComing soon
03Averages and roundingAVERAGE, MIN, MAX, ROUNDComing soon
04LogicIF, AND, OR, IFSComing soon
05Catching errorsIFERROR, IFNAComing soon
06Looking upVLOOKUP, HLOOKUP, XLOOKUPComing soon
07INDEX and MATCHINDEX, MATCH, INDEX + MATCHComing soon
08Finding textLEFT, RIGHT, MID, LEN, FINDComing soon
09Editing text&, TEXTJOIN, UPPER, PROPER, SUBSTITUTEComing soon
10DatesDATE, TODAY, DATEDIF, NETWORKDAYSComing soon
11Dynamic arraysFILTER, UNIQUE, SORTComing soon
12Tables and pivot tablesFilters, tables, pivot tablesComing soon
13Conditional formattingHighlight cells with rulesComing soon
14Keyboard shortcutsMove, select and edit fasterComing soon
15Combined skillsPut it all togetherComing soon