Microsoft Excel Q&A with New Copilot in Excel Tools

Learn about Microsoft Excel in this Q&A featuring new Excel and Copilot Tools. This is a recap of all questions asked during the live Excel Beginner to Pro Learn with the Nerds Free Course. Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan:https://prag.works/lwtn-trial 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.w... ✔️LinkedIn: https://www.linkedin.com/company/prag... Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #excel #PragmaticWorks #Allisongonzalez #Training #Microsoft #Tech #learnwiththenerds #copilot **Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only. 00:00 Introduction and Overview 02:22 Elaborate on the difference between XLOOKUP vs VLOOKUP vs INDEX & MATCH? 05:17 How can you bring data from other places and use it in your report? 09:25 If you choose the wrong option when you close Power Query, how do you change that? 11:02 Does Excel Power Query have the same data cleaning capabilities as Power BI? 15:05 Does Excel and Power BI share a common engine called Power Query? 15:40 Should I create a calendar in a separate query/table and define each year, quarter, and month? 19:38 Can the data sheets be hidden and locked with only the dashboard tab visible and maneuverable (with slicers)? 21:55 Power Apps Beginner to Pro Learn with the Nerds Announcement 22:44 How does ChatGPT and Excel work together? 24:52 Using Microsoft Copilot in Excel for Data Analysis 31:37 Closing