Tim Heng (@timaheng) profile picture

Financial modelling professional. Microsoft Excel MVP.

Sydney, Australia
Joined February 2014
Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)Photo by Tim Heng (@timaheng)
We are live! Come join us at Excel Virtually Global 2021, with 45 hours of sessions presented by Excel MVPs, Power BI MVPs, Microsoft Excel team members and great Excel experts from around the world. All for free, or donation to a charity of your choice! excelvirtuallyglobal.com/acc…
2
A bit late notice, but hoping that you can join myself and David Benaim as he presents a session on where Google Sheets beats Excel tonight at the Sydney Excel User Group! Details here: meetup.com/sydney-excel-user… #Microsoft #Excel #Google #Sheets
1
For those who aren't aware, we've set up a Sydney Excel User Group, and for our inaugural session, we're grateful to have Kaycee Reineke join us to talk about What's New in Excel! Come join us and invite your friends! meetup.com/sydney-excel-user…
Just under 11 hours to go - if you're stuck working from home, why not come join us?
Join Tim Heng in the latest Modern #Excel webinar and explore the basics of automation with Visual Basic for Applications and macros. Register now for the webinar happening Monday, March 23 at 3:00 PM PT: msft.it/6015Tjxjb

1
Woke up to this news today! #XLOOKUP is in #Excel folks! Make sure you're on at least Monthly channel to get it right away!
#XLOOKUP - the successor to the iconic #VLOOKUP - has arrived in #Excel! Exact match by default, resilient to column insert, search from the back, greater than/less than match, it's faster, *AND* it's easier to use.🤯💯 aka.ms/XLOOKUP @msexcel
2
Dynamic Arrays generally available folks! If you don't see it and you're on Monthly Channel, don't do what I did, and make sure you close and reopen Excel to give it a chance to switch on. #Excel #XLOOKUP too (if you're lucky!)
I'm excited to announce that Dynamic Arrays is now generally available in the #Excel monthly channel.🚀 #SORT #UNIQUE #FILTER
1
Dynamic Arrays are now generally available, starting with Excel on the Web, and will be rolling out to Office 365 Monthly Channel! Check out our recent video on some of the key benefits of using Dynamic Arrays: youtu.be/QvTzfWqoiQQ #Excel #DynamicArrays #Office365
Also in the news - XLOOKUP has shifted the "if not found" argument from last to first optional (i.e. 4th argument) - sumproduct.com/news/article/… #Excel #XLOOKUP #InsiderFast
1
Dynamic Arrays becoming Generally Available this week, starting with Excel on the Web! sumproduct.com/news/article/… #Excel #arrays #MicrosoftIgnite2019
1
3
4
Don't have Office 365 and won't get the new XLOOKUP functions? If you've got 5 minutes to spare, you can check out our latest video on using INDEX and MATCH as an alternative to VLOOKUP. youtu.be/D-_3nB2qMkw #Excel #5minutes
Dynamic Arrays have now been around for 12 months in #Excel #Insiders. How have they changed since they were first released? When will they be released into the wild? sumproduct.com/news/article/…
Seen what's happened in #Excel #PowerQuery recently? Check out the latest changes here - new data summary views: sumproduct.com/news/article/…
1
5
4
Just realised that I never broadcast the launch of our first YouTube video in over a year! Check out our write-up of the new XLOOKUP function here: youtu.be/IIyrai3kaZ0 #Excel #XLOOKUP #VLOOKUP
#ExcelSummitSouth2019 kicks off in Brisbane! Thanks to the Commonwealth Bank for hosting us and to Steve Kraynak from Microsoft for getting us going! #Excel
Just landed in Brisbane for the start of #ExcelSummitSouth2019 tomorrow! Getting ready to kick off two weeks of Excel!
Excel Summit South. It's really a thing, and I'm really speaking! bit.ly/2NZfTZS Brisbane Jul 29/30 Sydney Aug 1/2 Melbourne Aug 5/6 Perth Aug 8/9 See y'all down under! With @OzExcel @wynhopkins @timaheng & more (Working on my decks as we speak.) @msexcel @powerpoint
2
3
1
11
If you haven't already, check out our write-up on the new Dynamic Arrays in Excel, currently in Insiders Fast for selected users:sumproduct.com/news/article/… #Excel #arrays #Microsoft
2
2
We've launched our first book on Amazon! As a way to thank everyone for their support during the launch, you can pick up a discounted copy using the coupon code 20PERCENTSP - check it out here! amazon.com.au/dp/0648300609 #Excel #modelling