30 Days to Excel Job Ready

A day-by-day plan to go from zero to job-ready: 30 Days to Excel Job Ready.

Browse the full plan below for free. Register free (no verification needed) to enroll and track your daily progress. Register Free
1
Interface basics: cells, sheets, ribbon tour
2
Entering & formatting data cleanly
3
Basic formulas: SUM, AVERAGE, COUNT
4
Relative vs absolute references ($)
5
IF statements
6
Nested IF / AND / OR
7
Text functions: CONCAT, LEFT/RIGHT, TRIM
8
Date functions
9
Conditional formatting
10
Data validation (dropdowns)
11
Sorting & filtering
12
Removing duplicates & cleaning messy data
13
VLOOKUP basics
14
XLOOKUP / INDEX-MATCH
15
Practice: build a budget tracker
16
Intro to Pivot Tables
17
Pivot Table calculated fields
18
Pivot Charts
19
Charts: bar, line, pie — when to use which
20
Combo charts
21
Named ranges
22
Data tables & what-if analysis
23
Goal Seek
24
Intro to macros (recording one)
25
Keyboard shortcuts speed round
26
Building a dashboard layout
27
Linking sheets & workbooks
28
Error handling: IFERROR, ISNA
29
Practice: analyze a real dataset end-to-end
30
Polish your practice workbook for a portfolio
31
Apply to 3 jobs that need Excel