Uploaded June 2026 | Updated September 2026, 2 weeks ago

---

🎓 Copilot Masterclass ➡️ learncopilot.ai/masterclass

Stop copying and pasting pivot tables for every manager. In this Short I show how to split a pivot table into separate sheets in Excel with Microsoft Copilot — one worksheet per manager, each filtered to that person, all still connected to the same pivot table. Add data and every sheet updates together. No copied data, no duplicate pivots, no manual filtering.

📚 Resources Mentioned in this video

Copilot Essentials Course:
➡️ learncopilot.ai/masterclass

🟩 Copilot Essentials for your organization
➡️ teamtraining.learncopilot.ai

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

📨 Subscribe to Copilot Coffee Break newsletter to stay on top of Copilot tips & tricks: davidpba.myflodesk.com/coffee-break

➡️ Become a channel member to get additional perks: youtube.com/channel/UCEJoO7Zkfv45zIjuALuJLTQ/join

🤝 Work with me
🤖 Copilot Essentials On-Demand Course 👉 learncopilot.ai/masterclass
🔗 Microsoft Copilot Courses for busy professionals 👉 learncopilot.ai
💼 LinkedIn 👉 linkedin.com/in/david-fortin-cpa-816b20b5
📧 Business Inquiry 👉 davidfortincpa@davidpba.com

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

#CopilotInExcel #ExcelCopilot #PivotTable #M365