The Complete Excel Course with AI Integration

Automate Excel with Power Automate Desktop flows

Open the workbook, read the rows, write the answers, save, close: that routine should run without you. In The Complete Excel Course with AI Integration you build AutoFlow, the Power Automate Desktop flows that run it for you, asking for approval on each row and flagging the rows that match. An industry-standard project designed after talking with people from many different industries, it runs on Windows: the first lesson installs Power Automate Desktop from the Microsoft Store and opens the starter workbook.

Taught by Sagnik Bhattacharya and Virginia Thorn

The Complete Excel Course with AI Integration: Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

You will be able to:

  • Install Power Automate Desktop, build a first flow from a message box, and open a workbook in a fresh Excel session of its own.
  • Read a cell from a worksheet into a variable, show it in a message and close Excel cleanly when the flow is done.
  • Build an approval flow: a Yes or No question, an If and an Else, and the answer written into the right sheet, then saved.
  • Loop through rows with a counter, read each row's status and write a flag only on the rows that match.
  • Capture your clicks on the desktop and in Chrome with the recorder, then make each recorded action dependable through its properties.
  • Launch any flow from an icon on the desktop or its run URL in a browser, and let Copilot guide you on screen while you build.

Projects

What you will build.

The course has 14 industry-standard projects. These three matter most here.

  • Project 13

    AutoFlow

    The weekly report routine, run by a flow instead of by you.

    Your flows on this page, built on a starter workbook: a Yes or No asked row by row with each answer written in, then a status column searched and every match flagged.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    Where automation starts inside Excel: a recorded macro replays your steps in one keystroke, the record-once idea the Power Automate recorder takes out to the desktop and the browser.

  • Project 14

    Agentic AI in Excel

    AI finds and fixes the formula; you check it before it counts.

    Copilot's guided help talks you through Excel while it sees your screen, the same help that later watches your Power Automate window and answers as you build.

Tap or pinch to zoom in, drag to move around. Click or scroll to zoom in, drag to move around.

Lessons

The lessons that matter, in course order.

The Complete Excel Course with AI Integration has 186 lessons. This page picks out 16 of them, 1 h 12 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 174 Power Automate Desktop for Excel

Start at Lesson 174 on a Windows computer: it installs Power Automate Desktop and opens the starter workbook the whole section works on. Curious how a recording becomes automation first? Lesson 136 and Lesson 137 record a macro inside Excel, and the Power Automate recorder of Lesson 181 works the same way.

16 of 186 lessons · 1 h 12 min

09 Project: task automation with data validation and forms 1 of 9 lessons · 8 min Status and priority drop-down lists in TaskFlow, first typed in and then drawn from a list sheet: a status column kept to fixed values, so a flow that looks for one status finds every row holding it.
  1. 81 Data validation in Excel Status and priority drop-down lists in TaskFlow 8 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 3 min Copilot's guided help in Excel: it reads the workbook on your screen and talks you to the right tab, the help AutoFlow later points at Power Automate.
  1. 102 Copilot guided help in Excel Step-by-step AI help inside Excel 3 min
14 VBA and macros in Excel: FormatWizard 2 of 17 lessons · 9 min What a macro is, then your first recording: a name, a Ctrl shortcut, a row's formatting captured once and replayed, the idea Power Automate's recorder carries beyond Excel.
  1. 136 Excel macros and VBA for beginners What macros are, the FormatWizard project 3 min
  2. 137 Record your first Excel macro Name, run and use absolute references 6 min
16 Power Automate: weekly sales report automation 12 lessons · 53 min AutoFlow, on Windows: Power Automate Desktop installed, a first flow built around a message box, Excel opened in a session of its own, cell A2 read and shown, the find and replace template opened up, a desktop icon and a run URL, recording on the desktop and in Chrome, action properties, Yes or No approvals with If and Else, a loop over rows, and a Ninja Challenge that flags onboarded clients.
  1. 174 Start here Power Automate Desktop for Excel Set up AutoFlow and your first automation 3 min
  2. 175 Your first Power Automate flow Flows, triggers, actions and Display message 3 min
  3. 176 Connect Excel to Power Automate Launch Excel and the Excel instance variable 3 min
  4. 177 Copilot Vision with Power Automate AI-guided help while you build a flow 2 min
  5. 178 Read data from Excel with Power Automate Read from worksheet and close Excel 4 min
  6. 179 Power Automate templates Search and replace Excel values template walkthrough 7 min
  7. 180 Run Power Automate flows From a desktop shortcut and a run URL 3 min
  8. 181 Power Automate Desktop recorder Record desktop and browser actions into a flow 4 min
  9. 182 Action properties in Power Automate UI elements, variables and wait settings 4 min
  10. 183 Approval flow in Power Automate Desktop If conditions and message box buttons 9 min
  11. 184 Loops in Power Automate Desktop Loop and For each actions for Excel rows 5 min
  12. 185 Power Automate Ninja Challenge Flag onboarded rows with loop, read, if, write 5 min

