Advanced Level Formulas for Accountants

by Paula Guilfoyle

Excel is an extremely powerful tool for accountants but are you using it to its full potential? Here we look at how to use Excel at an advanced level and the benefits that can bring.

This course is not currently available

This course will enable you to

  • Get to grips with the more complex formulas in excel
  • Use named ranges to quickly navigate a workbook
  • Read complex formulas with ease
  • Calculate future value, carry out one and two variable analysis, use reference functions, and create dynamic ranges and user defined functions
  • Carry out quick calculations and analysis on your data
  • Understand functions such as PMT, Goal Seek, Scenario Manager, OFFSET and INDIRECT

About the course

Excel is an extremely powerful tool for accountants but are you using it to its full potential? Here we look at how to use Excel at an advanced level and the benefits that can bring.

This course will help you develop the skills you need to carry out quick calculations, whether you're trying to calculate loan repayments, or carry out what if analysis on your data. You'll learn how to calculate future value, carry out one and two variable analysis, use reference functions, and create dynamic ranges and user defined functions.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Financial Functions
    • How do I calculate future value?
    • How do I calculate effective interest rate?
    • How do I calculate present and net present values?
    • How do borrowers view the PMT function?
    • How do lenders view the PMT function?
  • Analysis for Accountants
    • How can I carry out a one variable analysis?
    • How can I carry out a two variable analysis?
    • What are Scenario Manager, Goal Seek and Solver?
    • How do I use Scenario Manager?
    • How do I use Goal Seek?
    • How do I use Solver?
  • Reference Functions
    • How do reference functions benefit accountants?
    • What is the OFFSET function?
    • How do I use OFFSET?
    • What is the INDIRECT Function?
    • How do I use INDIRECT to overcome errors?
    • How do I use ROWS and COLUMNS?
    • What is the CHOOSE function?
  • Named Ranges and User Defined Functions
    • What are named ranges and what are the benefits of use for accountants?
    • How do I set up named ranges?
    • How do I find and edit named ranges?
    • How do I set up a dynamic named range?
    • What should accountants know about User Defined Functions?
    • How to create a UDF?

How it works

Author

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

Reviews

You might also like

Take a look at some of our bestselling courses

This course is not currently available. To find out more, please get in touch.