Connect with me: ☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie 🦉 Learn more about AI: aka.ms/learnwithlisa 🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/ 📼 TikTok: www.tiktok.com/@lisa.crosbie 🐦 X (Twitter): twitter.com/LisaCrosbie 📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/
You're amazing. One observation: mastering the art of crafting AI prompts for various scenarios is among the most valuable skills one can possess. I often found myself pausing the video repeatedly just to scrutinize your prompt entries closely. While it may seem trivial, it's truly one of the most beneficial skills to refine when utilizing this tool. Therefore, it would be greatly appreciated if you could place a bit more emphasis on displaying your prompts before proceeding further. Looking forward to more of your tutorials. Cheers
I have a serious case of "old" going on! I haven't used Excel for decades, but this will be very helpful. You have done an excellent job of explaining it. Thank you. My next step is learning this to help me perform correlations and convolutions. Any suggestions would be appreciated.
Thanks Lisa. Does it have functionality to analyse unstructured data that might be in a column? For example highlight themes in a list of complaints or customer questions? Or sentiment analysis?
When you rely on cloud based AI like copilot in the name of saving valuable time or avoiding burnout, you generally sacrifice an overall control over both data security and privacy and hosting providers , microsoft in this example, often use analytics and tracking mechanisms of your business data and that way they r always ahead of any innovative and prosperous projects of yours
Always helpful Lisa, thanks. As a side-rant, I can't understand why you, as a valuable member of the MS community, promoting and teaching the use of their tools, had to PAY for this feature to learn/have access to/teach it.
@@LisaCrosbie for sure. For data analysis, it presents a big problem, how to verify correctness in anything meaningful with lots of rows means checking it, and does checking it make the task longer.. tbd
Hi Lisa, does it allow users to record the steps/prompts and results generated by the copilot and save it as a macro for future use? Like a person has to do the same steps for some monthly reporting etc.
That isn’t part of Copilot for Excel but the new AI recording for desktop flows (Power Automate) just announced at Build would most likely be the right solution there.
@lisaCrosbie your content is awesome, thank you for sharing. I'd love to know if it's possible to do the following in excel? If I have multiple tabs, one of which is my master and contains questions in column A and model responses in column B can I use that as my baseline to fill out another tab where questions in column A may be worded differently but subject matter is broadly the same. Is that even possible?
Hmn, was watching this since my company is rolling out Copilot for users. This seems pretty useless, everything done by the copilot here I an experienced user could have done with 1 to 2 clicks. Is there any benefit for advanced excel users, can it do dynamic controls and slicers?
If you’re an experienced Excel user most of this stuff will be easy for you. This Copilot is most helpful for users who are less familiar with formulas and conditional formatting and pivot tables (which honestly is a lot of people!). Have a look at the Copilot with Python in Excel for more advanced stuff (I haven’t done a video on that yet).
You're right, it's definitely most benefit to users who need support with the basics - but there are a LOT of people who don't know how to create formulas, use conditional formatting, create pivot tables etc
Connect with me:
☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie
🦉 Learn more about AI: aka.ms/learnwithlisa
🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/
📼 TikTok: www.tiktok.com/@lisa.crosbie
🐦 X (Twitter): twitter.com/LisaCrosbie
📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/
Close 1:49 1:50 1:51 1:51 1:52 1:53 1:53
You're amazing. One observation: mastering the art of crafting AI prompts for various scenarios is among the most valuable skills one can possess. I often found myself pausing the video repeatedly just to scrutinize your prompt entries closely. While it may seem trivial, it's truly one of the most beneficial skills to refine when utilizing this tool. Therefore, it would be greatly appreciated if you could place a bit more emphasis on displaying your prompts before proceeding further. Looking forward to more of your tutorials. Cheers
thanks so much Lisa for this great video - exactly what I was looking for!
Nice explanation, Lisa! 👏👏👏
I have a serious case of "old" going on! I haven't used Excel for decades, but this will be very helpful. You have done an excellent job of explaining it. Thank you. My next step is learning this to help me perform correlations and convolutions. Any suggestions would be appreciated.
Awesome. Thanks Lisa!
Great video Lisa, thank you for sharing! By any chance can you make this spreadsheet available for download?
Love it, great work, really so helpful, keep at it, you’re helping so many people!
Lisa, you did a great job getting me started with Copilot in Excel. Do you have additional Copilot in Excel videos or plans for additional training?
Once it’s out of preview or when more features are added I will most likely do more on it, yes.
Thanks Lisa. Does it have functionality to analyse unstructured data that might be in a column? For example highlight themes in a list of complaints or customer questions? Or sentiment analysis?
When you rely on cloud based AI like copilot in the name of saving valuable time or avoiding burnout, you generally sacrifice an overall control over both data security and privacy and hosting providers , microsoft in this example, often use analytics and tracking mechanisms of your business data and that way they r always ahead of any innovative and prosperous projects of yours
excellent explanation, thank you!
Thanks for the tips!
This is AMAZING @LisaCrosbie thanks!
Always helpful Lisa, thanks. As a side-rant, I can't understand why you, as a valuable member of the MS community, promoting and teaching the use of their tools, had to PAY for this feature to learn/have access to/teach it.
Thanks - and yeah, don’t get me started on access to licenses, indeed!
Can you share tips to do cloud words in excel using copilot tool?
That's not something Copilot in Excel can do at this stage.
thank you, awesome video.
can I trust the data it presents? if it's not a calculation
With anything AI you should always check the references and results, I would never 100% take what AI gives me without checking.
@@LisaCrosbie for sure. For data analysis, it presents a big problem, how to verify correctness in anything meaningful with lots of rows means checking it, and does checking it make the task longer.. tbd
Can it tell me how many duplicate entries are there in the table and which are those?
Game Changer :D
Hi Lisa, does it allow users to record the steps/prompts and results generated by the copilot and save it as a macro for future use? Like a person has to do the same steps for some monthly reporting etc.
That isn’t part of Copilot for Excel but the new AI recording for desktop flows (Power Automate) just announced at Build would most likely be the right solution there.
Can I use multiple prompts at one time? Will that give multiple pieces of content and analysis in one go?
I think in 6 months it will be a game changer but at the moment like everything else it gets better with time.
You’re right, it’s still early days.
@lisaCrosbie your content is awesome, thank you for sharing.
I'd love to know if it's possible to do the following in excel? If I have multiple tabs, one of which is my master and contains questions in column A and model responses in column B can I use that as my baseline to fill out another tab where questions in column A may be worded differently but subject matter is broadly the same. Is that even possible?
Hmn, was watching this since my company is rolling out Copilot for users. This seems pretty useless, everything done by the copilot here I an experienced user could have done with 1 to 2 clicks. Is there any benefit for advanced excel users, can it do dynamic controls and slicers?
If you’re an experienced Excel user most of this stuff will be easy for you. This Copilot is most helpful for users who are less familiar with formulas and conditional formatting and pivot tables (which honestly is a lot of people!). Have a look at the Copilot with Python in Excel for more advanced stuff (I haven’t done a video on that yet).
I cannot use Copilot in the app for Excel like I can for Word and powerpoint. I can only utilise Excel on the browser. Help?
Try going into the file menu, then choose account, and you will see an option to “update license”. Then restart Excel.
@@LisaCrosbie sadly, I can't see “account” in the file drop-down menu… 😔 do I have to do that on the browser version of Excel?
how to get copilot in excel?
You need to buy a Copilot Pro or Copilot for Microsoft 365 License.
This is all fairly basic work. More useful for a beginner in excel.
You're right, it's definitely most benefit to users who need support with the basics - but there are a LOT of people who don't know how to create formulas, use conditional formatting, create pivot tables etc
Great explanation thank you so much!