Excel Tips: 7 of the latest Excel updates

Excel continues to be regularly updated and improved. Here are seven recent updates and how they can be utilised.

0:00 Welcome
00:33 TRIMRANGE functionality for flexible range references
02:06 Standard range reference
02:40 The new TRIMRANGE range syntax uses a full stop with the colon separator
04:14 A range with a flexible start cell and a fixed end cell
04:39 A fixed starting cell and a flexible ending cell
06:44 A new function called TRANSLATE
08:46 PivotTables reports now use the format from the data value column
10:31 Two functions BYROW and BYCOL have a simplified syntax
11:33 The old way of using BYCOL and LAMBDA – it still works
12:19 Updated simplified syntax for both BYROW and BYCOL
13:06 Create a new BYROW formula to see the list of functions available
13:59 In cell drop-down lists now remove duplicates from the list
15:20 New feature to insert an image in a cell
16:21 You can use XLOOKUP to extract the image based on a name
17:12 New Focus Cell helps display the current row and the current column
18:24 Regex functions are generally available
18:52 REGEXEXTRACT example

Visit the INTHEBLACK website for more Excel content: https://intheblack.cpaaustralia.com.a...

Want to learn more from Neale Blackwood? Visit A4 Accounting a4accounting.com.au