Using Copilot in Excel for Data Analysis and Asking Questions
Chris Menard Chris Menard
69.7K subscribers
2,089 views
0

 Published On Feb 12, 2024

The focus of this video is using Copilot in Excel to perform data analysis and ask questions. I demonstrate this by exploring various data like car brand, dealerships, revenue, and cost. I ask Copilot questions about total revenue per month, total revenue per quarter, top three car brands by revenue, and group revenue by rep. Copilot not only gives accurate results but also generates charts and graphs for better data visualization.

Copilot is pretty accurate but I also show briefly how to check the data, to make sure. Copilot's available in Word, PowerPoint, Excel, Outlook, and Teams.

My Excel and Teams courses are available now:
https://courses.chrismenardtraining.com/

Chapters:
00:00 Introduction
00:13 Getting Started with Copilot in Excel
00:36 Exploring the Data
01:11 Using Copilot to Analyze Revenue by Month
02:21 Analyzing Revenue by Quarter
02:52 Identifying Top Car Brands by Revenue
03:43 Grouping Revenue by Sales Rep
04:26 Conclusion

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

#excel #copilot #chrismenard

show more

Share/Embed