Excel is a valuable tool for any accountant, but with so many features, are you making the most of what it has to offer? It can be difficult to keep track of all the tools available in Excel, but some can really transform the spreadsheets that you produce.

This course will help you to ensure your Excel skills are up to date. Not only will you be able to use some fundamental functions of Excel such as IF statements, AND statements, and OR statements, but you'll also discover the new XLOOKUP function. Familiarise yourself with the benefits that using Excel Pivot tables can provide when analysing data and create dynamic, interactive charts using functions such as IF, INDEX, and MATCH.

This course will enable you to:

  • familiarise yourself with some fundamental Excel functions including IF statements, AND statements, and OR statements
  • work with Excel PivotTables to quickly navigate, analyse data and find insights
  • understand the VLOOKUP formula and how you can overcome its limitations with XLOOKUP
  • use functions such as IF, INDEX, and MATCH to create dynamic and interactive charts.

Key information

  • now with personalised course notes to download and keep
  • learn at your own pace
  • help meet your annual CPD requirements
  • exclusive member benefit – 10% discount
  • iPad/Android compatible.
logoACPD_turq_72dpi_trans 20180308

Helping accountants grow

Disclaimer: This course and outline is provided by a third-party course provider. All course bookings are subject to the terms and conditions set by the course provider. Please see individual supplier pages for full terms and conditions. ACCA takes no liability for bookings made with third-party suppliers.