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