How to Use Copilot in Excel: Full Tutorial (2025)

In this video, I’ll show you how to use Copilot in Excel, step by step. We’ll cover how to enter and edit data, ask questions about your data, and use Copilot to create formulas, format your spreadsheet, build PivotTables and charts, and run data analysis — all using natural language prompts. This tutorial is up to date with the latest Copilot features in Excel as of October 2025. You can download the sample spreadsheet and follow along as we go. github.com/lisacrosbie/CopilotExcel2025 You will need a paid Microsoft 365 Copilot license (used with a work account) to be able to use all the features shown here. Timestamps: 0:00 - Copilot in Excel Full Tutorial Contents 1:46 - Get started with Copilot in Excel 1:57 - Part 1: Add data to your spreadsheet 5:12 - Part 2: Ask questions about your spreadsheet data 7:23 - Switch between Chat and App Skills 9:00 - Part 3: Create formulas and conditional formatting 16:25 - Use Copilot in Excel with text in a spreadsheet 20:24 - Part 4: Create PivotTables and charts 23:03 - Part 5: Analyse your data 26:29 - COPILOT function in Excel ------------------------------------------------------------------- Connect with me: ☕ Buy me a coffee: https://www.buymeacoffee.com/lisacrosbie 🖇 LinkedIn: https://www.linkedin.com/in/lisa-crosbie/ 📼 TikTok: https://www.tiktok.com/@lisa.crosbie