Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Excel From Zero with AI with Copilot

Learn Excel From Zero with AI with Copilot

Learn Excel step by step: fast data entry, formulas, XLOOKUP, charts, PivotTables, PDF import and Copilot AI
Created byAşkın TEMEL
Last updated 11/2026
English

What you'll learn

  • Navigate Excel confidently and use the keyboard shortcuts that save hours every week
  • Enter and clean data fast with AutoFill, Flash Fill, Paste Values and Find & Replace
  • Write formulas with SUM, AVERAGE, IF, IFS, IFERROR and XLOOKUP, and fix common errors
  • Sort, filter and organise data with Excel tables, slicers and drop-down lists

Course content

5 sections • 12 lectures • 1h 48m total length
  • Install Excel and Tour the Interface8:52
  • Fast Data Entry: AutoFill, Flash Fill and Shortcuts8:56

Requirements

  • No Excel experience needed. We start from zero.
  • A computer with Excel: Microsoft 365 is recommended. The free Excel for the web works for most lessons.
  • For the Copilot lessons: Microsoft 365 Personal, Family or Premium, or a Microsoft 365 Copilot licence at work. You can still follow and learn the rest without it.

Description

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.

Who this course is for:

  • Complete beginners who want to learn Excel properly, step by step
  • Students and job seekers who need Excel skills for school or a CV
  • Office workers who use Excel every day but feel they are doing it the slow way
  • Small business owners who track sales, invoices or expenses in spreadsheets
  • Anyone curious how AI (Copilot) can do the boring parts of Excel for them