Скачать или смотреть 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:   / pragmaticworks  
✔️Facebook:   / pragmaticworks  
✔️Instagram:   / pragmatic.w.  .
✔️LinkedIn:   / 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