Intermediate 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.
Take your Excel skills to the next level with this course on intermediate level formulas.
This course builds on your Excel knowledge and skills by introducing you to even more formulas that you can use in your accounting or finance role. You'll master a variety of rounding and text functions, understand how to use date and time formulas in your role and how to create error-resistant formulas. It's an ideal course for finance professionals who have mastered general level formulas and are looking to take their skills to the next level.
Upon satisfactory completion of this activity you will be able to:
- Use a variety of rounding functions and formulas.
- Extract text from text strings, create dynamic text labels, and custom format your text.
- Use custom formatting to change the presentation of dates and times.
- Make your workbooks more resistant to errors by setting up data validation and creating error-resistant formulas.
You have mastered general level formulas – now take your skills to the next level.
Topic: Business Mindset
Sub-Topic: Information & Communication Technology
Proficiency Level: Foundation, Intermediate
CPD: Upto 4 hours