What if I told you that you could build a smartphone app (iOS and Android) that could read and write data from Excel…without writing code?
That is exactly what PowerApps does. Not only Excel but SQL Server, Sharepoint and a host of other platforms. For this lesson, we’re sticking to Excel. You will learn how to navigate the PowerApps interface, how to design smartphone and tablet applications and get your hands dirty with the PowerApps formula language. Don’t worry, if you can write an Excel formula, you can write a PowerApps formula.
You will also learn:
- How to get Power Apps
- How to Connect to Excel
- Reading Excel Data
- Writing to Excel
- Using the phone GPS with Excel
- Using Google Maps with Excel
Everything in the lesson is written in a step-by-step fashion with plenty of images to guide you. PowerApps is the skill that will make you the definitive office guru.IMPORTANT NOTE:In order to use PowerApps, you will need a work email. Work email means an email that is not from a public company like Google, Yahoo, etc.