• Home
  • Excel Excellence: Full Series

Excel Excellence: Full Series


Are you an everyday Excel user looking to expand your knowledge to improve your spreadsheet efficiency, effectiveness and accuracy?

This webinar series will focus on key features, built-in Excel tools, and functions commonly used in a typical business context. This webinar will also explore the most common issues found in typical business spreadsheets.

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 recorded webinar series is designed to save you time when formatting and updating data in Excel while reducing errors in your spreadsheets moving forward. Learn the shortcuts, best practice tips and useful features that will change the way you use Excel.


Session Information

PartSession TitleCPD hours
Part 1Excelling at Excel1 CPD hour
Part 2Functional Excel Functions1 CPD hour
Part 3Spreadsheet Review1 CPD hour

Excelling at Excel

In this webinar you will learn a number of practical and useful shortcuts that can reduce the amount of time you spend moving back and forth between the keyboard and mouse, as well as useful features such as Conditional Formatting, Named Ranges, Styles and Tables that help you quickly update calculations and formatting.

Functional Excel Functions

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(!).

Spreadsheet Review

Errors in spreadsheets are not uncommon and these mistakes can lead to costly miscalculations. Many of these errors are completely preventable. Given that we work with spreadsheets on a daily basis, it’s critical that we know where we are likely to make mistakes, and how to reduce the risk of errors occurring.

In this webinar you will find out why Excel errors usually occur, and be provided with the tools necessary to help identify common problems in your spreadsheets.


Learning Outcomes

Excelling at Excel

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

  • List the time saving shortcuts used to efficiently perform tasks that you regularly use
  • Optimise the Ribbon and other settings in Excel for your benefit
  • Use time saving features such as Styles and Tables
  • Perform your Excel-based tasks faster and more effectively, with less mistakes

Functional Excel Functions

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

Spreadsheet Review

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

  • Identify the cause of common Excel errors
  • Determine what to look out for in your spreadsheet to avoid common errors
  • Understand what types of review options are available for different purposes
  • Apply simple checks to improve spreadsheet accuracy

Benefit

Participation in this recorded webinar series will equip you with the tools you need to make Excel work faster and more effectively when dealing with common business challenges. Also understand how to reduce spreadsheet risk and increase your Excel efficiency by learning the implications and causes of many different types of spreadsheet errors, and how they can be easily avoided or mitigated through the use of checks and/or formal review processes.

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: 3 hours