Excel Copilot Writes Formulas For You: Complete Guide

I want to walk you through a practical, hands-on look at how Copilot writes your formulas in Excel and why this feature is a game changer for anyone building spreadsheets. Whether you are an absolute beginner or an experienced user, the moment you type the equals sign Copilot can suggest the exact formula you need. In this guide I'll show you real examples, explain what Copilot is doing, point out current limitations, and share tips to make the most of it.

What it means when Copilot writes your formulas in Excel

When I say "Copilot writes your formulas in Excel" I mean the moment you start a formula by typing = Copilot proactively generates a suggested formula tailored to the surrounding data and column headers. It uses context from your worksheet—headers, neighboring cells, data types—and shows you a fully formed function with arguments already filled in. That saves time, reduces errors, and helps you learn the proper functions without hunting through the function library.

Right now this capability is rolling out and is available in Excel on the web. I tested it extensively and it did not trigger in my desktop Excel at the time, but Microsoft is planning to extend the feature to the desktop. Keep that in mind when you try it: if you do not see suggestions, check if you are using Excel on the web and that your tenant has the rollout.

I walk through several practical examples including concatenating text, extracting dates with MONTH and TEXT functions, calculating profit and percentages, and splitting names with RIGHT, LEN, and FIND functions. You'll see how Copilot suggests formulas the moment you type the equals sign in a cell.

Whether you're a basic or intermediate Excel user, this feature helps you work faster and learn proper Excel functions as you go. Even as an experienced user, I find it speeds up my workflow considerably.

What you'll learn:
* How to activate formula generation in Excel Copilot
* Text manipulation with CONCATENATE
* Date functions (MONTH and TEXT)
* Number calculations and percentages
* Advanced text extraction with nested functions

Want to learn more? My Excel online training classes cover this feature and more, including Microsoft Teams and OneNote. Links below:
https://courses.chrismenardtraining.com

Join me for my upcoming livestream on Microsoft Copilot on October 29th:
https://www.linkedin.com/events/7383916028176789504/

Or attend my in-person Excel and Copilot training at EA Ignite in Nashville this November:
https://www.linkedin.com/feed/update/urn:li:activity:7386451717640470529/

And make sure you subscribe to my channel!

Chapters:
00:00 Introduction and Announcements
00:57 Generating Formulas with Copilot
02:01 Text and Date Functions
03:37 Working with Numbers
05:08 Advanced Text Functions
05:34 Conclusion

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Видео Excel Copilot Writes Formulas For You: Complete Guide канала Chris Menard