Copilot in Excel: Hype or Future?
Ғылым және технология
🔥 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 KZread
kzread.info?...
🙌 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
Пікірлер: 137
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
3 ай бұрын
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.
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
Copilot should been included with office 365 ?
@Magerquark
Ай бұрын
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
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
3 ай бұрын
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
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.
As usual, a well explained video..thank you Kevin and your cookie company!!!!
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.
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.👏👏👏👏👏
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.
This was an awesome video - really useful. Gave a great insight in if worth using at the moment for Power Users
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.
@chuckpg31
4 күн бұрын
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.
Wanted to share my thanks with you for your effort to help us all.
Excellent one😊
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.
finally an easy to understand video on this.
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.
Awesome tutorials
I really appreciate your great work man thanks for helping us 💙💙💙💙💙💙💙
Thank you.
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.
Does the copilot pro on home edition differs from the enterprise, as the explainer on msft website is worded differently. Do advise thanks
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.
Congrats Kevin
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?
First comment ❤ I love you work man
My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?
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"
That cookie joke.... take my like sir
Double subscription means Microsoft isn't serious in this product ❤
@TheSterg98
2 ай бұрын
Compute costs are very expensive
Perfect video as usual! But a small and important note: copilot pro is not available in Israel and I assume in many other countries.💌
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.
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.
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.
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?
I’d like a video comparing copilot to Chat GPT analyst
@Locomaid
3 ай бұрын
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…
Does this work on Mac?
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.
can copilot make an html parsed page from an excel sheet?
good!
Does it work with multiple tabs?
Kevin, do a video on Copilot on Windows
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.
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.
@Kevin: can it perform data analysis with data having 100k plus rows ?
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.
My copilot was unable to do the very first thing you asked it to do at 5:17 ...
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.
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?
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)
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.
Can copilot convert old excel macros to VBA?
Compared to the data analyst tool from OpenAI that you reviewed then Copilot seems weak right now. I am sure that will change :)
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!
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
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
3 ай бұрын
Is your data in a table?
@jasonlattier5274
3 ай бұрын
@@KevinStratvert Yes it is in a table
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.
In this new world, If you are not Rich , then Nothing is for you.
Copilot in Power BI would be a game changer
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.
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?
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
20$ per month seems expensive for a tool that work on excel slower than me
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.
❤❤❤brother its a humble request plz guide us about the police cam video editing video plz which no one guided on KZread 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 ❤❤❤❤❤
My Opinion as an advanced Excel user: Copilot is nice for Excel Beginer, but a burden that slow down Excel Expert
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
Very poor licensing & onboarding from Microsoft.
in spanish audio track , i suffer, prefer change to english with my bad english level
If this is in 'Preview' then why am I paying $20/month?
It means Microsoft is reading all OneDrive material- whether you want it or no 😅.. that’s not me but Bill smiling..
Embedded AI is fine as long as it works. When it doesn't, prepare for legal action.
Copilot the future 🏃♀️🏃♀️🏃♀️
Not impressed so far
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.
not waht i want
Seen another video, Copilot couldn’t handle large amounts of data. < 500 rows of excel data.
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
This just does not seem very impressive to me, definetely not $20/$30 per mos impressive
Copilot suddenly stopped working in Excel for me. Works great in Word and PowerPoint, but now useless in Excel
Ai is all hype
@chicagomike
3 ай бұрын
No it’s great.
More than 8 rows of data it struggles. Major fail. We need thousands of lines of data points.
Too expensive
It's hilariously bad in PowerPoint. Absolutely garbage. Somewhat better in Excel.
Co pilot is too expensive.
The cia getting fat in the pants with this
Looks like this is waaay overhyped…
Let's use AI to do things I can do more quickly myself 😀
This Copilot is more like autopilot 😂
Wow this is actually very unimpressive
Bad not to be free
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.
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😂
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
This is horrible and I feel Microsoft is dead. Too expensive too
Hey VIDEO EDITOR HERE 📹
First comment ❤ I love you work man