Here’s my belated Excel tip of 2023
At the backend of last year, I was honoured to be asked by Microsoft MVP John Michaloudis to participate in his podcast, The Best Microsoft Excel Tips & Tricks in 2023.
Along with 18 other names from the Excel community, we uploaded audio clips sharing our favourite tips and tricks of 2023, including the GROUPBY and XLOOKUP functions, dynamic arrays, checkboxes, ChatGPT, Power Query, and many others.
Mine was the most general out of the lot — addressing the need to stay up-to-date with the latest features, functions, and improvements. But hopefully, it hit homes an important point.
I feared this wouldn’t be published, given we had reached mid-March and I hadn’t seen any sign of it on John’s website or social media.
Nevertheless, there are some top tips from everyone, so I recommend listening to the whole podcast. However, if you’re after my segment, it’s at 21:13–22:40. I’ve also included a transcript after the link below.
Transcript
Hello, it’s Andrew Moss from the Global Excel Summit!
It’s been another cracking year for new features, functions, and improvements.
Therefore, my tip of the Year is to stay up to-date.
This is more important than ever.
2023 has been a breakthrough year for AI, and it’s already having a huge impact on our daily lives.
And it’s not going away whether you like it or not, so you might as well embrace it.
Excel is being transformed from a mere data analysis tool to a turbocharged data science juggernaut.
This year, we’ve seen Python arrive.
We’ve seen Copilot arrive.
We’ve seen checkboxes arrive.
We’ve seen a raft of new functions arrive, including IMAGE, GROUPBY and PIVOTBY.
The list goes on and on and on.
They’re not gimmicks — they’re game-changers.
Granted, some of these are only available to Microsoft 365 Insiders at the time of speaking.
However, we can look forward to their mass rollouts in 2024.
If you wanna save time, be more efficient, more productive, and build bulletproof workbooks, you need to tap into Modern Excel.
Get ahead of the curve now. With new stuff coming thick and fast, there’s only going to be more to learn next year.
And if your company still insists on still using Excel 2013, do everything in your power to get them to upgrade to Microsoft 365. They don’t know what they’re missing out on.
