Six ways to use the amazing Agent Mode in Excel

Explore the Six ways to use the unique and amazing Agent Mode with Copilot in Microsoft Excel. Perform complex actions with ease.

It works on a single Excel file and can perform complex actions in a methodical manner. Just explain what you want and it will think, plan, execute, cross check and deliver results. We will test it with six scenarios representing common activities we perform in Excel.

Contents

1. Intro – 00:00
2. S1 – Conditional Formatting – 00:20
3. S2 – Analyse files / formulas – 01:31
4. S3 – Create Dashboard – 03:12
5. S4 – Fin Report Interpretation – 04:23
6. S5 – Complex Formula – 04:59
7. S6 – Data Consolidation – 06:08
8. Most important use case – 07:45
9. Install Agent Mode – 08:08
10. Auditing Agent Mode changes – 08:58
11. Which tool to use when – 09:50
12. What to do with the time saved – 10:24
13. Summary – 10:52

Related videos

Check out my other videos on Excel and Power BI