Copilot in Excel: Hype or Future?
ฝัง
- เผยแพร่เมื่อ 28 พ.ค. 2024
- 🔥 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 TH-cam
th-cam.com/users/kevlers?...
🙌 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 - วิทยาศาสตร์และเทคโนโลยี
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.
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
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
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.
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
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.
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.
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'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.
As usual, a well explained video..thank you Kevin and your cookie company!!!!
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.
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.
finally an easy to understand video on this.
This was an awesome video - really useful. Gave a great insight in if worth using at the moment for Power Users
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.
Excellent one😊
Wanted to share my thanks with you for your effort to help us all.
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.
Does the copilot pro on home edition differs from the enterprise, as the explainer on msft website is worded differently. Do advise thanks
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.
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.
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 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.
Awesome tutorials
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.
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.
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…
I really appreciate your great work man thanks for helping us 💙💙💙💙💙💙💙
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"
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.
Thank you.
Congrats Kevin
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.
Perfect video as usual! But a small and important note: copilot pro is not available in Israel and I assume in many other countries.💌
can copilot make an html parsed page from an excel sheet?
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?
Does this work on Mac?
My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?
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?
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 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!
Does it work with multiple tabs?
That cookie joke.... take my like sir
My copilot was unable to do the very first thing you asked it to do at 5:17 ...
In this new world, If you are not Rich , then Nothing is for you.
@Kevin: can it perform data analysis with data having 100k plus rows ?
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.
First comment ❤ I love you work man
Can copilot convert old excel macros to VBA?
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.
Copilot in Power BI would be a game changer
good!
20$ per month seems expensive for a tool that work on excel slower than me
Kevin, do a video on Copilot on Windows
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)
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
Compared to the data analyst tool from OpenAI that you reviewed then Copilot seems weak right now. I am sure that will change :)
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
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
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.
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.
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?
Doesn’t seem so great and more cash. The gates family needs more loot.
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 😀
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
in spanish audio track , i suffer, prefer change to english with my bad english level
Embedded AI is fine as long as it works. When it doesn't, prepare for legal action.
❤❤❤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 ❤❤❤❤❤
Very poor licensing & onboarding from Microsoft.
It means Microsoft is reading all OneDrive material- whether you want it or no
😅.. that’s not me but Bill smiling..
If this is in 'Preview' then why am I paying $20/month?
Seen another video, Copilot couldn’t handle large amounts of data. < 500 rows of excel data.
Copilot suddenly stopped working in Excel for me. Works great in Word and PowerPoint, but now useless in Excel
This just does not seem very impressive to me, definetely not $20/$30 per mos impressive
More than 8 rows of data it struggles. Major fail. We need thousands of lines of data points.
Not impressed so far
not waht i want
It's hilariously bad in PowerPoint. Absolutely garbage. Somewhat better in Excel.
Too expensive
Ai is all hype
No it’s great.
Copilot the future 🏃♀️🏃♀️🏃♀️
Wow this is actually very unimpressive
Looks like this is waaay overhyped…
This Copilot is more like autopilot 😂
The cia getting fat in the pants with this
Let's use AI to do things I can do more quickly myself 😀
who the gives idea to microsoft ? I'm sure they will retrieve one subscription out of two.
Meh... it sounds like it allows you to use excel using plain English rather than using formulas. That's cool, I guess.
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
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
This is horrible and I feel Microsoft is dead. Too expensive too
Hey
VIDEO EDITOR HERE 📹
First comment ❤ I love you work man
First comment ❤ I love you work man