course
Excel for Accountants - Intermediate
Filtered
Updated Dec 03, 2024
What you'll learn
- Learn to perform calculations using Time and Date functions
- Learn to lookup functions HLOOKUP and VLOOKUP
- Perform more complex lookups using INDEX and MATCH
- Understand how to make decisions with IF Statements and logic in Excel
- Learn to incorporate logical operators into formulas
- Learn to create a Loan Amortization table using the PMT function
- Understand how to clean and prepare raw data for analysis
- Learn to create Pivot Tables and Pivot Charts
- Understand how to analyze large datasets using Power Pivot
- Learn to use Goal Seek, Data Tables and Scenarios to analyze data
Course Description
This short Excel for Accountants (Intermediate) course covers ten Excel topics critical to Accountants, Bookkeepers, and Financial Services.
This intermediate course follows the Excel for Accountants (Basics) course. This intermediate course looks at more advanced Excel topics used in data analysis such as lookups, logical statements, Pivot Tables and Pivot Charts.
Course Prerequisites
This Excel for Accountants course assumes some existing knowledge of Excel, including formatting numbers in Excel, using simple functions, and putting together formulas in Excel.
Course Details
This short Excel for Accountants training is video-led and includes accompanying downloadable exercises and test questions.
