Booking with a training ticket
Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed
Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification
Course 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
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at
(+353) 01 523 3930