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.
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.
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. 🤔
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
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!
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!
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!
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?
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?
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.
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?
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.
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 :)
"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 ... 😍😍😍
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 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. 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)
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!
When I prompt ChatGPT with Excel files or copy and paste data directly into it and ask it to organise it, it sometimes encounters syntax errors. Restarting the process often leads to the same issue, creating a cycle without results. Can you suggest if Copilot can handle a large dataset and follow my instructions to organise it neatly? I need this table for making phone calls to prospects. Please advise on this. Additionally, could you guide me on how to add Copilot to the ribbon in Excel? Also, since I’m paying £20 per month for ChatGPT, is there a way to integrate it into my Excel ribbon for direct usage? Thank you for your help!
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. 🌮🌮💞
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! 😺🥰⭐️💎
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?
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.
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
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
In our line of work, we have to deal with with "fuzzy search". For example, when comparing to data set identifying companies. Unfortunately, the company names are often written differently ("Microsoft Inc.", "Microsoft Inc", "Microsoft Canada Inc.", "Microsoft Incorporated", etc). Would this approach allow us to identify the matches?
So, does it still only work if you are using OneDrive? Are most of the features only available if the data is formatted as a table? Both of those are deal killers
Hi Leila, Can you use co pilot to produce a dashboard? The company I work for has an excel spreadsheet each year that we record the quotations we have during a year. This is normally broken down by clients name, address including zip code, where they heard of our product, etc. I would like to be able to provide a dashboard showing things like % of projects went a head, demographic of projects to the country etc. Is this something that could be done.
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 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.
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! 🙂
I have two columns in sheet 1 say A & B. A has certain data and B is Blank, where I want my result. I also have Sheet 2 with data in two Columns, say C & D. Sheet 2 has account numbers in Column C and the names of persons against those account numnbers in Column D. Now in Sheet 1, in Column A there is account number along with other information. I want to enter the name of the account holder in Column B, if the account number in C is found within the Cell in A. Could you help please?
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.
May I ask your help for making a table for daily transactions. I wanna make the first row remain empty, because I want to use it as I add the new input of the day and it automatically add to the table list
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.
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.
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!
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!
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
Loved the throwback to Breaking Bad! 😅 And copilot is getting so good that even Gus Fring will approve!
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.
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! I've truly learned so much from your RUclips channel and website.
Very happy to hear that! Thanks for dropping by.
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!
It's amazing how much we trust this process without statistical analysis of the output.
You got a subscription! Thank you for the clarity too 🙂
This is an awesome feature, but you are "Awesomer" for breaking it down to easily understand it!😁
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 great , can we another video with additional functions which copilot can do may be advance functions
Thanks Leila - could a topic for your next video showcase Copilots ability to help us with modelling? Say either revenue forecasts expenses?
Absolutely brilliant. Thanks for this
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?
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 🎁
Great. Thanks a lot for the clear explanation. I am new... Yet to explore copilot but I am using chat GPT.
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 ❤
Wow!!! Game changing collaboration.
I will always be there to watch your tutorials, thanks for always sharing
Appreciate that.
Another masterclass post from Leila. This is super cool
How is the free version different from the paid subscription? Great 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?
Absolutely amazing!!!
Thank you for this and all your videos they’re very informative
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's a very good feature that make our life easier !
It's excellent and very useful for me. Unfortunately, I can't afford to buy the Copilot Pro.
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?
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 for the lovely introduction
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 :)
"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 ☺☺☺
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 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.
The explanation is great 👍😊
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)
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 😊
I must add I really thank you for what you do.
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
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?
Simply amazing :):)
When I prompt ChatGPT with Excel files or copy and paste data directly into it and ask it to organise it, it sometimes encounters syntax errors. Restarting the process often leads to the same issue, creating a cycle without results.
Can you suggest if Copilot can handle a large dataset and follow my instructions to organise it neatly? I need this table for making phone calls to prospects. Please advise on this.
Additionally, could you guide me on how to add Copilot to the ribbon in Excel? Also, since I’m paying £20 per month for ChatGPT, is there a way to integrate it into my Excel ribbon for direct usage?
Thank you for your help!
This is great, no need to stress to much. We just need to make sure we give the correct info
Awesome. Thanks for sharing valuable content!
That looks amazing 🤩 going to save so much time 👍
what is the difference between copilot and analze data feature?
loving to see the actions by Copilot.
Very cool Leila! Excel is so amazing
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. 🌮🌮💞
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! 😺🥰⭐️💎
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?
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.
I am excited to see lookup feature of copilot. Simple text command and Bingo. No need to remember formulas.
Great one Leila, glad to finally see you do a video on Copilot. I feel less alone in my journey 🤣
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.
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?
Wow, nice! I believe this may affect the data analysis job market.
I like it.. just need to figure out how to do this for the data I am currently working with.
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
Lovely Content.
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
Hi Leila ToP trainer!! Pretty please, other and more videos like that are really appreciated
Great to learn the latest updates. Thank you Leila.
You're welcome. Thanks for dropping by.
This is excellent information as always thank you very much!
Our pleasure!
I've MS 365 but do i need to take Co-pilot licence seperately?
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.
LG never disappoints
If I have a question about automate in excel, what is the best way to send you that?
In our line of work, we have to deal with with "fuzzy search". For example, when comparing to data set identifying companies. Unfortunately, the company names are often written differently ("Microsoft Inc.", "Microsoft Inc", "Microsoft Canada Inc.", "Microsoft Incorporated", etc). Would this approach allow us to identify the matches?
So, does it still only work if you are using OneDrive? Are most of the features only available if the data is formatted as a table? Both of those are deal killers
Thank you, on which version of Excel is this available?
Sensei Leila has done it again!
Question. Is this data saved to microsoft databases in the cloud via Copilot?
Hi Leila,
Can you use co pilot to produce a dashboard? The company I work for has an excel spreadsheet each year that we record the quotations we have during a year. This is normally broken down by clients name, address including zip code, where they heard of our product, etc. I would like to be able to provide a dashboard showing things like % of projects went a head, demographic of projects to the country etc. Is this something that could be done.
Yes, Copilot is really amazing. Why must autosave compulsory?
So you can reverse and foul ups easily.
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.
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.
Can Microsoft Excel's Copilot generate a new 'Sentiment' column that categorizes text data as positive, negative, or neutral based on a user prompt?
Is this included with a 365 subscription or does this require a separate copilot license
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!
It really looks like a fantastic tool...
The xlook up was impressive.
This is really an exciting development.
Nice everyday new feature are getting added in copilot. Pls share the sample files
I have two columns in sheet 1 say A & B. A has certain data and B is Blank, where I want my result. I also have Sheet 2 with data in two Columns, say C & D. Sheet 2 has account numbers in Column C and the names of persons against those account numnbers in Column D. Now in Sheet 1, in Column A there is account number along with other information. I want to enter the name of the account holder in Column B, if the account number in C is found within the Cell in A. Could you help please?
Can you use Co-Pilot as a Help Function?
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.
Thanks Leila
May I ask your help for making a table for daily transactions.
I wanna make the first row remain empty, because I want to use it as I add the new input of the day and it automatically add to the table list
Mind blowing
Can you explain about SharePoint please
You heard of Google?
It is not sure that using Copilot goes faster than filling the formula or the conditional formatting for an expert.
I am. Sure that it's not, and an expert.