Intermediate Excel formulas for accountants

Overview

Excel is the tool of choice for accountants, but many of us only use a fraction of the functionality available. It can be difficult to enhance your Excel skills when you don't know what tools are available to you.

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.

This course will enable you 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.

Key information:

• learn at your own pace
• iPad/Android compatible
• exclusive member benefit – 10% discount.

Helping accountants grow 

Disclaimer: This course is available for ACCA members, you may need your ACCA membership number to complete your booking. This course and outline is provided by a third-party course provider. All course bookings are subject to the terms and conditions set by the course provider. Please see individual supplier pages for full terms and conditions. ACCA takes no liability for bookings made with third-party suppliers.