Summary  
This chapter covers how to activate and configure an AI agent plugin to programmatically interact with, modify, and augment a dataset via natural-language prompts.  

General domain of usage  
Spreadsheet automation


Before using Copilot, you need the correct setup. This includes your subscription, Excel version, and file configuration.




Copilot works differently depending on your plan. Personal and Family plans include it, but with strict limits. You get around 60 actions per month, which is not enough for real work.

The Premium plan removes these limits. If you plan to use Copilot consistently, this is the only reliable option.

Choose The Right Microsoft 365 Plan

Open Excel and go to the Home tab. On the right side, you will see the Copilot button. Click it to open the panel.

By default, Copilot works like a chatbot. It can explain and suggest, but it cannot change your file directly.

Find Copilot In Excel

To let Copilot work inside your spreadsheet, you need to enable Agent Mode.

Start a new chat, open Tools, and select Agent Mode. After that, Copilot can insert formulas, edit cells, and perform actions in your file.

Enable Agent Mode

Copilot only works with cloud files. If your file is stored locally, it will not recognize your data.

Save your workbook to OneDrive or SharePoint and make sure AutoSave is turned on. This ensures Copilot always works with the latest version of your file.

Save Your File To The Cloud

In this course, you work mainly in Excel online.

The web version always saves changes automatically, supports Copilot without setup issues, and receives new features earlier than the desktop app.

Use The Web Version Of Excel



## What You Need before Moving On

Make sure everything is ready before continuing:

* A Microsoft 365 Premium subscription;
* Your files saved to OneDrive or SharePoint;
* AutoSave turned on;
* Agent Mode enabled;
* Access to Excel web version.


Discover how to use Excel with Copilot to solve real business problems. Explore practical workflows that turn messy data into structured, reliable systems. Learn how to build models, automate calculations, and generate insights without memorizing formulas. Understand how to guide Copilot, validate its output, and keep full control over your logic.

Explore the core setup and habits for working with Copilot in Excel. You configure your environment, learn how to write clear prompts, and apply safe workflows before using Copilot on real data. You focus on testing, verifying results, and protecting your files. These skills help you avoid mistakes and use Copilot with confidence further.

Focus on turning messy, inconsistent datasets into clean and usable data. You standardize headers, split combined fields, fix mixed formats, and remove duplicates using Copilot. Consider real-world scenarios and apply structured workflows to clean data safely.

Discover using Copilot to work with clean data and turn it into insights. You extract values, connect multiple datasets, handle errors, and build dynamic summaries. Learn to describe tasks in plain language while Copilot generates and applies the formulas.

Learn how to present data in a clear and interactive way. Create PivotTables, add slicers, build charts, and apply conditional formatting to highlight key insights. Combine all elements into a structured dashboard and use Copilot to support analysis, formatting, and presentation. 

Build a forecasting model using assumptions, pricing scenarios, and 12-month projections. Test different outcomes, guide Copilot through complex logic, and turn your analysis into a clear, decision-ready recommendation.

Turn your work into a reusable, product-like spreadsheet. Clean raw data, combine multiple sources into a single system, build automated reports, and package everything into a polished template with instructions that anyone can use.

Setting Up Copilot in Excel

What You Need before Moving On