This course contains the use of artificial intelligence.

Most Excel courses are 15 to 23 hours long, lead with outdated functions, practice on sterile demo data, and never teach you to clean the messy spreadsheets that real jobs actually hand you. This course is the opposite: about 3 focused hours that take you from complete beginner to job-ready, built the modern way.

You will start with the foundations — the Excel screen, tidy data, formatting that helps readers, and never losing work. Then you will master the formulas that do 80% of real spreadsheet work: SUM, AVERAGE, IF, and the SUMIFS family. You will learn lookups the modern way — XLOOKUP first, INDEX+MATCH for grids and legacy files, VLOOKUP just well enough to read old spreadsheets — plus dynamic arrays (FILTER, SORT, UNIQUE) that turn reports into living formulas.

Next comes the skill reviewers of other courses beg for: cleaning dirty data. You will rescue a genuinely filthy shop export — duplicates, stray spaces, four spellings of one city, prices stored as text, dates in three formats — by hand, by formula, and finally with Power Query, so the cleanup replays on next week's export with one Refresh. From there: proper Tables, validation dropdowns, conditional formatting, PivotTables with slicers and PivotCharts, and charts that tell the truth instead of decorating.

A full section teaches you to work with AI assistants — Copilot in Excel, ChatGPT, Claude — to write, explain, and debug formulas, always through a verify-always workflow that catches the confident wrong answers AI sometimes gives (one exercise plants a subtly wrong AI formula for you to catch). You will finish by building a self-maintaining personal budget with Goal Seek what-ifs, passing two timed mock interview tests like the ones employers actually set, and completing a capstone: a full year of food-truck data cleaned, analyzed, and turned into a one-page dashboard with written insights — a portfolio piece you can show in interviews.

Every section includes TWO downloadable workbooks: a practice file with fun, real-life data (movie nights, takeout budgets, a fantasy league, a café stockroom, a streaming service, a fitness tracker) and a solutions file with the completed work, live formulas you can inspect, and notes explaining how each answer works. No other beginner course packages a timed interview test and a graded capstone portfolio project like this one.