Excel for Accountants Course

This Excel for Accountants Course will equip you with the exact Excel skills you need as accountant.

COURSE OUTLINE

• 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

FOR WHOM

Accounting and Finance Professionals.

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.