Ravindra BagaleCourses & study guides मराठी Track your progress

28. Copilot and AI in Excel

By Last updated:

Friends, Copilot can build a PivotTable, a formula or a whole summary sheet from one sentence. That is powerful, and it is also risky, because a wrong number written confidently looks exactly like a right one. In this module we use Copilot properly: clean data first, clear prompts, the right mode, and a formula check for every number.

What you will learn in this module

  • Know what Copilot in Excel does, its three modes (edit, plan, chat) and where it runs
  • Prepare data as a clean Excel Table so Copilot understands it
  • Ask questions in Chat only mode and make multi-step edits safely
  • Understand the retired COPILOT function and replace it with the pane or a formula
  • Write analyst prompts with the WHERE-TASK-FILTER-OUTPUT-CHECK pattern
  • Verify every AI number with formulas, and know the privacy, limits and licence facts

Live story: The ₹544 that should have been ₹324

Suppose Shraddha Bagale asks Copilot for "Pune sales" and gets ₹544. She sends it. Her manager wanted net sales of Delivered orders, which is ₹324, because one Pune order was cancelled. Nothing was wrong with the AI or the data; the question was not specific and the answer was not checked. After this module, Shraddha writes "Delivered only" in the prompt and checks every number with SUMIFS before it leaves her laptop.

All numbers in this story are fictional practice data.

Fictional practice data

Every name, number and company detail in this module is made up for class. It is not the data of Blinkit, Amazon or any real firm.

Concepts in this chapter

  1. 28.1What Copilot in Excel Is and Who Can Use It
  2. 28.2Get Your Data Ready: Copilot Works Best on a Clean Excel Table
  3. 28.3Ask Copilot About Your Data (Chat Only Mode)
  4. 28.4Edit with Copilot (Formerly Agent Mode) and Plan Mode
  5. 28.5The COPILOT Function: Retired in September 2026, and What to Use Now
  6. 28.6Prompt Patterns for Analysts
  7. 28.7Verify AI Output: A Checklist and Recomputing with Formulas
  8. 28.8Copilot Data Privacy, Limits and Licensing

Review and practice

  1. ★Practice and Answer Key: Check a Copilot Summary Before It Goes Out

The chapter recap is at the end of the last concept page.

Quick revision cards

Quick revision

Revise this chapter in two minutes. Save the cards on your phone or download them as PNG files. All names and numbers are made up for practice.

Revision card: AI in Excel: clean data, clear prompt, check the answer. Example data table with Prepare the data: Ctrl+T first; Prompt: total profit by city: Pune ₹650, Nagpur ₹300; Check the AI's number yourself: ₹650.
Card 1 of 2: AI in Excel: clean data, clear prompt, check the answer · Download PNG
Revision card: Verify AI output. Covers Totals match; Right rows used; Formulas make sense; No made-up columns; Numbers in the text. With a photo of Ravindra Bagale and a short tip.
Card 2 of 2: Verify AI output · Download PNG

More cards for every chapter: Ravi Sir's Cards.