Introduction
Expanding your Excel skills with Power Platform
()
What to know before starting this course
()
1. Introduction to the Power Platform
Overview of Power Platform components
()
Setting up Power Platform tools for Excel integration
()
Transforming data management with the Dataverse
()
2. Automating Tasks with Power Automate
Power Automate's role in the Power Platform for Excel
()
Tracking Teams mentions with Power Automate and Excel
()
Refining outputs with additional steps and Power Fx
()
Office Scripts, Power Automate, and the Power Platform
()
Scheduling Office Scripts with Power Automate
()
Challenge: Set up a flow in Power Automate for Excel
()
Solution: Set up a flow in Power Automate for Excel
()
3. Building Custom Apps with Power Apps
Creating a simple Power App from an Excel data source
()
Customizing your app interface
()
Deploying your Power App
()
Challenge: Build a basic Power App for Excel data entry
()
Solution: Build a basic Power App for Excel data entry
()
4. Visualizing Data with Power BI
Importing Excel data into Power BI
()
Importing a Power Pivot data model into Power BI
()
Creating interactive dashboards
()
Challenge: Create a Power BI dashboard from Excel data
()
Solution: Create a Power BI dashboard from Excel data
()
5. Building Intelligent Chatbots with Power Virtual Agents
Exploring intelligent chatbots with Power Virtual Agents
()
Creating a simple chatbot to assist with Excel queries
()
Integrating the chatbot with Teams
()
Challenge: Creating an Excel keyboard shortcut chatbot
()
Solution: Create a chatbot to answer Excel FAQs
()
6. Governance, Security, and the Citizen Developer in Power Platform
Governance and security in the Power Platform
()
Becoming a citizen developer
()
Conclusion
Beyond the basics: Next steps with Power Platform with Excel
()
Ex_Files_Learning_Power_Platform_Excel_Integration.zip
(19.3 MB)