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

This course imparts essential Microsoft Excel skills vital for every accountant or financial professional. It covers important features such as logical tests with ‘IF’ statements, pivot tables, and dynamic array functions. Learn key Excel functions used daily in bookkeeping and financial presentations. This course offers valuable spreadsheet skills that can elevate your financial career to the next level.

On Course Completion

• A certificate from Alison.com and

• You will be eligible for the CMC Excel certificate on the payment of a fee.

Course Syllabus

The course consists of two Modules:

Module 1

• 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 2

• Course Assessment

• Final 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