NEW Copilot Features That Will Set You Apart in Excel @MyOnlineTrainingHub
NEW Copilot Features That Will Set You Apart in Excel  @MyOnlineTrainingHub
Uploaded September 2026 | Updated November 2026, 3 days ago
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: bit.ly/copilot26file
👩‍🏫 Become an Excel Expert with my course: 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: myonlinetraininghub.com/excel-newsletter-sign-up

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

💬 EXCEL QUESTIONS: Get help on our Excel Forum: 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
NEW Copilot Features That Will Set You Apart in ExcelExcel Formatting Tricks That Make You Look Like a ProUnveiling Power Query AI Web Import Enhancements5 Hidden Excel Formula Rules That Make Everything EasierAre You Missing Out on Excel’s Secret Function?Excel: 8 AI Game-Changers!Catch Excel Formula Errors Before They Cost You (File Included)The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)Freeze Panes to Lock Rows and Columns in ExcelNEW - Images & Data Types in PivotTables, WOW!Interactive Excel Dashboard for BETTER Data Visualization (Free Download)Excel’s Best & Worst Formulas for Speed (Real Test Results)
MyOnlineTrainingHub |

NEW Copilot Features That Will Set You Apart in Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER