Fundamental Excel Skills for Accountants and Finance Staff
Learn the core fundamental Excel skills every Accountant or Finance Professional should have.
What You’ll Learn
- You will learn the most essential Excel Skills for Accounting and Financial Professionals – Skills that will enhance you career
- Logical tests and IF statements
- VLOOKUP, INDEX & MATCH and XLOOKUP
- Sum with conditions (SUMIF SUMIFS)
- Tables for efficiency
- Pivot tables
- Dynamic Arrays
Requirements
- You must have a basic level of Excel.
- This course has been recorded using Excel 365. XLOOKUP and Dynamic Arrays are only available in Excel 365. However the rest of this course works in Excel 2016 and later
Description
Are you an Accountant or an aspiring Accountant? Do you work in Finance? Do you want to ensure you are equipped with the core fundamental Excel skills that every accountant or financial professional should have? well if so this course has been designed for you.
Excel is the tool of choice for most accountants, and having great Excel Skills can make a massive difference in your career prospects. However many are lacking the core fundamental skills Excel required to use the tool efficiently.
This course has been designed and developed by an accountant and focuses on the core Excel skills needed in the industry. Some of these skills are at a basic level, however, some of them are at an advanced level. Each of the topics covered in this course is a core skill for the job and knowing some of the newer features of Excel 365 will put you ahead of the curve.
This course is a short course and a basic knowledge of Excel is required. In this course, you will find workbooks to download so you can practice along and you will also find some activities to complete.
The topics covered in this course are:
- Logical tests and IF statements.
- Lookup Formulas
- Summing with criteria
- Working with tables
- Pivot tables
- Dynamic arrays
Who this course is for
- Bookkeepers and Trainee Bookkeepers
- Accountants and Trainee Accountants (CPA, ACCA, CIMA, CA)
- Finance Staff and Financial Professionals
