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 |
