Overview

For many people who work with Excel, it’s the tech gift that keeps on giving, and the latest set of updates is no exception. In fact, they go a long way towards proving that Excel is still a giant in the world of data analysis. The key is having the know-how to get the full potential out of this powerful tool.  

This course has some tips and guidance for beginners, but also covers some of the advanced new capabilities of Excel that can be used to improve efficiency and control of data, details of formula enhancements, an introduction to the GROUPBY, PIVOTBY, and PERCENTOF functions. Additionally, it introduces some uses for the generative AI powers of Excel’s Copilot that you might not have known were possible.

This course will enable you to:

  • get to grips with the latest updates and improvements to Excel
  • use new data conversion options to import and handle data
  • take advantage of the latest advancements in Excel formulas
  • create better reports using the NEW PIVOTBY, GROUPBY, and PERCENTOF functions
  • customise the new generative AI powers of Excel’s Copilot.

Key information

  • 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