Microsoft Forms HIDDEN feature. Data, Formulas and Charts update LIVE in EXCEL

Tired of having to sign in to Microsoft Forms to see responses or having to keep downloading the Excel workbook to have the most recent data? In this tutorial you learn how data from Form submissions will update live in your Excel workbook and simultaneously update update formulas and charts.
0:00 Intro
2:05 Replicating the problem
6:01 Creating a Form based on an Excel Workbook
8:16 Submitting forms and collecting data
9:45 Seeing data updated automatically in Excel online
10:25 Opening the Excel workbook from Desktop version of excel
10:42 Adding formulas and charts to the Excel workbook which will update automatically when a form is submitted
13:41 Submitting a form and seeing data, formulas and charts updated automatically


Link to Excel tutorials playlist:
   • Spreadsheets (Excel) IGCSE 0417 ICT