Instructors

Who teaches it.

Virginia Thorn smiling at the camera, dark hair tied back, wearing a navy top.

Instructor, Excel with AI

Virginia Thorn

Emmy Award winner. Teaches Excel with AI at Coding Liquids.

Questions

Asked before starting.

Where can I learn Power Automate Desktop on real Excel workbooks?

The Complete Excel Course with AI Integration from Coding Liquids teaches exactly that in AutoFlow, an industry-standard project you build on Windows. You install Power Automate Desktop, then build flows that open your workbook in a session of their own, read cells, ask Yes or No for each row and write Approved or Rejected back, save and close Excel, and in the Ninja Challenge flag every onboarded client on a sheet without touching a single cell. It all runs on one starter workbook. The 16 lessons on this page add up to 1 hour 12 minutes of video, and lifetime access keeps them at hand for every routine you pass to a flow later.

How do I automate Excel with Power Automate Desktop?

Install the app, then let actions do your clicks, which is how The Complete Excel Course with AI Integration starts AutoFlow. Power Automate Desktop comes from the Microsoft Store and runs on Windows (Lesson 174), with a few minor features needing a Microsoft 365 subscription; a first flow drags in a Display message action and runs it (Lesson 175). Lesson 176 adds Launch Excel with Nest under a new Excel process switched on, and Lesson 178 reads cell A2 into a variable, shows it and closes Excel. You can also record your steps (Lesson 181) and firm them up in each action's properties (Lesson 182).

How do I build an approval flow from Excel in Power Automate Desktop?

Ask the question in a message box and let If and Else write the answer, as AutoFlow does in The Complete Excel Course with AI Integration (Lesson 183). A Display message with Yes and No buttons stores the choice in ButtonPressed; if it equals Yes, the flow launches Excel, makes the approval requests sheet active and writes Approved into the request's cell, and the Else branch writes Rejected. Each branch then saves the workbook and closes Excel. Lesson 184 wraps the whole flow in a loop, so one run asks about every request in turn and records each answer on its own row.

How do I loop through Excel rows in Power Automate Desktop?

With a Loop action and its counter, or a For each action, both taught for Excel rows in Lesson 184; The Complete Excel Course with AI Integration puts the Loop to work twice. There the loop runs from row 3 to row 6 in steps of 1, its LoopIndex renamed RowNumber, and every Write to Excel worksheet action takes %RowNumber% as its row, so each answer lands on its own line. The Ninja Challenge (Lesson 185) reads column D of the client onboarding sheet on every pass and writes flag in column H wherever the status is onboarded, leaving the rest alone. Change the start, the end or the columns and the same flow covers a list of your own.

Can Power Automate find and replace values in an Excel file?

Yes, and The Complete Excel Course with AI Integration opens the Search and replace Excel template from Power Automate's Examples to show how (Lesson 179). A custom form asks for the file, the text to find, the new text and whether to replace every match or only the first; an If ends the run if you cancel, Launch Excel opens whichever file you chose, and the Find and replace cells action does the work, with match case and whole-cell options, before Close Excel. Given a word that is nowhere in the sheet, the flow opens, finds nothing, changes nothing and closes cleanly.

Why does my Power Automate flow not write to the Excel file I expect?

Point each action at the Excel session it should use: that is the fix The Complete Excel Course with AI Integration makes in Lesson 183. When the If and the Else branches each launch Excel, Power Automate names the second session ExcelInstance2, yet the actions copied into the Else branch still point at the first, so a No answer never reaches the sheet. Setting the worksheet, write, save and close actions in that branch to ExcelInstance2 cures it, and Nest under a new Excel process in Launch Excel (Lesson 176) keeps a flow apart from workbooks you already have open. On the plan with instructor support, a flow of your own that still misbehaves is a written question to the instructor under the lesson, for two months from the day you switch it on.

How do I run a Power Automate flow without opening the app?

Give it a desktop shortcut or use its run URL, the two ways The Complete Excel Course with AI Integration shows in Lesson 180. The three dots beside a flow offer Create desktop shortcut, and a click on that icon opens Excel, runs the steps and closes it again. Properties, then Details, holds a link that starts the same flow from a browser, so a bookmark, a link in an email or a button on an internal web page can set it off. Running a flow on a timed schedule is not in the lessons; both of these start it on demand, and one click or one link is then the whole routine.

Can Copilot help me build a Power Automate flow?

Yes, as a guide that sees your screen. The Complete Excel Course with AI Integration first uses Copilot's guided help inside Excel (Lesson 102), then shares the Power Automate window with Copilot Vision and asks it out loud how to add an If condition to a flow (Lesson 177); that lesson uses a premium plan, and the rest of the section never depends on it. When a setting in an action's properties puzzles you, Lesson 182 suggests asking an AI tool what it means before you change it. The flow itself stays yours: every action in it is one you placed and can open.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

The same course

For another job, goal, level, topic or comparison.