Excel for Accountants (Intermediate)
The Excel for Accountants (Intermediate) is primarily aimed at accounting professionals. It aims to teach ten important topics that will assist finance staff with daily Excel tasks.
In this course you will learn:
- Perform calculations using Time and Date functions
- Lookup information using HLOOKUP and VLOOKUP
- Perform more complex lookups using INDEX and MATCH
- Make decisions with IF Statements
- Incorporate logical operators into formulas
- Create a Loan Amortization table using the PMT function
- Clean and prepare raw data
- Create PivotTables and PivotCharts
- Analyse large datasets using Power Pivot
- Use Goal Seek, Data Tables and Scenarios to analyse data
- Automate common tasks using Macros
+ Syllabus
About the author
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.
The Excel for Accountants (Intermediate) is primarily aimed at accounting professionals. It aims to teach ten important topics that will assist finance staff with daily Excel tasks.
In this course you will learn:
- Perform calculations using Time and Date functions
- Lookup information using HLOOKUP and VLOOKUP
- Perform more complex lookups using INDEX and MATCH
- Make decisions with IF Statements
- Incorporate logical operators into formulas
- Create a Loan Amortization table using the PMT function
- Clean and prepare raw data
- Create PivotTables and PivotCharts
- Analyse large datasets using Power Pivot
- Use Goal Seek, Data Tables and Scenarios to analyse data
- Automate common tasks using Macros
+ Syllabus
About the author
Deborah Ashby specialises in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for almost fifteen years and has worked at Microsoft, training its employees in its own software. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT), and she is TAP certified.
If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.
Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.