Excel for Accountants (Intermediate)
Course Information
- Total Students 20 per class
- Course Duration 2 Months
Description
This course is designed to help Finance staff and Accounting professionals develop the skills and knowledge needed to use Excel effectively in their work, including data management, analysis, reporting, and automation in only 2 months.
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 |
