Excel Skills for Accountants

Core Excel Skills For Accountants and Financial Professionals

Learn the core Microsoft Excel skills every accountant or financial professional needs in this online course.

This course provides the fundamental Microsoft Excel skills that every accountant or financial professional requires. Important features are covered from logical tests involving ‘IF’ statements, pivot tables and , dynamic array functions. Learn the key Excel features used daily in bookkeeping and to financial presentations. This course provides valuable spreadsheet skills that can take your financial career to the next level.

On Course Completion

Once you have succesfully completed this certificate course you will receive:

Course Syllabus

The course consists of two Modules:

Module One
  • Core Excel Essentials for Accountants - Excel 365
    • Learning Outcomes
    • Logical Tests and IF Statements
    • Sum with Criteria
    • Lookups in Excel
    • Tables and Pivot Tables
    • Dynamic Arrays
    • Lesson Summary
Module Two
  • Course Assessment
    • Course Assessment
In this course, you will learn how to:
  • Solve problems and carry out logical tests and ‘IF’ statements
  • Calculate ‘SUM’ with multiple criteria
  • Analyze data with pivot tables
  • Explain and carry out different types of lookups
  • Explain and demonstrate the benefits of working with tables