Power Apps: Building Data-Driven Apps with Excel

1h 54mIntermediate2023-04-17

Authors

Phil Gold

Senior-Level Learning and Development Professional

Course details

Microsoft Power Apps is now part of the Office 365 suite, and can be used in conjunction with other Office applications, such as Excel, to create business applications without knowing any code. In this course, Phil Gold explores how to use Power Apps and Excel to create data-rich business applications for the collection, dissemination, and visual display of data. Phil walks through the basics of connecting data-sources in Power Apps, and shows you how to build a business application using the data-power of Excel, including how to deploy that application to your organization.

Skills covered

Power AppsBusiness IntelligenceSpreadsheetsMicrosoft ExcelData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Creating apps from data you already have
02 - Getting the most from this course

1. Getting Started

03 - Setting up named tables in Excel
04 - Storing your worksheet in an accessible place
05 - Connecting Power Apps to your worksheet
06 - Understanding your default app
07 - Understanding the different app screens
08 - Saving and publishing the app
09 - Refreshing the data source after changes

2. Changing Design and Styling

10 - Changing the app layout for a different device
11 - Adjusting data on the Browse screen
12 - Fixing the display on the Edit screen
13 - Changing and resizing screen fonts
14 - Changing form colors
15 - Fine-tuning layout for the Edit form

3. Adding Functionality

16 - Adding drop-down fields
17 - Adding radio buttons
18 - Adding conditional formatting
19 - Adding field validation
20 - Autopopulating field values

4. Creating More Complex Solutions

21 - Linking multiple data sources
22 - Creating a new Canvas app
23 - Adding a Detail screen to the new app
24 - Adding a chart
25 - Adding image fields for data
26 - Creating apps and collections from scratch
27 - Using Power Apps templates

5. Sharing Your App

28 - Sharing via a shared cloud service
29 - Using the app on a mobile device
30 - Exporting and importing app packages

Conclusion

31 - Extending your Power Apps skills