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
Course Details
Title Learn Excel From Zero with AI with Copilot
Category Office Productivity
Sub Category Microsoft
Creator Name Aşkın TEMEL
Language English
Rating 0
Length 1:48 Hours
Coupon StatusActive

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.



More Free Courses in Office Productivity

Managing Social Anxiety in the Workplace

Managing Social Anxiety in the Workplace

Office Productivity

26085

Baba Oyewole, Helen Hicks

View Course
Workplace Productivity - Supporting Others Through Change

Workplace Productivity - Supporting Others Through Change

Office Productivity

24367

Baba Oyewole, Helen Hicks

View Course
Create Stunning Presentations using AI (ChatGPT and More)

Create Stunning Presentations using AI (ChatGPT and More)

Office Productivity

5194

Expert Azi, Md Azizul

View Course
Easily Master Google Forms - Create Online Forms & Quizzes

Easily Master Google Forms - Create Online Forms & Quizzes

Office Productivity

2725

James Bernstein, David Bernstein

View Course

⚠️ AdBlock Detected

Please disable your AdBlocker to continue.
We rely on ads to keep our service free.