• Home
  • Excel Training: Learning Excel Formulas and Functions

Excel Training: Learning Excel Formulas and Functions


Are you an everyday Excel user looking to expand your knowledge to improve your spreadsheet efficiency, effectiveness and accuracy. In this 1 hour recorded webinar you will learn about the functions commonly used in a typical business context, how to improve their use and when they should be used.

Content Description

Feeling LEFT behind by your colleagues at work? Forget about Beginner, Intermediate or Advanced functions – the RIGHT functions to use are the ones that will actually help you achieve your results.

You can CHOOSE a basic Excel course, or you can LOOKUP one that MATCHes the typical business problems that you FIND in your workplace.


This webinar is designed to help you use Excel functions more effectively and efficiently to solve typical business problems. Instead of learning bad habits from work colleagues and Google, learn how to use functions like IF, SUMIF, INDEX and MATCH with a series of practical examples, and why you shouldn’t use VLOOKUP(!).


Presenter, Tim Heng, is a Director at the consulting firm SumProduct. He runs a range of Excel training courses listed on the Chartered Accountants Australia New Zealand store, and is a Microsoft MVP specialising in Excel, one of only ~110 worldwide.


Learning Outcomes

Upon satisfactory completion of this webinar you will be able to:

  • Identify which functions should be used in typical business Excel spreadsheets
  • Use the functions covered to solve practical business challenges
  • Convert calculations in existing spreadsheets to use more newer and better tools
  • Perform your Excel-based tasks faster and more effectively, with less mistakes

Benefits


Solve practical business challenges faster by being equipped with the tools you need to make your Excel work more effective and efficient.


Benefit

Solve practical business challenges faster by being equipped with the tools you need to make your Excel work more effective and efficient.

Tim Heng, has over 10 years’ experience in financial model development, model auditing, banking, training and consultancy. He was previously the Head of Training at Corality, and is currently a Director at the consulting firm SumProduct. Tim has run numerous training courses in financial modelling and Microsoft Excel skills around the world. Tim is recognised by Microsoft as a Most Valuable Professional (MVP) expert in Excel, one off c.100 such individuals worldwide.


EVENT DETAILS


Topic: Business Mindset

Sub-Topic: Information & Communication Technology

Format: Recorded Webinar

Proficiency Level: Foundation, Intermediate

CPD: 1 hours