General Excel formulas for accountants

Overview

Excel is a powerful tool and it's one that accountants use daily. 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.

This course 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 write formulas efficiently. You'll discover a variety of tips and tricks, functions and formulas that can be used across all versions of Excel.

This course will enable you to: 

• improve your general knowledge of Excel
• construct both basic and complex IF statements
• use conditional functions to write formulas more efficiently
• understand different LOOKUP functions, and their benefits and limitations
• use both relative and absolute cell references to efficiently write formulas
• start using keyboard shortcuts as well as other time saving tips and tricks.

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.