Excel for Accountants (Intermediate)
Course Information
- Total Students 20 per class
- Course Duration 2 Months
Description
Excel for Accountants (Intermediate) Course is
a short course that aims to teach eleven important topics that will assist finance staff with daily Excel tasks.
Course Outline
1. Perform calculations using Time and Date functions |
2. Lookup information using HLOOKUP and VLOOKUP |
3. Perform more complex lookups using INDEX and MATCH |
4. Make decisions with IF Statements |
5. Incorporate logical operators into formulas |
6. Advanced Formulae |
7. Create PivotTables and PivotCharts |
8. Analyse large datasets using Power Pivot |
9. VBA / Auditing VBA |
10. Name Management |
11. Automate common tasks using Macros |