Learn · Track 1 · Intermediate

Everyday Excel

Conditional logic, SUMIFS and COUNTIFS, text, dates and lookups: the functions that turn a list into answers.

9 modules57 lessons planned6 of 9 modules published

41 lessons in 6 of 9 modules, 57 planned. The first two lessons of every module are free: 12 of 41 published lessons. Which path is right for me?

07
Logical
IF, AND, OR, NOT, nested IF, IFS
7 lessons
08
Conditional Counting and Summing
COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
7 lessons
09
Text
LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, CONCAT, TEXTJOIN, &, SUBSTITUTE, TEXT, FIND, SEARCH
8 lessons
10
Dates and Times
TODAY, NOW, DATE, YEAR, MONTH, DAY, EOMONTH, EDATE, NETWORKDAYS, DATEDIF, date arithmetic
6 lessons
11
Lookups
VLOOKUP exact and approximate, HLOOKUP, MATCH, INDEX, XLOOKUP
8 lessons
12
Tables and Clean Data
Format as Table, structured references, Remove Duplicates, Data Validation lists, Text to Columns
Coming later
13
Charts
Column, bar, line and pie charts; titles, axes, series; changing chart type
Coming later
14
Conditional Formatting
Highlight rules, top and bottom, data bars, color scales, formula rules
Coming later
15
Workbooks
Multiple sheets, cross-sheet references, named ranges, page setup and print area
5 lessons

Modules marked "planned" or "coming later" are not published yet; some need simulator features that are still being built.

Logical