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.Trump Excel's free online training
Sumit Bansal's free Excel training at Trump Excel is the tidiest free Excel video course on the web, from a thirteen-time Microsoft Excel MVP, with no sign-up. Twenty-six video lessons in seven modules — a little over twelve hours — move from the basics through the things that actually matter day to day: how formulas and references work, IF logic, VLOOKUP and INDEX/MATCH, conditional formatting, pivot tables, charts. Take them in order, download the example file for each lesson, 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
Free Online Excel Training →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 Trump Excel's course; 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.