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: https://www.youtube.com/playlist?list=PLWeerq9oa1ndM1kKGiwe4uM_npzPtC6M8