From the course: Power Apps: Building Data-Driven Apps with Excel

Getting the most from this course

From the course: Power Apps: Building Data-Driven Apps with Excel

Start my 1-month free trial Buy for my team

Getting the most from this course

“

- [Instructor] So who's going to be able to benefit from the techniques we'll talk about in the course? Well, the big focus of this course is using Power Apps as a front end to provide an easy, user-friendly way of capturing data that can be manipulated in Excel. So naturally, the ones who will be the most rewarded are the people responsible for collecting and analyzing that data. But with improved data integrity, a simpler input experience, and mobile capabilities, really anyone who touches the data is going to get some benefits. As far as this course goes, the first step you'll want to do is to check that you have Power Apps. You should be able to see it listed in your Microsoft 365 apps but you might have to click the All Apps link to see it. If it's not listed, you'll need to speak to your office administrator. They may have chosen not to enable it for your company. Now, although Excel Online in Microsoft 365 is pretty impressive, it doesn't have all of the features of the desktop application. If you decide you want to use the desktop app, you'll need to have it installed. Typically, when you first open an online office application in Desktop mode, you'll be prompted to download and install at that time if you don't already have it. Now, a word of warning, the download is very large and it can take hours on slower connections. So it's a really good idea to do this in advance. But this is also something that has some dependencies on your license and what features of Microsoft 365 your administrator has enabled. Once again, if you don't see an option to download the Office Desktop apps, you'll need to have a conversation with your admin. By the way, I just want to mention that Excel is not the only possible data source you can use with Power Apps. Power Apps has the ability to connect with a multitude of Microsoft and third-party databases. Some of the details will differ but in general the things we'll look at in this class widely apply to other data sources as well. And just a little scope-setting. It probably won't surprise you to hear that Power Apps is a very feature-rich and multi-layered tool. Since I'm focusing on a specific purpose, using Power Apps as a front-end for data and predominantly Excel data at that, there are wide areas of the tool that we won't touch on. I think the information we'll be looking at is extremely useful but I make no claims that this course is comprehensive. If you want a deeper dive into Power Apps, there are some great courses in the online library. In particular, I want to point you to Gini von Courter's Learning Microsoft Power Apps and Bill Kulterman's Microsoft Power Apps Essential Training: Beyond The Basics.

Contents