Core Excel Skill for Accounting and Financial Professional
Core Excel Skills For Accountants and Financial Professionals
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 financial presentations. This course provides valuable spreadsheet skills that can take your financial career to the next level.
On Course Completion
Once you have successfully completed this certificate course you will receive:
a certificate from Alison.com and
you will be eligible for the ISMF certification on the payment of a fee.
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
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