Advanced Excel Formulas for Accountants - eLearning
All year round, and on every accountingcpd purchase you make, get 10% off as a CA ANZ member. Just use code CAANZ101.
Please note you will be directed to accountingcpd to purchase this product.
This course explores Excel's advanced functions and how you can apply them in your finance work.
About
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.
Upon satisfactory completion of this activity you will be able 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.
Benefits:
Take your Excel knowledge and skills to the next level.
EVENT DETAILS
Topic: Business Mindset
Sub-Topic: Information & Communication Technology
Format: eLearning
Proficiency Level: Foundation, Intermediate, Advanced
CPD: Upto 4 hours