Skip to main content
AmigoFish

NEW Copilot Features That Will Set You Apart in Excel

From MyOnlineTrainingHub · · 11 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Set up Copilot in Excel to reuse your instructions, follow workbook guidelines and build recurring reports with shorter prompts. ⬇️ Download the example file here and follow along: https://bit.ly/copilot26file 👩‍🏫 Become an Excel Expert with my course: https://bit.ly/copilot26course

If you’ve been giving Copilot the same formatting corrections, explaining the same workbook or rewriting the same monthly reporting request, there’s a better way to set it up.

In this Microsoft Excel tutorial, I show you how Personalization saves your working preferences, how a .Rules worksheet gives Copilot instructions for a particular workbook, and how custom skills let you reuse a process across different files.

You’ll see a monthly sales summary example that groups revenue by region, calculates each region’s share and creates a table and chart. The reusable instructions are written in plain language, so this example doesn’t require you to write code. Next month, you can call the same skill on new sales data instead of rewriting the full request.

I also cover reviewing a plan before Copilot edits your workbook, styling reports, and bringing in context from the web, Microsoft 365 work content, Power BI and other connected sources. A polished result still needs checking: saved instructions guide Copilot, but they don’t guarantee correct calculations.

You’ll need a supported Microsoft 365 subscription with Copilot access. Features and menus can vary by account, Excel version, update channel and organization settings. Custom skills use a OneDrive folder, and work data connections require the appropriate access. Keep the .Rules worksheet visible so Copilot can read it.

LEARN MORE ===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up

🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS ============== 0:00 Gave up on Copilot? Here’s what’s changed 0:23 One less hurdle before you start 0:38 Get that floating button out of the way 1:00 What you need to know 1:44 Feature №1: stop repeating the same corrections 2:34 Feature №2: give your workbook instructions 3:59 Feature №3: turn your prompts into skills 7:58 An AI report can still be wrong 8:38 Feature №4: connect Copilot to other data 10:49 Automate even more work in Excel

#Excel #Copilot #CopilotTutorial

Back to MyOnlineTrainingHub · Report a problem