Learn Excel to stop fighting your spreadsheets in two months
Two months of short daily sessions — about 30 minutes a day on one free video course and your own real data — gets you from copy-pasting and manual math to confident with formulas, lookups, pivot tables, and charts. Roughly 30 hours total. You will not be a VBA developer or a financial modeller. You will stop doing by hand what Excel was built to do for you.
2 months · ~30 hours · build a pivot table and a working lookup on your own data
1.Excel Exposure, the free course
Ben Currier's Excel Exposure is the most complete free Excel course on the web, and it has stayed free since 2011. Roughly forty self-paced lessons, each under twenty minutes, move from the basics through the things that actually matter day to day: relative versus absolute references, IF logic, VLOOKUP and XLOOKUP, conditional formatting, pivot tables. Download the Master Workbook and do every exercise inside it. Watching is not learning; you learn when you type the formula and it returns #N/A and you fix it.
Free
Excel Exposure →2.Microsoft Excel 365 Bible, 2nd edition
Do not read this cover to cover — it is thirty chapters and a thousand pages. Buy it as the reference you reach for when the course leaves a gap. Alexander and Kusleika (between them twenty-plus years of Microsoft Excel MVP awards) explain not just which button but why the formula behaves as it does. When you hit a wall — a lookup that won't match, a pivot that won't group dates, a chart axis that won't behave — the index will get you to a clear, worked answer faster than a dozen forum threads.
About $40 paperback; often less as an ebook
Microsoft Excel 365 Bible →3.Rebuild one real spreadsheet you already keep
Take a spreadsheet you maintain by hand — a budget, an expense log, a project tracker, a list of orders — and rebuild it properly. Turn the data into a table. Write a lookup that pulls a name or price from another sheet instead of typing it. Build a pivot table that summarises the whole thing in five clicks, and a chart from that pivot. Then change a number and watch everything update. This is the moment Excel stops being a grid you fill in and becomes a tool that calculates for you.
Free
Microsoft Excel help & learning →If this doesn't fit you
If you prefer learning by watching an expert work through real problems rather than a structured curriculum, switch to Mike Girvin's excelisfun channel on YouTube — 3,800-plus free videos with downloadable example files, from a Highline College instructor and longtime Excel MVP. Start with his "Excel Basics" playlist. It is deeper and messier than Excel Exposure; pick it if you like firehose teaching over tidy lessons.
Why this path
Most people who "use Excel every day" never actually learned it — they learned five things by imitation and brute-force the rest. The bottleneck is never the interface; it is that nobody ever showed them lookups and pivot tables, the two features that turn an afternoon of manual work into thirty seconds. A free structured course teaches those in order, the Bible catches you when you fall, and rebuilding your own spreadsheet forces the skills to stick because the data is real and the payoff is immediate. Skipping the rebuild is the usual mistake: you will recognise the features but never reach for them.