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/
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.
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
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...💙💙
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.
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
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.
Not to mention, business will be handing a large language model ai all their customers personal info. If the copilot has access to say and order sheet with addresses and phone numbers then it has access to other stuff. AI will likely never be used in government business.
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.
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.
@@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.
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)
@@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.
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
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.
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.
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.
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.👏👏👏👏👏
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.
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.
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.
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.
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.
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.
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.
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.
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…
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.
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!
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.
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.
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
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?
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.
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?
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"
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)
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.
Useful only to people who sucks in Excel. Not something I need. Btw, it's ashamed that both Copilot and Power Automate can only be used if the files are stored in the cloud. There are tons of people and companies who have their files stored in their own network drives. Is Microsoft suggesting us to throw away our expensive, already-setup storage devices and start paying monthly for the cloud?
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?
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.
It seems like co-pilot's capabilities are far behind things like GPT 4o. I can have GPT create a chart, change the colors, gradients, etc., all without needing to know how to do anything. That's frustrating. I don't need it to tell me how to do what I already know how to do. I was also surprised by the slow operating speed. Maybe when this has matured for a few years it might be useful, but for now I'll give it a hard pass.
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
❤❤❤brother its a humble request plz guide us about the police cam video editing video plz which no one guided on TH-cam 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 ❤❤❤❤❤
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😂
![ทุกครั้งที่หลับตา (Lucid Dream) - AYLA's [ Official MV ]](http://i.ytimg.com/vi/4i1OBAQyv58/mqdefault.jpg)
![ละลาย (LALALYE) - DAOU PITTAYA ต้าห์อู๋ พิทยา [OFFICIAL MV]](http://i.ytimg.com/vi/wo6r9TgausI/mqdefault.jpg)
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/
good
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.
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
If you try to replicate the Super Bowl Ad examples, it's a complete failure.
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...💙💙
He is great
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.
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
@@ms3862 Its 'clippy' reincarnated!
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.
Not to mention, business will be handing a large language model ai all their customers personal info. If the copilot has access to say and order sheet with addresses and phone numbers then it has access to other stuff. AI will likely never be used in government business.
@@chuckpg31 Microsoft already has access to all that.
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.
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.
@@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.
@@imconfused1237very good response
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)
@@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.
Copilot should been included with office 365 ?
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
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.
Nice! People can now focus more on data quality than processing it.
Double subscription means Microsoft isn't serious in this product ❤
Compute costs are very expensive
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.
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.
Loved your dry humor about all the "cookies" that we are "served" unknowingly on the web!
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.👏👏👏👏👏
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.
THIS is the killer feature that will absolutely either eliminate jobs or create a lot more work for us.
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.
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.
Imagine paying for another subscription for a service you already pay for just to get the latest feature.
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.
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.
As usual, a well explained video..thank you Kevin and your cookie company!!!!
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.
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.
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.
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.
I’d like a video comparing copilot to Chat GPT analyst
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…
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.
finally an easy to understand video on this.
That cookie joke.... take my like sir
Wanted to share my thanks with you for your effort to help us all.
This was an awesome video - really useful. Gave a great insight in if worth using at the moment for Power Users
In this new world, If you are not Rich , then Nothing is for you.
Perfect video as usual! But a small and important note: copilot pro is not available in Israel and I assume in many other countries.💌
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.
My Opinion as an advanced Excel user: Copilot is nice for Excel Beginer, but a burden that slow down Excel Expert
Congrats Kevin
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!
Copilot in Power BI would be a game changer
20$ per month seems expensive for a tool that work on excel slower than me
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.
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.
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.
My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?
Excellent one😊
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
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?
I really appreciate your great work man thanks for helping us 💙💙💙💙💙💙💙
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.
Very poor licensing & onboarding from Microsoft.
Compared to the data analyst tool from OpenAI that you reviewed then Copilot seems weak right now. I am sure that will change :)
Awesome tutorials
Does the copilot pro on home edition differs from the enterprise, as the explainer on msft website is worded differently. Do advise thanks
Thank you.
Kevin, do a video on Copilot on Windows
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?
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"
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?
Does this work on Mac?
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)
Not impressed so far
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.
Useful only to people who sucks in Excel. Not something I need.
Btw, it's ashamed that both Copilot and Power Automate can only be used if the files are stored in the cloud. There are tons of people and companies who have their files stored in their own network drives. Is Microsoft suggesting us to throw away our expensive, already-setup storage devices and start paying monthly for the cloud?
Does it work with multiple tabs?
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?
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?
Currently it only works on one table, unfortunately. I'm sure they have it on their roadmap to go beyond one table.
Embedded AI is fine as long as it works. When it doesn't, prepare for legal action.
can copilot make an html parsed page from an excel sheet?
My copilot was unable to do the very first thing you asked it to do at 5:17 ...
@Kevin: can it perform data analysis with data having 100k plus rows ?
This just does not seem very impressive to me, definetely not $20/$30 per mos impressive
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 😀
Doesn’t seem so great and more cash. The gates family needs more loot.
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
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.
Is your data in a table?
@@KevinStratvert Yes it is in a table
Can copilot convert old excel macros to VBA?
It seems like co-pilot's capabilities are far behind things like GPT 4o. I can have GPT create a chart, change the colors, gradients, etc., all without needing to know how to do anything. That's frustrating. I don't need it to tell me how to do what I already know how to do. I was also surprised by the slow operating speed. Maybe when this has matured for a few years it might be useful, but for now I'll give it a hard pass.
Copilot suddenly stopped working in Excel for me. Works great in Word and PowerPoint, but now useless in Excel
It means Microsoft is reading all OneDrive material- whether you want it or no
😅.. that’s not me but Bill smiling..
How much are your cookies? Do y’all deliver?
good!
Seen another video, Copilot couldn’t handle large amounts of data. < 500 rows of excel data.
It's hilariously bad in PowerPoint. Absolutely garbage. Somewhat better in Excel.
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
First comment ❤ I love you work man
Copilot the future 🏃♀️🏃♀️🏃♀️
If this is in 'Preview' then why am I paying $20/month?
Too expensive
Joder le ponen voz de mujer con una traducción automática, que desastre para un contenido tan bueno.
More than 8 rows of data it struggles. Major fail. We need thousands of lines of data points.
not waht i want
❤❤❤brother its a humble request plz guide us about the police cam video editing video plz which no one guided on TH-cam 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 ❤❤❤❤❤
Ai is all hype
No it’s great.
Wow this is actually very unimpressive
in spanish audio track , i suffer, prefer change to english with my bad english level
I would like to seen something impressive. This is all novice stuff. I still wonder if CP can do something special... I haven't seen so far
Looks like this is waaay overhyped…
Co pilot is too expensive.
This Copilot is more like autopilot 😂
Meh... it sounds like it allows you to use excel using plain English rather than using formulas. That's cool, I guess.
Let's use AI to do things I can do more quickly myself 😀
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😂
Bad not to be free
The cia getting fat in the pants with this