Course Overview

Learn how to connect Excel and Power Apps to create data-driven business applications.

Course Circullum

Introduction

Create data-driven apps with Power Apps and Excel
Link O365 tools in new ways

1. Get Started

Excel setup: Named tables
Store files in an accessible location
Connect Power Apps to data
Your first app: Default from existing data
Browse screen, edit screen, detail screen
Save and other app settings
Refresh the data source

2. Change Design and Styling

Resize the app for the default viewer
Correct design layout issues
Fix data field auto layout on the Browse screen
Correct data field auto layout of the Edit and Display screens
Change form colors in Power Apps
Change and resize fonts in Power Apps
Add images in Power Apps

3. Add Functionality

Add dropdown fields
Add radio buttons
Conditional formatting
Validate entries
Auto-populate information in fields

4. Create More Complex Solutions

Link multiple data sources
Using Galleries
Add a chart
Add image fields for input
Create apps and collections from scratch
Using Power Apps templates

5. Sharing Your App

Share via a shared cloud service
Using the app on a mobile device
Export and import app packages

Conclusion

Extend your Power App and Excel skills

Phil Gold

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: