We're halfway through the decade (yes, its flying by), and Excel has released over 100 new features ranging across formulas, analytics, AI, collaboration, speed up, productivity and more. Check out my top 25 new things! I bet you didn't know them all!
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html
00:00 Introduction
00:23 Autocomplete dropdown
00:51 TRANSLATE*
01:28 Checkboxes*
02:04 UNIQUE
02:13 Dynamic arrays
02:40 GROUPBY*
03:35 Focus cell
03:51 Evaluate formula
04:25 Ctrl Shift V paste values
04:31 Show changes
05:02 Check performance*
05:49 VSTACK
06:22 REGEXTRACT*
06:43 Copilot (paid & free)
08:14 XLOOKUP
09:20 TEXTBEFORE
09:40 TEXTSPLIT
10:01 Image in cell*
10:35 Python*
10:50 QR code generator template*
11:20 Link to a range*
11:38 Data from picture
12:35 Currency data type & auto refresh
13:21 STOCKHISTORY
14:10 Navigation pane*
14:38 Unhide multiple sheets
14:52 Which Excel versions have new features
15:47 Wrap up