Ready to learn more? Join 400,000+ professionals in our courses 👉 link.xelplus.com/yt-d-all-courses 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!
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!
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.
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
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.
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!
these capabilities are really fantastic but I really like using conditional formating and have done some amazing things with it but this certainly seems to take the PAIN out of figuring it out. I look forward to using this once I can convince my work to get on board with it with my work account!
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 :)
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.
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!
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.
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)
"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 ... 😍😍😍
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.
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! 🙂
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?
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!
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?
I get that co-pilot can do the normal humdrum formula and formatting tasks. But what would have been really impressive is if from your first example, you could have the sheet auto generate summaries of the reviews, and use the results in a chart for example. So imagine everyday you paste in a new collection of reviews, if the sheet could automatically use AI to read the reviews, and update a chart showing trend lines, like we are doing worse, or we are getting better, so AI running IN the sheet, that would have been impressive, instead of copilot basically just giving you code snippets.
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
@@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.
Can I use this to validate data in excel? For example: Can I take data from two applications that have the information and would like to know if it matches? If it doesn't match show the discrepancy.
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 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'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.
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.
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!
As long as all of the inputs were there, could this give you how much money you could save by increasing your inventory turns by a number that you tell it?
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...
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
I do hope that eventually the prompts are more readily available in Copilot for just click and execute rather than having to type out all of the prompts.
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.
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
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?
This is great Leila, but have a question for you. Do you know if Co-Pilot or any other AI app that can gather data from different excel files and summarize them in another file without having to manually put links into the summary file for each cell? If there is something like this, this could literally save me hundreds of hours having to create links from various excel files into a summary excel file.
Ready to learn more? Join 400,000+ professionals in our courses 👉 link.xelplus.com/yt-d-all-courses
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
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. 🤔
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!
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.
Thanks!
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!
Loved the throwback to Breaking Bad! 😅 And copilot is getting so good that even Gus Fring will approve!
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.
Thank you, Leila! I've truly learned so much from your RUclips channel and website.
Very happy to hear that! Thanks for dropping by.
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.
You got a subscription! Thank you for the clarity too 🙂
Great one Leila, glad to finally see you do a video on Copilot. I feel less alone in my journey 🤣
these capabilities are really fantastic but I really like using conditional formating and have done some amazing things with it but this certainly seems to take the PAIN out of figuring it out. I look forward to using this once I can convince my work to get on board with it with my work account!
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 :)
This is great, no need to stress to much. We just need to make sure we give the correct info
Thanks!!! Excel is getting so exciting, this may be because of my evolving role at work. !! Cheers!
Great to hear! And great job!
I will always be there to watch your tutorials, thanks for always sharing
Appreciate that.
Wow, what a great tool Copilot is. Thanks for the easy explanation
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 ❤
This is an awesome feature, but you are "Awesomer" for breaking it down to easily understand it!😁
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.
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 must add I really thank you for what you do.
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.
Thanks Leila - could a topic for your next video showcase Copilots ability to help us with modelling? Say either revenue forecasts expenses?
This is great , can we another video with additional functions which copilot can do may be advance functions
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)
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.
"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 ☺☺☺
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.
That looks amazing 🤩 going to save so much time 👍
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!
Great to learn the latest updates. Thank you Leila.
You're welcome. Thanks for dropping by.
That's a very good feature that make our life easier !
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?
Sensei Leila has done it again!
Thank you for the lovely introduction
Great. Thanks a lot for the clear explanation. I am new... Yet to explore copilot but I am using chat GPT.
Super Laila - as always
Thanks for sharing! That’s great.
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!
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?
Wow!!! Game changing collaboration.
I get that co-pilot can do the normal humdrum formula and formatting tasks. But what would have been really impressive is if from your first example, you could have the sheet auto generate summaries of the reviews, and use the results in a chart for example. So imagine everyday you paste in a new collection of reviews, if the sheet could automatically use AI to read the reviews, and update a chart showing trend lines, like we are doing worse, or we are getting better, so AI running IN the sheet, that would have been impressive, instead of copilot basically just giving you code snippets.
Wow, nice! I believe this may affect the data analysis job market.
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
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.
I am excited to see lookup feature of copilot. Simple text command and Bingo. No need to remember formulas.
The xlook up was impressive.
Another masterclass post from Leila. This is super cool
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.
Thank God for AI in a world of want, want, want, companies requiring more of you and your time.
Absolutely brilliant. Thanks for this
Can I use this to validate data in excel? For example: Can I take data from two applications that have the information and would like to know if it matches? If it doesn't match show the discrepancy.
loving to see the actions by Copilot.
Absolutely amazing!!!
Thank you for this and all your videos they’re very informative
I like it.. just need to figure out how to do this for the data I am currently working with.
Simply amazing :):)
This really is awesome!
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! 😺🥰⭐️💎
I tried it it's amazing
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's amazing how much we trust this process without statistical analysis of the output.
Then you can’t comprehend AI😂
Very cool Leila! Excel is so amazing
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.
Awesome. Thanks for sharing valuable content!
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.
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
I'd like copilot to use a data table to create an interactive dashboard for productivity with charts and stuff.... like a report for the day or month.
love it, thank you.
if Gus Fring sees you made his data public your'e gonna end up with a bell in an old folks home :)
😁
LG never disappoints
Nice video. Do you have to purchase a seperate copilot license besides the 365 license.
Gus is watching!
This is excellent information as always thank you very much!
Our pleasure!
How is the free version different from the paid subscription? Great video!
Lovely Content.
As long as all of the inputs were there, could this give you how much money you could save by increasing your inventory turns by a number that you tell it?
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...
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
This is really an exciting development.
It looks amazing. Thanks for sharing
My pleasure 😊
Summarize reviews was impressive
I thought so too!
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
I do hope that eventually the prompts are more readily available in Copilot for just click and execute rather than having to type out all of the prompts.
It's excellent and very useful for me. Unfortunately, I can't afford to buy the Copilot Pro.
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 🎁
It’s amazing, thank u
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.
Great Thank you for your insights
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.
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?
This is great Leila, but have a question for you. Do you know if Co-Pilot or any other AI app that can gather data from different excel files and summarize them in another file without having to manually put links into the summary file for each cell? If there is something like this, this could literally save me hundreds of hours having to create links from various excel files into a summary excel file.
Hi Leila ToP trainer!! Pretty please, other and more videos like that are really appreciated
It really looks like a fantastic tool...
Mind blowing
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?