How to Make an App Using Your Excel Office 365 Data

In this episode of AppSheet Basics we cover how to create an app using your Excel Office 365 data in to an app on AppSheet!
► Documentation: help.appsheet....
► Free Beginner Udemy Course: www.udemy.com/...
► Our Services: qrewtech.com/s...
► Chrome Extension: chrome.google....
► Training App: ** COMING SOON **
Want to learn about other parts of AppSheet? Try our AppSheet Daily Dose playlist: • Dereferences - AppShee...

[@abiodunsotannde]

Good job. How do I add students scores in appsheet after we have typed students name and serial number in the sheet?

[@thomasedwardking7286]

Must try it. Thanks, Boss 😊

[@creativecompilations2662]

Awesome.

[@drfailbucket]

I got a big excel with many sheets that are sharing Data's throughout the book. Now in the past the user had to open the excel on phone and painfully enter the necessary information. I thogt maybe appsheet could provide a easy to use interface for this but i doubt that it can handel it with all the tables Is there a way to tell appsheet it have to use only one specific sheet to create an app from? So taht i wont load in all the 33 pages 😅

[@orlandolagos5441]

Thank you very much for this excellent video. Is there any way that I don't have to close my spreadsheet to update the data from the app? Greetings from Chile

[@mochimo93]

is there any ways to see the data changes from apps in excel office 365 in realtime, so I can monitor ppl that input the data via apps in my excel 365?

[@rksocial9354]

Unable to add additional sheet in app tab, sir

[@asprillahoulunai5847]

Hello mate, I was wondering, if I have a sheet with formulas (complete, I mean with running formulas on the sheet in excel), lets say formulas to calculate ingredients doses of a recipe given one of them, I will be able to insert different dose of the given ingredient and have the computation of the other done on the app? Hope that was clear ahahah cheers!

[@AppSheetTraining]

Yes you would be able to calculate that with either a Static or Virtual Column within AppSheet. However we suggest when having an Appsheet App connected to your data that you should use formulas on AppSheet side instead of in the sheet.

[@etudianttunisien6523]

where is the app ?

[@naimmed4121]

Please how to make a total of any amount at the end of the column

[@AppSheetTraining]

Check out the SUM() Function: kzbin.info/www/bejne/pnbchH6Mnq1les0

[@jorgeperea5095]

i have a macro enabled file, with a button to run it, will it work??

[@AppSheetTraining]

Your sheet should still function as normal. However, there’s not a way for AppSheet to “push” the button. You might look at a different relay to trigger your macro

[@199wildman]

Can this work with apple

[@AppSheetTraining]

AppSheet apps can run on iOS, Android and all modern web browsers

[@bradscrazylife4269]

Need for a football tournament. Get 100 players to put in there own picks

[@AppSheetTraining]

AppSheet charges per user, You could use a public app where they enter in picks and pair it with their email on the form. But honestly I would suggest checking out Bubble.io for this use case.