Copilot in Excel: Hype or Future?

181,677
0
Published 2024-02-19
🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com/
🤖 Get Copilot Pro and Microsoft 365: bit.ly/3CUmtZw

In this video, we dive deep into Copilot's capabilities, exploring:

- Effortless Data Exploration: Discover trends, outliers, and insights hidden within your spreadsheets with just a few clicks.
- Formula Magic: Generate formula suggestions for complex calculations, saving you time and frustration.
- Visualization Made Easy: Create professional-looking charts and PivotTables, bringing your data to life.
- Is Copilot the future of Excel? We analyze its potential and limitations, helping you decide if it's the right tool for your needs.

Whether you're a seasoned Excel pro or just starting out, this video will show you how Copilot can revolutionize your spreadsheet workflow.

📚 RESOURCES
- Get Copilot Pro and Microsoft 365: bit.ly/3CUmtZwl
- Learn Pivot Tables in Excel:    • How to Create Pivot Table in Excel  
- Sample data to follow along: 1drv.ms/x/s!AmxrofZZlZ-whcxQlWO6gcx0o258Og?e=D4RcV…

⌚ TIMESTAMPS
00:00 Introduction
00:26 Get Copilot
01:20 Upload workbook to cloud
02:19 Convert data range to table
03:35 Sample prompts
04:18 Simple prompt
06:02 Add new column
07:05 Conditional formatting
07:47 Make pivot tables
09:15 Make chart
10:27 Identify data trends
11:16 Wrap up

📺 RELATED VIDEOS
- Playlist with all my videos on Excel:    • ❎ How to use Excel  

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com/
- LinkedIn: www.linkedin.com/in/kevinstratvert/
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: www.tiktok.com/@kevinstratvert
- Instagram: www.instagram.com/kevinstratvert/

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel #copilot

All Comments (21)
  • Sir, I hope you're making a fine living with this channel, because you are helping the rest of us keep ourselves sharp and up to date with all the tools for today's business world.
  • @ochuutv7195
    Kelvin you're the best at what you do... you do know how to communicate to your viewERs in a simple concise manner.. that's why I don't get tired watching and listeninģ to you... Thank you for the knowledge sharing...💙💙
  • @error7329
    Copilot should been included with office 365 ?
  • @mcwahaab
    Based on its capabilities, Copilot performs a function similar to other Excel features. I was actually expecting a significant transformation comparable to Power Query or Dynamic Arrays.
  • @tekmepikcha6830
    Copilot was advertised as available waay before it even was. That was so confusing because ppl thought the preview version, or the free version was the actual Pro version. Then the subscription website wasn't even working. So I hope what my trusted mentor is presenting to us is actually the real Copilot Pro
  • Seems more like a tool for people who don't really know excel too well. And that's fine really... you'd be surprised how many otherwise intelligent people don't know how to use a simple pivot table or put in a conditional format. But advanced excel users can likely pass... they can do this stuff in their sleep. Then again, I'm sure this video only scratches the surface. I'm wondering if it works with Power Query and some of the more advanced features. It's also worth mentioning that with the subscription, you get the CoPilot in other programs like Word, Outlook, PowerPoint, etc. I saw a PowerPoint demo, and it really did seem pretty useful. But not for me though... it's not worth the money for what I typically do, but to each his own.
  • Nice! People can now focus more on data quality than processing it.
  • I adore your channel, you are so very intelligent and inspiring. I recently enrolled in a data science course and really enjoyed it your videos. Thank you for sharing your thoughts.
  • As usual, a well explained video..thank you Kevin and your cookie company!!!!
  • Dear Kevin, Excellent inclusion of the audio track in your videos. I hope everyone follows your lead. Congratulations for making your videos easier to understand.👏👏👏👏👏
  • @TechnoEveryday
    Double subscription means Microsoft isn't serious in this product ❤
  • This was an awesome video - really useful. Gave a great insight in if worth using at the moment for Power Users
  • @b-tec
    I've been trying to get Copilot 365 to do the most basic tasks in Excel for a couple weeks, including formatting, and it refuses. So far the preview is garbage.
  • @JS-ft8lo
    Do you know if copilot can write a formula to find a specific value that'sassociatedwith a word/somebtext, let's use Rent as an example, in a Profit and Loss spreadsheet? The reason I ask is the line that my Rent might be in line 24 during one period and line 22 in another so a formula that pulls the value out of the same cell each time won't work for me.
  • @onlysublime
    Oh wow. This looks awesome. I'm curious how much data before it performs too slowly. And what is the success rate. I don't know how many failures were excluded from the video. And I wonder how it performs with poorly built spreadsheets. I've encountered many awful spreadsheet designs. And lastly, how well does it diagnose errors in the spreadsheets. If it can do that well, it would be a massive time saver.
  • @jasonr.8907
    If I have to adjust the data for the AI to understand it seems like it’s not worth the extra cost. And I agree, this should be included in MS 365 subscription.
  • @Alban.Bytyqi
    Wanted to share my thanks with you for your effort to help us all.