Excel & Office 365's new features: Summer 24 semi-annual update

Microsoft 365 releases new updates each month, but the semi annual channel gets 6m worth of updates in a moment, this session's updates includes: Excel: Evaluate formulas on hover, convert pictures of a table into an Excel table, dropdown autocomplete, use dynamic arrays for charts. Word & OneNote: transcribe audio and lined backgrounds PowerPoint: Teleprompter autoscroll and put yourself inside the slides. 00:00 Introduction 00:16 Evaluate on hover 00:59 Dynamic arrays in charts 02:57 Insert Power BI table in Excel 03:39 Get data from picture 04:00 Bonus tip: Win shift S 05:45 Bonus tip: US to Euro date format 06:31 Dropdown autocomplete 09:03 Bonus: TEXTSPLIT function 10:32 Bonus: Grouping 11:04 PowerPoint teleprompter scroll 12:07 7. Cameo enhancements 14:07 Present PPT file in Teams 14:34 Word lined backgrounds 15:22 Transcribe in Word & OneNote