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 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
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?
@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?
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
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.
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