General Excel Formulas for Accountants

by

Designed specifically for accountants, this course enables you to create basic and complex IF statements and use various LOOKUP functions. It also explains how to use conditional functions, relative and absolute cell references to write formulas efficiently.

£100 +VAT

4 CPD hours

120 days’ access

Use ACPD101 for 10% off any purchase.

General Excel Formulas for Accountants

£100 +VAT

4 CPD hours 120 days’ access
Use ACPD101 for 10% off any purchase.

General Excel Formulas for Accountants

This course is not currently available. To find out more, please get in touch.

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 available 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

About the course

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.

Contents

Logical functions and IF statements

Welcome
Logical tests and IF statements
AND and OR
Nested IF statements

Conditional calculations

Welcome
IFS
SUMIF and SUMIFS
More IFs and IFSs
MIXIFS

LOOKUP functions

Welcome
The fundamental functions
VLOOKUP
VLOOKUP with MATCH
INDEX and MATCH
Looking up to the left
XLOOKUP

Relative and absolute cell references

Welcome
Efficient formulas
Relative cell references
Absolute cell references
Creating a multiplication table

How it works

Author

Paula Guilfoyle

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.