Overview

Excel is an extremely powerful tool for accountants but are you using it to its full potential? Take your Excel skills to the next level, by mastering more advanced techniques, and understanding how they can be applied in your finance role.

This course will help you develop the skills you need to carry out complex calculations, like calculating loan repayments, and what-if analysis on your data. You'll learn how to calculate future value, use one and two variable analysis and make the most of reference functions. You'll also discover how using named ranges and user defined functions can make you more efficient in your work.

This course will enable you to:

  • employ Excel’s suite of financial functions to calculate loan repayment and investment returns
  • use functions such as Goal Seek and Scenario Manager, to analyse data and solve problems including both one and two variable analysis
  • use OFFSET, INDIRECT and other Lookup and Reference functions to reference data from other worksheets, create dynamic functions and carry out lookups
  • use named ranges and user defined functions to make navigation easier and formulas simper to read.

Key information:

  • learn at your own pace
  • iPad/Android compatible
  • exclusive member benefit – 10% discount.
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