Copilot in Excel: Hype or Future?

Подписаться 3 млн

Просмотров 152 тыс.

50% 1

🔥 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 Ta...
- Sample data to follow along: 1drv.ms/x/s!AmxrofZZlZ-whcxQl...
⌚ 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: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / 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 RU-vid
ru-vid.com?...
🙌 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

Наука

Опубликовано:

22 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 132

@KevinStratvert 3 месяца назад

Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

@user-mc6qy1tl3d 2 месяца назад

good

@TheSingularitarian 3 месяца назад

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.

@mcwahaab 3 месяца назад

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.

@ms3862 2 месяца назад

This is lame, i can do all these functions quicker using the mouse and keyboard. Co-pilot looks like a feature for people who dont know how to use excel, its not a productivity enhancement for pros

@ochuutv7195 3 месяца назад

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...💙💙

@nkechiizeji 3 месяца назад

He is great

@stephencooper3583 3 месяца назад

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.

@error7329 3 месяца назад

Copilot should been included with office 365 ?

@Magerquark 27 дней назад

This would definitely make the 365 subscription very sweet, I wonder why they haven't done it already, probably because they couldn't handle the amount of users yet

@tekmepikcha6830 3 месяца назад

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

@cw1217 3 месяца назад

If you try to replicate the Super Bowl Ad examples, it's a complete failure.

@vaderetrosatana6647 2 месяца назад

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.

@b-tec 3 месяца назад

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.

@lorenakademar5267 2 месяца назад

As usual, a well explained video..thank you Kevin and your cookie company!!!!

@dreamcatcher3748 3 месяца назад

Thank you Kevin! Great job going through the cost, setup and use of Copilot and Excel. I think Microsoft is doing a great job of integration so far. I imagine in 3-5 years, it will do amazing things! I also imagine that the entire back-office B2B system structure is going to change and become more efficient as the tools become smarter.

@fil4dworldcomo623 3 месяца назад

Nice! People can now focus more on data quality than processing it.

@pravinshingadia7337 Месяц назад

This was an awesome video - really useful. Gave a great insight in if worth using at the moment for Power Users

@ishtiaqahmed7666 3 месяца назад

Excellent one😊

@onlysublime 3 месяца назад

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 2 месяца назад

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.

@RaymWoo 3 месяца назад

Does the copilot pro on home edition differs from the enterprise, as the explainer on msft website is worded differently. Do advise thanks

@Alban.Bytyqi Месяц назад

Wanted to share my thanks with you for your effort to help us all.

@haroldbrown3452 10 дней назад

finally an easy to understand video on this.

@ralph5607 2 месяца назад

Kevin please make a video about how to fix an issue about steam having problem creating an account because I need a steam account but when I've done inserting the personal info, it keeps resetting when I pressed the button "continue"

@JS-ft8lo 3 месяца назад

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.

@piggybankaccountant 2 месяца назад

Hey Kevin, great explanation as usual. I'm wondering if people using Copilot in Excel know to need how to prompt or it doesnt matter how we ask our questions? I try to teach people how to prompt on copilot (the bing search tool) itself and I've seen considerable difference.

@equinonez55 2 месяца назад

Excellent explanation. However, I and many like me, have not gotten PRO yet. Could you explain how to use Copilot to get an Excel formula going correctly by using regular Copilot, as in throug the Microsoft browser?

@TechnoEveryday 3 месяца назад

Double subscription means Microsoft isn't serious in this product ❤

@TheSterg98 2 месяца назад

Compute costs are very expensive

@user-mc6qy1tl3d 2 месяца назад

Awesome tutorials

@rp26101 2 месяца назад

Been using M365 Copilot since it was in private preview. For now, it's all hype. If you are an Excel power user, you won't be impressed. However, when it does improve, it'll change the way you work.

@bilalahmedsiddiqui9639 3 месяца назад

Imagine paying for another subscription for a service you already pay for just to get the latest feature.

@imconfused1237 3 месяца назад

Welcome to the subscription cost model. Service layering is becoming too expensive. Our users also hate the change frequency. You don’t need new monthly versions.

