• Home
  • Recorded webinar
  • Excel tips and tricks for business - Session 1 - Spreadsheet best practices and fundamentals

Excel tips and tricks for business - Session 1 - Spreadsheet best practices and fundamentals

Save 20% off this product as part of our EOFY CPD Sale. Spend $600 or over to receive 30% off, or spend $1,000 or over to receive 40% off. Discount applies automatically at checkout. Sale ends 11.59pm AEST 1 July 2024. T&Cs apply.

Excel tips and tricks for business - Spreadsheet best practices and fundamentals forms the first part of our six-course series that covers the essentials of using Excel in a business context.

This session introduces the notion of good spreadsheet practices, and the fundamental rules and guidelines to follow if you want professional, well-built spreadsheets.

  • Understand the importance of applying good spreadsheet practices
    • Consistency
    • Robustness
    • Flexibility
    • Transparency
  • Learning the importance of having a standardised approach to building spreadsheets in an organisation

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 next five sessions in the 'Agenda' tab.

Tim Heng

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.


Topic: Reporting

Sub-Topic: Financial Reporting, Personal Effectiveness, Solve Problems

Format: Recorded Webinar

Proficiency Level: All

CPD: Upto 1.5 hours