Excel keeps releasing updates and these last few months are no exception, with tonnes of new functions, new formula capabilities, new commands, I go through all the new stuff and specify which release channels have access to which features in this video.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html
00:00 Introduction
00:17 TRANSLATE
00:43 Detect language
00:58 Write numbers as words
01:52 REGEXREPLACE
03:33 REGEXEXTRACT
03:46 REGEXTEST
04:16 REGEX in XLOOKUP/XMATCH
04:43 Link to this range
04:58 Python in Excel
06:30 Format stale values
07:13 Forms integration
08:11 TRIMRANGE
08:46 . dot operator in formulas
09:29 GROUPBY
10:37 PIVOTBY
11:15 PERCENTOF
11:36 Check performance
12:07 Focus cell
12:21 Filter comments
12:41 Checkbox
13:03 Navigation pane
13:33 Picture inside cells
15:09 Get data from web with AI
16:37 Insert pic from Android
16:58 Beta: 100 DAX functions
17:27 Recc PivotTables
17:41 Dark Mode
18:11 Toggle formula compatibiliyt
18:38 Versions/channels explained