@sayedantar9671 28 дней назад

I really appreciate your great work man thanks for helping us 💙💙💙💙💙💙💙

@karenrussell2885 22 часа назад

Need to be able to add lines of the same text to a cell in a column. Is there any way to automate this? adding the line within the cell is my struggle.

@Nabd-16 2 месяца назад

My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?

@ronkessler9278 2 месяца назад

Perfect video as usual! But a small and important note: copilot pro is not available in Israel and I assume in many other countries.💌

@jasonlattier5274 2 месяца назад

I can only access copilot in the browser, not the app. Tried several times to save file to Onedrive. It is saved there successfully. However, Copilot is still greyed out in the ribbon. Why is this?

@vvanishv02 3 месяца назад

My colleague is using it in a corporate setting and the dual issue of all data in cloud/sharepoint as well as everything needing to be in a table is a blocker for full use. There are some features which will help our marketing team but beyond that, we need a big change over time.

@k.c1126 3 месяца назад

This is my initial reaction as a single user. There are going to be instances when either or both actions are just not going to be feasible for me.

@vap0rtranz 3 месяца назад

I don't see these as blockers. Tables were required for Excel to do lots of functions before Copilot came along. OneDrive is just cloud storage, and who isn't storing data in clouds now? MS offers a free account. The bigger problem is the data limit size. Kevin is the 2nd YTuber to demo Copilot + Excel in depth, he also noticed that Copilot struggles with large datasets, and had to truncate the table to get Copilot to work. Large datasets are a huge reason for getting computers to analyze information. Truncating data is a non-starter.

@SKMRify 2 месяца назад

Thank you.

@precisionrp 2 месяца назад

can copilot make an html parsed page from an excel sheet?

@shashankbisht2352 3 месяца назад

@Kevin: can it perform data analysis with data having 100k plus rows ?

@David-kh2gk 3 месяца назад

Does this work on Mac?

@KarynHill 3 месяца назад

I know Microsoft is still working on Copilot and that they're doing great things with it-internally. I hope they'll let some of that power loose for subscribers to make use of soon. Until then, the cost is prohibitive for the small amount it can do. I will say the beta does a better job of rewriting emails and short blog posts without sounding like someone trying to show off their vocabulary. It's much better at direct and simple while still sounding professional.

@duartecolaco3022 2 месяца назад

Does it work with multiple tabs?

@viralarchitect 3 месяца назад

THIS is the killer feature that will absolutely either eliminate jobs or create a lot more work for us.

@imconfused1237 3 месяца назад

Our company looked at this. We don’t see the benefit to customers. It was the same with offshoring call centres; cheaper to do but destroys customer experience. We gained 13% market share from not doing it.

@imconfused1237 3 месяца назад

Moreover, AI doesn’t pay taxes; and taxes are required. In addition, AI doesn’t buy a lunch to make commercial real estate viable. Simple example to illustrate interconnected economies within towns and cities.

@eva2019damihianimas. 3 месяца назад

Congrats Kevin

@DerikTran 3 месяца назад

Can you compare 2 sheets and see differences like which records are missing in each sheet? Or do a closest match like customer matches from one data sheet compared to the current customer master?

@KevinStratvert 3 месяца назад

Currently it only works on one table, unfortunately. I'm sure they have it on their roadmap to go beyond one table.

@tluv42 2 месяца назад

I’d like a video comparing copilot to Chat GPT analyst

@Locomaid 2 месяца назад

Chat GPT is a language model and not very good at math and science (status April 2023). My main experience in this area has been using it in a Harvard microbiology course (where I struggled, due to lack of background knowledge). It was wrought with mistakes in scientific notation and tended to just make stuff up. That said, Chat GPT can throw together a concept or campaign outline in the blink of an eye, especially if prepped correctly. Copilot, not yet, IMHO. Remark: I am quite good at prompt engineering, so that is less the issue…

@MuhammadAhmedMuddie 3 дня назад

I cannot use Copilot in the app for Excel like I can for Word and Excel. I can only utilise Excel on the browser. Help?

