Microsoft Excel World Champion: Meet Andrew Ngai, the “Annihilator”
Andrew Ngai, a 37-year-old Australian actuary, has made quite a name for himself in the world of Microsoft Excel. Apart from his day job as a director at consulting firm Taylor Fry in Sydney, Ngai has emerged as a three-time Excel world champion. His latest victory came last month at Las Vegas’ HyperX Esports Arena, where he walked away with a prize of $3,000.
Rise of “The Annihilator”
Ngai’s dominance in Excel competitions has earned him the nickname “The Annihilator,” which cleverly plays on his name and reflects his unmatched skills in the software. Since 2018, Ngai has been competing against fellow Excel enthusiasts from around the world, showcasing his ability to solve complex case studies and build spreadsheets in under 30 minutes.
These challenges have covered a wide range of topics, from financial modeling to analyzing fictional asteroid mining data from the game Eve Online. Ngai’s expertise and quick thinking have propelled him to the top, earning him not only recognition but also substantial prize money amounting to approximately $12,000 so far.
Excel Tips for Budgeting and Productivity
Despite his extraordinary Excel prowess, Ngai firmly believes that anyone can harness the power of this software for budgeting and enhancing productivity. Here are Ngai’s top tips for Excel users of all skill levels:
1. Basic Math Functions for Budgeting
Ngai suggests utilizing “basic math” functions present in Excel to perform various calculations for personal budgeting. These functions allow users to add, multiply, divide, and subtract values easily. By categorizing monthly expenses and using the “SUMIFS” function, one can track expenses accurately and identify areas where spending can be reduced.
2. Explore Excel’s Lookup and Reference Functions
Beyond basic functions, Ngai recommends familiarizing oneself with Excel’s advanced function tools, specifically those under the “Lookup and Reference” dropdown menu. Functions like “Index,” “Match,” and “XLookup” enable users to quickly retrieve specific information from large tables of data. Additionally, the introduction of Dynamic Arrays in recent versions of Excel provides a time-saving solution for sorting and analyzing extensive datasets.
3. The Mindset of Continuous Improvement
According to Ngai, the key to becoming an Excel expert lies in adopting a mindset of constantly seeking improvement and finding better solutions. This mindset propelled him to enhance his Excel skills early in his career, ultimately leading to his remarkable success as a world champion.
Unlocking the Power of Excel
Ngai’s journey from a skilled actuary to a renowned Excel champion showcases the immense potential and versatility of this software. Whether you’re an actuary, a professional seeking to boost productivity, or an individual aiming to manage personal finances efficiently, Excel can be a valuable tool in your arsenal.
By following Ngai’s expert tips and embracing a mindset of continuous improvement, you too can unlock the power of Excel and unleash your productivity to new heights.
Ready to take control of your Excel skills? Join us in CNBC’s new online course How to Ace Your Job Interview, where you’ll learn the secrets hiring managers are looking for, master body language techniques, craft persuasive responses, and negotiate the best salary. Get started today and save 50% with discount code EARLYBIRD.