Our Black Friday Sale is here! 🎉 link.xelplus.com/yt-bf-savings 👉 Grab exclusive discounts today. Master data analysis, Excel, Power BI, and more... This offer won’t last long-don’t miss it!
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!
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 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!
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.
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! 🙂
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. 🤔
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!
Leila, you’re the ultimate Excel Queen! 👑 This video blew my mind 🤯 with how effortlessly you explained Copilot’s new features and their real-world applications. Your passion and clarity make learning Excel feel like unlocking a superpower. 💡✨ You don’t just teach Excel-you inspire creativity, innovation, and excitement with every video. 🎉 Thank you for being the guiding light for Excel enthusiasts everywhere 🌟 and for always staying ahead with your incredible content. We’re so lucky to have an Excel Evangelist like 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.
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 :)
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!
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?
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
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?
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
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.
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.
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.
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?
The secret is having the required excel skills to know how to give the prompts and how to understand whether the results are correct. This is an advantage for those who already are good at excel. It is not a replacement for the user but to enhance your efficiency.
@@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 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.
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. 🌮🌮💞
"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 ... 😍😍😍
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.
Without Excel spreadsheet knowledge AI n copilot can't help fully !!! Because they don't know whether it's a correct 💯 report or not !!! You can't send the report blindly to your boss !!! So learn excel deeper n feel the real power n magic of 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.
Cool feature on enhancing productivity.. however excel have it own set of limitations: limited data volume, increase in data low performance and generally most of the companies nowadays uses more tools for monitoring or working on data ...with AI volume of data increases drastically that excel can't handle - for small datasets it may work
Excel can actually analyze more data than it has rows for. You don't need to load your data into the grid. You can load it via Power Query and then summarize it. Or load it into a Python dataframe and analyze it in Excel.
Is there a way Copilot can be used to analyze results and trends, for example looking at a profit and loss and seeing if there are any jumps in revenue or expense lines? Also, can copilot assist with forecasting, for example using that profit and loss to forecast the lines out 6 months? Can we determine the methodology behind it such as use averages or trends in the modelling?
Yes. CoPilot with Python will give you any type of flexibility you need. Last weekend I tried forecasting using ARIMA, then exponential smoothing and adjusting based on extra assumptions and all worked really fast and really well :) Will aim to make a video about that. It's really cool stuff.
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?
Mostly these are alternatives to existing Excel features. I wonder when they will introduce something new similar as Py in Excel, PQ and Dynamic Arrays.
Our Black Friday Sale is here! 🎉 link.xelplus.com/yt-bf-savings
👉 Grab exclusive discounts today. Master data analysis, Excel, Power BI, and more...
This offer won’t last long-don’t miss it!
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.
Hi Leila!
I loved the Copilot's capability to insert a new formula column on its own understanding of data columns.
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!
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 appreciate your video on using Copilot for Excel. It would be great to see more training or videos using Copilot. Thanks
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 ❤
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!
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.
Thank you, Leila! I've truly learned so much from your UA-cam channel and website.
Very happy to hear that! Thanks for dropping by.
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!
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. 🤔
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!
Leila, you’re the ultimate Excel Queen! 👑 This video blew my mind 🤯 with how effortlessly you explained Copilot’s new features and their real-world applications. Your passion and clarity make learning Excel feel like unlocking a superpower. 💡✨ You don’t just teach Excel-you inspire creativity, innovation, and excitement with every video. 🎉 Thank you for being the guiding light for Excel enthusiasts everywhere 🌟 and for always staying ahead with your incredible content. We’re so lucky to have an Excel Evangelist like you! 🙌📊
Thanks!!! Excel is getting so exciting, this may be because of my evolving role at work. !! Cheers!
Great to hear! And great job!
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.
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 :)
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)
This is great , can we another video with additional functions which copilot can do may be advance functions
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
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 🎁
Thanks Leila - could a topic for your next video showcase Copilots ability to help us with modelling? Say either revenue forecasts expenses?
I will always be there to watch your tutorials, thanks for always sharing
Appreciate that.
You got a subscription! Thank you for the clarity too 🙂
Super Laila - as always
Thanks for sharing! That’s great.
Absolutely amazing!!!
Thank you for this and all your videos they’re very informative
Great one Leila, glad to finally see you do a video on Copilot. I feel less alone in my journey 🤣
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?
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!
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.
That's a very good feature that make our life easier !
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
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 😊
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?
I must add I really thank you for what you do.
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.
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.
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! 😺🥰⭐️💎
Wow, nice! I believe this may affect the data analysis job market.
Great to learn the latest updates. Thank you Leila.
You're welcome. Thanks for dropping by.
Thank you for the lovely introduction
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.
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.
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?
loving to see the actions by Copilot.
This is excellent information as always thank you very much!
Our pleasure!
LG never disappoints
The secret is having the required excel skills to know how to give the prompts and how to understand whether the results are correct. This is an advantage for those who already are good at excel. It is not a replacement for the user but to enhance your efficiency.
That looks amazing 🤩 going to save so much time 👍
The xlook up was impressive.
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 like it.. just need to figure out how to do this for the data I am currently working with.
Yes, Copilot is really amazing. Why must autosave compulsory?
So you can reverse and foul ups easily.
I am excited to see lookup feature of copilot. Simple text command and Bingo. No need to remember formulas.
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...
Sensei Leila has done it again!
Very cool Leila! Excel is so amazing
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.
This is really an exciting development.
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.
Summarize reviews was impressive
I thought so too!
Loved the throwback to Breaking Bad! 😅 And copilot is getting so good that even Gus Fring will approve!
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. 🌮🌮💞
"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 ☺☺☺
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?
Thank you, on which version of Excel is this available?
Am I the only one who is freaked out by the amount of sensitive data that OpenAI and Microsoft get?
Copilot can keep everything closed off to your organization so your data is not ingested and leveraged
@@lorraineioannoubut they use it for teching data models. Which means that it will be used in one way or the another?
It looks amazing. Thanks for sharing
My pleasure 😊
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.
It really looks like a fantastic tool...
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
Can you explain about SharePoint please
Nice everyday new feature are getting added in copilot. Pls share the sample files
Hi Leila ToP trainer!! Pretty please, other and more videos like that are really appreciated
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?
Great video thank you. Is copilot only available in office 360? I have office 2021 pro
Yes you need the office 365 subscription. Additionally, you need a co-pilot pro license.
@@takashihada1 ty!
Without Excel spreadsheet knowledge AI n copilot can't help fully !!! Because they don't know whether it's a correct 💯 report or not !!! You can't send the report blindly to your boss !!! So learn excel deeper n feel the real power n magic of Excel ❤❤❤❤
Simply amazing :):)
Great Thank you for your insights
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.
Cool feature on enhancing productivity.. however excel have it own set of limitations: limited data volume, increase in data low performance and generally most of the companies nowadays uses more tools for monitoring or working on data ...with AI volume of data increases drastically that excel can't handle - for small datasets it may work
Excel can actually analyze more data than it has rows for. You don't need to load your data into the grid. You can load it via Power Query and then summarize it. Or load it into a Python dataframe and analyze it in Excel.
@LeilaGharani Thank You! for responding ✨️
It’s amazing, thank u
Copilot license? I don’t know if my organization does, and i personally sub to 365. I need another subscription to Copilot?!?
Is there a way Copilot can be used to analyze results and trends, for example looking at a profit and loss and seeing if there are any jumps in revenue or expense lines? Also, can copilot assist with forecasting, for example using that profit and loss to forecast the lines out 6 months? Can we determine the methodology behind it such as use averages or trends in the modelling?
Yes. CoPilot with Python will give you any type of flexibility you need. Last weekend I tried forecasting using ARIMA, then exponential smoothing and adjusting based on extra assumptions and all worked really fast and really well :) Will aim to make a video about that. It's really cool stuff.
@@LeilaGharani Yes please. Your videos are always informative and I'm trying to discover all things Copilot. Thanks 🙂
The feature that would excite me the most is the one where Google gets Gemini to do the same in Sheets 😅
Is this included with a 365 subscription or does this require a separate copilot license
the formula, the lookup, and the insight. when this update will roll out?
It's already rolled out to the public. Just check how often you get updates and make sure you're on the latest.
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?
Can you use Co-Pilot as a Help Function?
Thanks!
Question. Is this data saved to microsoft databases in the cloud via Copilot?
I'm doing your course learning vba... Am I wasting my time because this can do things for me?
it's never a waste of time. We need to understand what the code does. I'm learning Python and AI can do that too. That doesn't stop me :)
You are the best
Thank you
Mind blowing
I've MS 365 but do i need to take Co-pilot licence seperately?
Great, thanks
Mostly these are alternatives to existing Excel features. I wonder when they will introduce something new similar as Py in Excel, PQ and Dynamic Arrays.