@Tjwheat903 3 месяца назад

That cookie joke.... take my like sir

@NaturalBornChilla666 Месяц назад

My copilot was unable to do the very first thing you asked it to do at 5:17 ...

@skirolf 2 месяца назад

Can copilot convert old excel macros to VBA?

@apoliteconversationplease8840 Месяц назад

Kevin when I asked Copilot to create a line chart (twice) it said: " apologize for any confusion. I am a text-based AI and do not have the ability to create or manipulate sheets in your workbook. I can provide you with instructions on how to create a PivotTable that shows the profit by month using the data in your active table. Would you like me to do that?" Very strange!

@Roy-gg8qe 3 месяца назад

First comment ❤ I love you work man

@derektalbot4887 3 месяца назад

Hi Kevin, Off topic, but can you tell me how I can stop the new version of teams from sending emails that are not relevant to me? I still need it to send me emails for meetings that are relevant to me, can it even be done? thanks Kevin

@bernardoalamos1961 3 месяца назад

Please make a video of Copilot and excel with .PDF or .PNG files that have excel data on them, tables, etc., or even a video that holds different frames with data, so as to not take .PNG and analyze step by step (maybe a macro could do it)

@imconfused1237 3 месяца назад

For business, Copilot is just too expensive. The licensing model doesn’t work. Microsoft need to build an E5+ stack and roll it into that. I am a board member for a 30k+ UK plc.

@Ether0 3 месяца назад

Maybe your buisness model is wrong bro. Implement own Ai solutions instead outsorceing it, if you really need it. Copilot simply does things faster and easier, but isn’t necessary, like all Ai tools.

@imconfused1237 3 месяца назад

@@Ether0Our model is fine, “bro” 😊 I see you’re not familiar with the MS business model. They will eventually crash the price for enterprise. They always do.

@dougsaunders8109 3 месяца назад

@@imconfused1237very good response

@iseptimus 3 месяца назад

Depends on your seats and true up. 100,000 user business here and it's significantly cheaper. But still extortionate. The true up costs and license changes could be brutal (especially if Azure is anything to go by recently)

@imconfused1237 3 месяца назад

@@iseptimus For us, it’d add £1.1m to our monthly overhead. But the ROI is too niche; there isn’t £1m of upside in automating slide decks. That’s not how you create value.

@jasonlattier5274 2 месяца назад

i saved in onedrive, I enabled autosave. I have the necessary subscriptions. The copilot button is still grey in my app. I can use office and open excel spreadsheets in edge browser and the Copilot button is active. In ALL MY OTHER Microsoft Apps (Word, Note, Powerpoint) the Copilot button is active. I am ONLY having the grey button in excel. WHY? Please help.

@KevinStratvert 2 месяца назад

Is your data in a table?

@jasonlattier5274 2 месяца назад

@@KevinStratvert Yes it is in a table

@jespernohr 3 месяца назад

Compared to the data analyst tool from OpenAI that you reviewed then Copilot seems weak right now. I am sure that will change :)

@jasonzhang3797 2 месяца назад

good!

@lkgpuanimho0349 3 месяца назад

Kevin, do a video on Copilot on Windows

@albertr8008 19 дней назад

I am going to let other people subsidise and contribute to this product’s improvement, and jump in in a year or two when it’s actually ready.

@SMASH_REVIEWS 3 месяца назад

In this new world, If you are not Rich , then Nothing is for you.

@emile8147 Месяц назад

20$ per month seems expensive for a tool that work on excel slower than me

@snakebyteOne 2 месяца назад

Just the time savings alone from Copilot generating formulas and formatting is worth the monthly cost. Not convinced this technology will be putting data analysts out of work ... yet

@lkgpuanimho0349 3 месяца назад

Copilot in Power BI would be a game changer

@Tortugostalker 3 месяца назад

I´m quite dissapointed. Probably in a couple of years this could be quite impressive. But for now, two suscriptions for a "copilot" that does the things you already know in excel.... totally for begginers.

@raymondhansen4482 Месяц назад

Great video, I am working on a mac, when prompting copilot to create a line chart, it tells me to do it manually. Is that a mac compatibility thing?

