Microsoft Copilot in Excel: 15-Minute Beginner Demo + Practical Prompts

Copilot in Excel: Easy Prompts to Analyse Your Data in Minutes New to Copilot, or not sure where to start? In this demo, Ollie from Genmar IT shows you some simple, practical ways to use Copilot in Excel. He uses a sample sales spreadsheet and plain-English prompts throughout. You'll see Copilot pick out trends in the data and answer business questions. It also adds formula columns, applies formatting and filters, and builds charts and pivot tables. Every change waits for your approval before it's applied, so you stay in control. It's aimed at beginners. No formulas or technical know-how needed, just prompts you can try on your own spreadsheets straight away. Chapters 0:00 Introduction 0:46 The demo data 1:13 Opening Copilot in Excel 1:44 "What's interesting about this data?" 2:06 Choosing your AI model 4:29 Finding the highest and lowest sales 5:53 Asking a business question 6:29 Adding formula columns 8:24 Formatting, highlighting and filtering 10:00 Creating a bar chart 11:15 Building a pivot table 11:45 Refining results with follow-up prompts 13:10 Switching the chart to percentages 13:58 "Why did that month perform best?" 14:30 Wrap-up This is the first video in our Copilot series. PowerPoint and Word demos are coming next, so subscribe so you don't miss them. Want help getting more out of Microsoft 365 and Copilot in your business? Get in touch with Genmar IT: https://www.genmar.co.uk/lets-talk #Copilot #MicrosoftExcel #Microsoft365 #AI #ExcelTips