Excel tips and tricks for business - Session 6 - Modern Excel - what you may have missed in the last ten years
Excel has changed a lot over time – if you’re just learning about Power Pivot and Power Query, consider that they’ve been a part of Excel for the better part of 10 years now. There have been even more recent changes – this session will cover a number of them, in addition to some items outside of, but still within, the Excel ecosystem.
- Dynamic arrays
- LET and LAMBDA
- Analyze Data
- Data Types
- Office Scripts
- Power Automate
In the 'Excel tips and tricks for business' series we look at the core functions and features in Excel that help people build up spreadsheets and solve problems in a manner that is consistent, robust, flexible and transparent.
You can find more information about the other five sessions in the 'Agenda' tab.
Session 1 - Spreadsheet best practices and fundamentals
Session 2 - Key Excel functions
Session 3 - Key excel features
Session 4 - Using Power Pivot
Session 5 - Using Power Query
Session 6 - Modern Excel - what you may have missed in the last ten years
Tim Heng has over 15 years’ experience in developing and reviewing financial models across a range of industries and sectors, throughout Australia and internationally. He works with clients to develop bespoke modelling solutions for business challenges, using a combination of Excel, VBA, Power BI and database analytics.
He has worked across the world, with clients in Australia, Canada, Hong Kong, Indonesia, Japan, Malaysia, New Zealand, Singapore, United Kingdom, United States and Vietnam, as well as numerous projects based throughout Africa. These assignments have involved the development of strategic corporate and project-based financial models, model reviews, developments of dashboards and reports, and training of analysts and senior staff.
Tim has written articles for the CompAct and Modelling Section newsletters published by the Society of Actuaries (US), and has been a regular presenter at conferences, training courses and webinars for Chartered Accountants Australia New Zealand (CAANZ) and CPA Australia. He is recognised by Microsoft as a Most Valuable Professional specialising in Microsoft Excel since 2017.
Sub-Topic: Financial Reporting, Personal Effectiveness, Solve Problems
Format: Recorded Webinar
Proficiency Level: All
CPD: Upto 1.5 hours