@bill9989 Месяц назад

If we have to reduce our data for Copilot to work, then it isn't ready for prime time. Don't give them money until they get it right.

@MariaFoodsecrets 2 месяца назад

❤❤❤brother its a humble request plz guide us about the police cam video editing video plz which no one guided on RU-vid like ex cop , blue pov , mr detective , catching killers etc plz plz plz consider my request its a humble request to you brother wonder of thanks ❤❤❤❤❤

@AkhtarNaqvi 3 месяца назад

Kevin, I did not see your disclaimer of any support from Microsoft (or is it not the case?). I think your examples in this video are over simplistic with perfect column titles and classical data scenario. For real world data, my opinion is that at this stage it is not worth the subscription fee. Google is still a better choice for me for the cost alone. Hopefully, Copilot will become better in future and may be worth subscription then.

@ianbriers5019 2 месяца назад

Sounds very nice but very expensive at £19.99 per month 😮 if round £70 per year like office 365 may be definitely not £19.99 no way

@Dondriver12345 Месяц назад

I would ask my employer to add these $20 to my salary instead of buying me the subscription. Even 10 bottles of beer are better than nothing 😀

@SPECTRE_Island 2 месяца назад

If this is in 'Preview' then why am I paying $20/month?

@user-lc1vg9gj6m 2 месяца назад

in spanish audio track , i suffer, prefer change to english with my bad english level

@richardsteiner8992 2 месяца назад

Embedded AI is fine as long as it works. When it doesn't, prepare for legal action.

@JaiRudraNath 3 месяца назад

It means Microsoft is reading all OneDrive material- whether you want it or no 😅.. that’s not me but Bill smiling..

@JakeValentineStory 3 месяца назад

Copilot suddenly stopped working in Excel for me. Works great in Word and PowerPoint, but now useless in Excel

@AndiSzilagyi 3 месяца назад

Very poor licensing & onboarding from Microsoft.

@pagnonig 3 месяца назад

Not impressed so far

@chicagomike 3 месяца назад

Doesn’t seem so great and more cash. The gates family needs more loot.

@chadreed8032 3 месяца назад

More than 8 rows of data it struggles. Major fail. We need thousands of lines of data points.

@steffanking85 2 месяца назад

Seen another video, Copilot couldn’t handle large amounts of data. < 500 rows of excel data.

@spicybean8 3 месяца назад

not waht i want

@chuffman24 3 месяца назад

This just does not seem very impressive to me, definetely not $20/$30 per mos impressive

@albertjans 3 месяца назад

Too expensive

@iseptimus 3 месяца назад

It's hilariously bad in PowerPoint. Absolutely garbage. Somewhat better in Excel.

@Dante-fk4yi 3 месяца назад

Ai is all hype

@chicagomike 3 месяца назад

No it’s great.

@thatomofolo452 3 месяца назад

Copilot the future 🏃‍♀️🏃‍♀️🏃‍♀️

@50_Pence 3 месяца назад

The cia getting fat in the pants with this

@Roardny 2 месяца назад

This Copilot is more like autopilot 😂

@LionTheKingJoker 3 месяца назад

Looks like this is waaay overhyped…

@WhySoBroke 3 месяца назад

Wow this is actually very unimpressive

@Scolopente 3 месяца назад

Let's use AI to do things I can do more quickly myself 😀

@Kamalfayadh 2 месяца назад

Bad not to be free

@arunkumar4u Месяц назад

who the gives idea to microsoft ? I'm sure they will retrieve one subscription out of two.

@M.Evra91 2 месяца назад

Meh... it sounds like it allows you to use excel using plain English rather than using formulas. That's cool, I guess.

@sivamandava7682 2 месяца назад

Thats it? $20 for that? That is basic excel. I can do it faster than the copilot. Everybody knows basic excel or can search these queries for free on the web😂

@ms3862 2 месяца назад

This is lame, i can do all these functions quicker using the mouse and keyboard. Co-pilot looks like a feature for people who dont know how to use excel, its not a productivity enhancement for pros