Ready to learn more? Join 400,000+ professionals in our courses 👉 link.xelplus.com/yt-d-all-courses What do you think of these updates? Tools can help, but what you know makes the real difference.
Is this an insider feature, or is it available now? Normally you verify that, but I'm asking before I go looking for it, as it's not there yet. Thanks!
This is excellent for users who don't have a lot of experience with Excel. But thy would still have enough knowledge of Excel to know whether these formulas are any good. For me it usually takes longer to write the prompt than to write the formula.What I use Copilot for is writing code I'm not familiar with like Python or RegEx.
I have been working on a project using Python and RegEx to download PDFs, convert them to CSV files, and import them into Excel. After completing this step, I use Python to organize the data in Excel. Due to the disorganized and messy nature of the PDFs, Python and RegEx have been extremely helpful. I started with 200 PDFs (paycheck statements) and will now apply the same process to bank statements. Once I complete this process, I will use Copilot to add columns and calculate federal and state taxes.
These responses seem to be overly optimistic to me. When software is released which makes 1 person do 10 (or 100) jobs, 9 (or 99) are out of a job. (No formula needed for this math.) Some of those 9 people are going to be people who adapted and were very accepting of the change... and yet here we are. 🤔
I absolutely love these new Excel Copilot features Leila! They make data management so much easier and efficient. Thank you for sharing such valuable insights and tips. I can’t wait to try them out in my work and improve my skills even more!
The only issue is if using on a personal device you need a business sub, which I have, but then you need to upgrade that and it's £30 a month. In fairness, it covers all MS Office products which I use, but with all the subs I already pay, it will take it to over £250 a month going our for things I don't use every minute of every day.
Hi Leila Got to say I'm still using Excel 2021, but use (Edge) MS Copilot to write udf's that mimic some of the newer functions in 365, the created function/udf have to be check with care but allows me to work across different version of Excel - get a great deal of information from the videos. Also =formulatext can be very useful when placing calculation outside of the main spreadsheet Thanks Chris
Many thanks for insightful content. I think the usage of copilot in excel is quite useful for people who are not very confident in their skills with excel. I have used copilot extensively for outlook, MS word and MS Team and I think that is where it shines the most where lots of text data is used and lots of faff is anticipated from the end user/reader. In my opinion copilot in excel is somehow useful for beginners who intend to use the files once because for an excel guru, if they are going to be using the same exact file multiple times, then they would already format it in a way that standardizes approaches down the line. Copilot is so clueless in this case. Many thanks again for your awesome content as always. Keep up the good work :)
Kb 2 éve használom az OMV-ot mint NAS egy Raspberry Pi 4-el, 2 HDD van hozzá csatlakoztatva és elég jo írás/olvasás sebességeket ér el. Köszi a magyarázó videót!
Thank you Leila for yet another useful video. I have started exploring Copilot in Excel recently and this video is sure to help a lot! And yes, just an update that I have enrolled in your new Pivot Table course and it's already worth the price and time! Thanks again! 🙂
This is amazing and I look forward to trying these out. Did you come across instances where Copilot failed to produce the expected result or where the result was incorrect? Did you try to break things? I'd love to see those results also!
I would love to see more examples of how co-pilot can help in Excel. Perhaps a follow-up video that incorporates more examples from Leila as well as examples offered by viewers would be helpful!
OK, good one. What amazed me really is that I tried to work with Copilot to 'highlight errors in my data in orange color and font as black color', and it did that brilliantly well. Also giving me the function which did the job. But.. when I tried to highlight entire row for the rows containing highest value in 'Sale' column, it could not do it. Trying more amazing ways it can surprise me :)
Cool! A few weeks ago when I tried with "highlighting entire row based on cell value", I also noticed that Copilot had issues understanding that and most of the time it didn't work. But after the updates, it worked every time. It's getting better one update at a time.
I'm very happy to see Copilot finally being useful in Excel. I felt that being restricted to tables was very constraining. It was cool to see Copilot changing formulae to accomplish your requests. However, I did notice that it did not understand "light orange" or "light green" as you asked. My conclusion ... this is a huge leap for Copilot for Excel.
"Thursdays with Prof Leila" ... appointment viewing not to be missed ... (w/my morning ''Don't #Spill It" mug of black coffee). And once again, wonderful insights and suggestions. Thank you ... thank you ... thank you ... 😍😍😍
A little caution on using db lookup abilities - in this example, the assumption is that all roles are unique (as you did say), or put another way, that no departments have the same roles. However, if 2 departments had "Assistant Manager" roles as would be very likely, then in this case, there would be no way to choose the correct department based on the role. Wonderful tech, but it's important that the fundamentals are in place. For very simple cases like this, no worries. But for very large 'relational spreadsheets', caution must be applied (along with some database fundamentals). Cheers - Dave
Thank you Leila. To paraphrase the title of this video: You won't believe how interesting Excel's lessons can be! Can you recommend any books to become a more advanced data analyst? (sort of "analysis theory" with a special focus on business)
Excellent video. Quick question on the token limit impacts on large sheets with thousands of rows…For example, i have a survey result with 10k cells of unstructured texts. Would copilot error out?
Ehehehe, just got to make sure that one understands what one is asking excel’s copilot, i guess trial and error, seems that copilot is pretty advance and understands complicated Excel verbal instructions which is a plus, plus, excellent video, i’m pressed with the AI of Microsoft Excel, catch you on the next excel video! 😺🥰⭐️💎
Reminds me of contemporary HR practices…don’t look at all the data, just quick comb for what you want to find, leave all the gems that fall through to the floor to be swept up and trashed. Trust AI, because you can’t “waste” time.
I tried copilot for writing some office script in excel. My humble experience is Copilot seems to be inacurate or outside rhe topic in each try. I hope there will ve some improvements, for a future where excel with python inside and office scripts will ve a new level tool.
My experience is similar. Ot often points me in the right direction though , bit often its revised third attempt is the same as its first. It forgets what it did before.
Thank you, Leila, Is copilot only 365 excel? I like Copilot and I use it on my search engine and on word its Very helpful. Is it a add on? For Business Standard. 🌮🌮💞
Hi Leila, I really enjoyed your video-thanks for sharing such helpful tips! I'm using Windows 10 with Microsoft Office 365, and I'm trying to enable Copilot in Excel 365. Could you guide me through the steps or let me know if there's anything specific I need to do? Thanks again for all the great content!
Excellent video Leila!! Really good showcase of a few simple but impactful use cases! Is it possible to share the excel file you used in the video for people to try themselves on the sample data?
This might be good for categorising IT alarms from systems that have similar keywords in the short description of the alarm. I look forward to giving this a try.
Impressive, but my concern is that now everyone can become a 'data analyst', as defined by Microsoft. Clearly there are some wonderful benefits with this tech, but my caution is to make sure the fundamentals are not missed along the way. Making sure your analyses align with bigger picture objectives is essential for all businesses and so keeping this in mind as we apply these sorts of 'AI' driven facilities is important. Many thanks for a great overview! Cheers from Australia - Dave
Thanks for running through these examples of how Copilot works with Excel. It looks great. I have Copilot when I use MS Edge browser. How do I get the Copilot license?
It is “mind blowing”. Individually, a person has a lot of power to analyze data. Being someone responsible for making decisions they can do things without remembering all the functions in excel. However, when incorporating these spreadsheets into a process there would be concern that a new person taking on this spreadsheet understands its full context and functionality. As we get more and more complex we may inadvertently misinterpret the data presented. Not to sound negative, but a reminder to be careful how “cool” spreadsheets could become a source of misinformation.
Thank you for the great information! Love your content. Is there a way to change date format from, for example 11/4/2024 to 11/04/2024 (always show date as 2 digits) and preserve it, even when reopen the csv file?
Hi Laila, thanks for your insishts about Copilot fo Excel. Before to join as membership I wanto to know whether Copitlot can extract info form one file creating new files. Also whether Copilot can merge several Excel files in just one file. Thanks
This is truly amazing. Are there any constraints like number of tokens/prompts per day, month, year. Or constraints like the hardware of your computer if this is a stand-alone AI software. And what are the risks of hallucinations leading to small errors that become big errors?. I can't wait to give this a try when I can.
I face a unique situation. Basically i have 2 lists of invoices for a period. Each obtained from different source. Ideally both the tables should be the same. However, various types of differences occur in some of the invoice details. Need to point out the differences. Let's say Headers in each table are date, invoice no, supplier identification no, taxable amount, tax amount, total amount.
Thx for bringing these to our attention but not sure if any of these features is worth the subscription cost. In addition, how do we know the output of a task done by copilot is accurate when it is not based on an explicit formula?
@@LeilaGharani Thank you for the answer, I meant the version number of Excel: I have Microsoft® Excel® for Microsoft 365 MSO (version 2408 build 16.0.17928.20114) 64 bit. I'm asking because I'm not getting nearly as good a summary through Copilot on a similar list I created and suspect it's due to the Excel version.
This is basically everything that a person need from excel... but I am worried about my kids generation now... because they will be able to use excel with just a prompt... but now they won't know a struggle of learning something... from every corner or angel...
I would have to check with the car wash and the fast food chain if it's possible ;) joke aside. I didn't think it would be so helpful since the result people get is based on their copilot.
Ready to learn more? Join 400,000+ professionals in our courses 👉 link.xelplus.com/yt-d-all-courses
What do you think of these updates?
Tools can help, but what you know makes the real difference.
Can we do Copilot on paper 📜?? 😂 😁
@@LeilaGharani But How will I send flowers 🌹🌸 to two places simultaneously 🥺
Is this an insider feature, or is it available now? Normally you verify that, but I'm asking before I go looking for it, as it's not there yet. Thanks!
Hi Leila, Can you shere the excel file in order to follow the exercise? Thank you
Copilot does not come as a default with Office 365. It has to be purchased
This is excellent for users who don't have a lot of experience with Excel. But thy would still have enough knowledge of Excel to know whether these formulas are any good. For me it usually takes longer to write the prompt than to write the formula.What I use Copilot for is writing code I'm not familiar with like Python or RegEx.
I have been working on a project using Python and RegEx to download PDFs, convert them to CSV files, and import them into Excel. After completing this step, I use Python to organize the data in Excel. Due to the disorganized and messy nature of the PDFs, Python and RegEx have been extremely helpful. I started with 200 PDFs (paycheck statements) and will now apply the same process to bank statements. Once I complete this process, I will use Copilot to add columns and calculate federal and state taxes.
@@davestevens6399 Assuming you trust copilot not to make up data.
If I just send this summary to my manager, she will quickly find out that she doesn't need me at all anymore 😂
I rather be the guy that can use the AI and can keep a job; than the guy who won't use AI and gets replaced by it :D
Someone said the same thing about computers... and yet here you are. 🤔 Adapt and improve.
@@DailenGunter Yes, definitely. You need to add more value to the company than just forwarding a Copilot summary to your manager.
The issue is that, not everyone will ever learn to use it. @@DailenGunter
These responses seem to be overly optimistic to me.
When software is released which makes 1 person do 10 (or 100) jobs, 9 (or 99) are out of a job. (No formula needed for this math.)
Some of those 9 people are going to be people who adapted and were very accepting of the change... and yet here we are. 🤔
Thanks!
I absolutely love these new Excel Copilot features Leila! They make data management so much easier and efficient. Thank you for sharing such valuable insights and tips. I can’t wait to try them out in my work and improve my skills even more!
The only issue is if using on a personal device you need a business sub, which I have, but then you need to upgrade that and it's £30 a month. In fairness, it covers all MS Office products which I use, but with all the subs I already pay, it will take it to over £250 a month going our for things I don't use every minute of every day.
Hi Leila Got to say I'm still using Excel 2021, but use (Edge) MS Copilot to write udf's that mimic some of the newer functions in 365, the created function/udf have to be check with care but allows me to work across different version of Excel - get a great deal of information from the videos. Also =formulatext can be very useful when placing calculation outside of the main spreadsheet Thanks Chris
Hi Leila!
I loved the Copilot's capability to insert a new formula column on its own understanding of data columns.
I appreciate your video on using Copilot for Excel. It would be great to see more training or videos using Copilot. Thanks
Danke!
Thank you!
Many thanks for insightful content. I think the usage of copilot in excel is quite useful for people who are not very confident in their skills with excel.
I have used copilot extensively for outlook, MS word and MS Team and I think that is where it shines the most where lots of text data is used and lots of faff is anticipated from the end user/reader.
In my opinion copilot in excel is somehow useful for beginners who intend to use the files once because for an excel guru, if they are going to be using the same exact file multiple times, then they would already format it in a way that standardizes approaches down the line. Copilot is so clueless in this case.
Many thanks again for your awesome content as always. Keep up the good work :)
Hi Leila you have brought the most of my excited tutorial video. Please make a copilot full course for excel, waiting for that. Thanks !🌹
Great suggestion ❤
Thank you, Leila! I've truly learned so much from your RUclips channel and website.
Very happy to hear that! Thanks for dropping by.
Loved the throwback to Breaking Bad! 😅 And copilot is getting so good that even Gus Fring will approve!
Kb 2 éve használom az OMV-ot mint NAS egy Raspberry Pi 4-el, 2 HDD van hozzá csatlakoztatva és elég jo írás/olvasás sebességeket ér el. Köszi a magyarázó videót!
Thank you Leila for yet another useful video. I have started exploring Copilot in Excel recently and this video is sure to help a lot! And yes, just an update that I have enrolled in your new Pivot Table course and it's already worth the price and time! Thanks again! 🙂
Very cool! Thanks for the feedback on the Pivot Table course. You're a pro yourself!
Thanks!!! Excel is getting so exciting, this may be because of my evolving role at work. !! Cheers!
Great to hear! And great job!
This is an awesome feature, but you are "Awesomer" for breaking it down to easily understand it!😁
This is amazing and I look forward to trying these out. Did you come across instances where Copilot failed to produce the expected result or where the result was incorrect? Did you try to break things? I'd love to see those results also!
I would love to see more examples of how co-pilot can help in Excel. Perhaps a follow-up video that incorporates more examples from Leila as well as examples offered by viewers would be helpful!
Agree as I find Copilot aweful for Excel. Need advanced abilities.
Great. Thanks a lot for the clear explanation. I am new... Yet to explore copilot but I am using chat GPT.
Absolutely brilliant. Thanks for this
OK, good one.
What amazed me really is that I tried to work with Copilot to 'highlight errors in my data in orange color and font as black color', and it did that brilliantly well. Also giving me the function which did the job. But.. when I tried to highlight entire row for the rows containing highest value in 'Sale' column, it could not do it. Trying more amazing ways it can surprise me :)
Cool! A few weeks ago when I tried with "highlighting entire row based on cell value", I also noticed that Copilot had issues understanding that and most of the time it didn't work. But after the updates, it worked every time. It's getting better one update at a time.
You got a subscription! Thank you for the clarity too 🙂
Wow!!! Game changing collaboration.
I will always be there to watch your tutorials, thanks for always sharing
Appreciate that.
You are my mentor. I have provided various practical trainings on Excel, inspired by your videos.
That's great 🙌 Let's continue inspiring others.
@@LeilaGharani He should send you a gift 🎁
I'm very happy to see Copilot finally being useful in Excel. I felt that being restricted to tables was very constraining. It was cool to see Copilot changing formulae to accomplish your requests. However, I did notice that it did not understand "light orange" or "light green" as you asked. My conclusion ... this is a huge leap for Copilot for Excel.
Another masterclass post from Leila. This is super cool
"Thursdays with Prof Leila" ... appointment viewing not to be missed ... (w/my morning ''Don't #Spill It" mug of black coffee). And once again, wonderful insights and suggestions.
Thank you ... thank you ... thank you ... 😍😍😍
The perfect mug ☕. Loved the picture you sent! Thank you 😊
@@LeilaGharani ☺☺☺
A little caution on using db lookup abilities - in this example, the assumption is that all roles are unique (as you did say), or put another way, that no departments have the same roles. However, if 2 departments had "Assistant Manager" roles as would be very likely, then in this case, there would be no way to choose the correct department based on the role. Wonderful tech, but it's important that the fundamentals are in place. For very simple cases like this, no worries. But for very large 'relational spreadsheets', caution must be applied (along with some database fundamentals). Cheers - Dave
Thank you Leila. To paraphrase the title of this video: You won't believe how interesting Excel's lessons can be!
Can you recommend any books to become a more advanced data analyst? (sort of "analysis theory" with a special focus on business)
Wow, nice! I believe this may affect the data analysis job market.
That's a very good feature that make our life easier !
Absolutely amazing!!!
Thank you for this and all your videos they’re very informative
Thank you for the lovely introduction
I must add I really thank you for what you do.
Awesome. Thanks for sharing valuable content!
Excellent video. Quick question on the token limit impacts on large sheets with thousands of rows…For example, i have a survey result with 10k cells of unstructured texts. Would copilot error out?
Hi Leila your courses are awesome. Can we expect Python course from you in near future?
Python course for data analyst
I would love to make a course like that.
loving to see the actions by Copilot.
Thanks Leila! Could you please make a video exploring phyton in excel with Copilot?
Yes. I've been testing it and it blew my mind even more 😊
Ehehehe, just got to make sure that one understands what one is asking excel’s copilot, i guess trial and error, seems that copilot is pretty advance and understands complicated Excel verbal instructions which is a plus, plus, excellent video,
i’m pressed with the AI of Microsoft Excel, catch you on the next excel video! 😺🥰⭐️💎
Thanks Leila - could a topic for your next video showcase Copilots ability to help us with modelling? Say either revenue forecasts expenses?
The explanation is great 👍😊
Reminds me of contemporary HR practices…don’t look at all the data, just quick comb for what you want to find, leave all the gems that fall through to the floor to be swept up and trashed. Trust AI, because you can’t “waste” time.
Agree. It is very limited and far from insightful. Happy to pay for a subscription if it performed more than basic.
How is the free version different from the paid subscription? Great video!
This is great , can we another video with additional functions which copilot can do may be advance functions
Simply amazing :):)
I tried copilot for writing some office script in excel. My humble experience is Copilot seems to be inacurate or outside rhe topic in each try. I hope there will ve some improvements, for a future where excel with python inside and office scripts will ve a new level tool.
My experience is similar. Ot often points me in the right direction though , bit often its revised third attempt is the same as its first. It forgets what it did before.
Thank you, Leila, Is copilot only 365 excel? I like Copilot and I use it on my search engine and on word its Very helpful. Is it a add on? For Business Standard. 🌮🌮💞
very interesting, as usual. I don't use Copilot in my Office 365 yet, but I think this time may come sooner then I expected.
It's excellent and very useful for me. Unfortunately, I can't afford to buy the Copilot Pro.
Hi Leila ToP trainer!! Pretty please, other and more videos like that are really appreciated
Great one Leila, glad to finally see you do a video on Copilot. I feel less alone in my journey 🤣
This is great, no need to stress to much. We just need to make sure we give the correct info
This is excellent information as always thank you very much!
Our pleasure!
Hi Leila, I really enjoyed your video-thanks for sharing such helpful tips! I'm using Windows 10 with Microsoft Office 365, and I'm trying to enable Copilot in Excel 365. Could you guide me through the steps or let me know if there's anything specific I need to do? Thanks again for all the great content!
Same doubt
@@fabinravindran3684 You need to Buy Microsoft 365 copilot License which is 30 USD /Month as of now
Great to learn the latest updates. Thank you Leila.
You're welcome. Thanks for dropping by.
Excellent video Leila!! Really good showcase of a few simple but impactful use cases!
Is it possible to share the excel file you used in the video for people to try themselves on the sample data?
This might be good for categorising IT alarms from systems that have similar keywords in the short description of the alarm. I look forward to giving this a try.
It's amazing how much we trust this process without statistical analysis of the output.
Then you can’t comprehend AI😂
That looks amazing 🤩 going to save so much time 👍
Very cool Leila! Excel is so amazing
Impressive, but my concern is that now everyone can become a 'data analyst', as defined by Microsoft. Clearly there are some wonderful benefits with this tech, but my caution is to make sure the fundamentals are not missed along the way. Making sure your analyses align with bigger picture objectives is essential for all businesses and so keeping this in mind as we apply these sorts of 'AI' driven facilities is important. Many thanks for a great overview! Cheers from Australia - Dave
Thanks for your feedback, Dave! You're absolutely right-getting the fundamentals down is key to using these tools effectively and safely.
I am excited to see lookup feature of copilot. Simple text command and Bingo. No need to remember formulas.
Thanks for running through these examples of how Copilot works with Excel. It looks great. I have Copilot when I use MS Edge browser. How do I get the Copilot license?
I like it.. just need to figure out how to do this for the data I am currently working with.
This is really an exciting development.
It looks amazing. Thanks for sharing
My pleasure 😊
It is “mind blowing”. Individually, a person has a lot of power to analyze data. Being someone responsible for making decisions they can do things without remembering all the functions in excel. However, when incorporating these spreadsheets into a process there would be concern that a new person taking on this spreadsheet understands its full context and functionality. As we get more and more complex we may inadvertently misinterpret the data presented.
Not to sound negative, but a reminder to be careful how “cool” spreadsheets could become a source of misinformation.
The xlook up was impressive.
Lovely Content.
It really looks like a fantastic tool...
Summarize reviews was impressive
I thought so too!
Thank you for the great information! Love your content. Is there a way to change date format from, for example 11/4/2024 to 11/04/2024 (always show date as 2 digits) and preserve it, even when reopen the csv file?
Can you explain about SharePoint please
You heard of Google?
Sensei Leila has done it again!
Great Thank you for your insights
Super Laila - as always
Thanks for sharing! That’s great.
But can it AUTOMATE budget VS actual on a project?
Hi Laila, thanks for your insishts about Copilot fo Excel. Before to join as membership I wanto to know whether Copitlot can extract info form one file creating new files. Also whether Copilot can merge several Excel files in just one file. Thanks
LG never disappoints
This is truly amazing. Are there any constraints like number of tokens/prompts per day, month, year. Or constraints like the hardware of your computer if this is a stand-alone AI software. And what are the risks of hallucinations leading to small errors that become big errors?. I can't wait to give this a try when I can.
No token restrictions but it is a monthly payment. Yes there is a risk that responses aren’t correct. You will have to double-check results.
Yes, Copilot is really amazing. Why must autosave compulsory?
So you can reverse and foul ups easily.
Mind blowing
I face a unique situation. Basically i have 2 lists of invoices for a period. Each obtained from different source. Ideally both the tables should be the same. However, various types of differences occur in some of the invoice details. Need to point out the differences. Let's say Headers in each table are date, invoice no, supplier identification no, taxable amount, tax amount, total amount.
Can it also perform sentiment analysis on the free text? Either group comments by high or low sentiment and pick out topics by sentiment score?
Thx for bringing these to our attention but not sure if any of these features is worth the subscription cost. In addition, how do we know the output of a task done by copilot is accurate when it is not based on an explicit formula?
what is the difference between copilot and analze data feature?
great video! please tell me, which version of copilot and excel you are using in this video?
I'm using Microsoft 365 and Copilot Pro.
@@LeilaGharani Thank you for the answer, I meant the version number of Excel:
I have Microsoft® Excel® for Microsoft 365 MSO (version 2408 build 16.0.17928.20114) 64 bit.
I'm asking because I'm not getting nearly as good a summary through Copilot on a similar list I created and suspect it's due to the Excel version.
This is basically everything that a person need from excel... but I am worried about my kids generation now... because they will be able to use excel with just a prompt... but now they won't know a struggle of learning something... from every corner or angel...
Nice everyday new feature are getting added in copilot. Pls share the sample files
Thank you, on which version of Excel is this available?
It’s amazing, thank u
Thanks Leila
3:38 cell A7 Gustavo Fring? LOL! Data from Hermanos Pollos?
Can you use Co-Pilot as a Help Function?
Hi. Any chance you can share the data that you used in this demo?
I would have to check with the car wash and the fast food chain if it's possible ;)
joke aside. I didn't think it would be so helpful since the result people get is based on their copilot.
This is great, we can finally stop watching all those excel tutorial yt vids guys!
except they're just too fun to not watch 😏
@@LeilaGharani stop the cap