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
Watch video Using Copilot in Excel for Data Analysis and Asking Questions online without registration, duration hours minute second in high quality. This video was added by user Chris Menard 12 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,658 once and liked it 59 people.