• Home
  • General Level Formulas for Accountants - eLearning

General Level Formulas for Accountants - eLearning


This activity is published by accountingcpd.

CA ANZ members are entitled to receive 10% off every purchase. Use code CAANZ101 at checkout to take advantage of this discount.

Save $180 and get 20 hours of CPD at your fingertips when you pick ANY 5 4-hr CPD courses for just $495 – use code CAANZ20 at checkout. 

Designed specifically for accountants, this course enables you to create basic and complex IF statements, use simple and more advanced Lookup functions and much more.
Content Description:
Excel is a powerful tool and one that as accountants we use regularly. But are you using it to its full potential? By developing your Excel skills you will not only save time but make sure that your spreadsheets are always correct and clear.

Designed specifically for accountants, this course takes you through a range of finance related examples and helps you apply your new knowledge in your professional role.

As an accountant you'll already have a basic knowledge of Excel, but this course will help you to further develop your skills. It enables you to create basic and complex IF statements and use simple and more advanced Lookup functions. You can also delve deep into conditional calculations, the SUM function, and learn how to use relative and absolute cell references to efficiently write formulas.

The course is packed with tips and tricks and all the functions and formulas can be used across all versions of Excel.

General Level Formulas for Accountants is aimed at accountants who have a basic knowledge of Excel and wish to further their knowledge and skills in the area of functions and formulas.

Upon satisfactory completion of this activity you will be able to:
Improve your general knowledge of Excel.
Become efficient in writing formulas.
Start using keyboard shortcuts as well as other time saving tips and tricks.
Construct both basic and complex IF statements.
Use conditional functions to write formulas more efficiently.
Understand different Lookup functions available and their benefits and limitations.

Benefits:
This course arms you with the knowledge and skills to master the basic Excel formulas critical for you to become highly proficient in financial analysis.
No prerequisites.


No materials distributed.


No assessments required.

EVENT DETAILS


Topic: Corporate Finance, Reporting

Sub-Topic: Business Planning & Analysis, Financial Reporting

Format: Self-paced

Proficiency Level: Foundation, Intermediate

CPD: 4 hours