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:
- a certificate from Alison.com and
- you will be eligible for the CABA Associate 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
- 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
