Excel is still the tool every office runs on, and in the last two years it got something new: an AI assistant that can write formulas, build charts and even put together a whole dashboard for you. This course teaches you both. You start from zero and finish with a real, shareable report built with your own hands and with Copilot.
There are 12 compact, hands-on lessons (about 2 hours in total). Every lesson works on a realistic file, like a budget, a sales list, a project tracker, an invoice or an expense form, and every keyboard shortcut is shown on screen on an animated keyboard, so you can see exactly which keys to press.
What’s inside:
– Getting started: install Excel (or use it free in the browser), tour the ribbon, cells, sheets and the shortcuts you’ll use every day.
– Work faster: AutoFill, Flash Fill, Paste Values, Format Painter, Find & Replace and number formats.
– Formulas without fear: SUM, AVERAGE, COUNT, relative vs absolute references ($ and F4), and how to fix #DIV/0!, #NAME? and #REF!.
– Tables and filters: sorting, AutoFilter, Excel tables with Total Rows, and slicers.
– Clean data: drop-down lists, Data Validation, checkboxes and conditional formatting.
– Smart formulas: IF, AND/OR, IFS, IFERROR and XLOOKUP.
– Bring data in: import tables from a PDF with Power Query, and turn a photo of a table into cells.
– See the story: charts, sparklines, PivotTables, slicers and PivotCharts.
– AI in Excel: Copilot for insights, formula columns, highlighting and explanations, then Edit with Copilot (formerly Agent Mode) to build a loan calculator and a sales dashboard for you.
– Finish like a pro: comments, sheet protection, signatures, sharing and a clean PDF export.
– Final project: from a messy CSV to a finished report with a dashboard, using everything you learned.
You’ll also learn how to write good prompts, and the honest limits of AI: Copilot can be wrong, so we always check its work.
No previous experience is needed. If you have never opened Excel, start with lesson 1. If you already know the basics, jump straight to the formulas or the AI lessons.






