Data Management and Analysis Using Advanced Excel for planners, Budget officers and Economist Training.

This will be a comprehensive, Advanced and practical training course on Data Management and Analysis for finance staff, departmental heads and other staff whose roles necessitate periodic reports or otherwise and whose functionality imperatively revolves around use of Excel Spreadsheets. The course aims to impart skills that will among other things lead to objective reporting and improved use of excel spreadsheets.

Microsoft Excel has countless business value adding features and the expert trainers will aim to select the most powerful and business relevant tools and cover these while ensuring the practical sessions enable learners to emerge from the training more empowered.

Advanced Excel Modeling

This will be a comprehensive, advanced and practical training course for project heads and other staff whose roles necessitate periodic reports or otherwise and whose functionality imperatively revolves  around use of Excel Spreadsheets. The course aims to impart skills that will among other things lead to objective reporting and improved use of excel spreadsheets.

Microsoft Excel has countless value adding features and the expert trainers will aim to select the most powerful and relevant tools and cover these while ensuring the practical sessions enable learners to emerge from the training more empowered.

Main Training Modules

Data Manipulation in Excel

• How Excel handles different data types
• Data consistency, starting with the end in view
• Building Datasheets that can easily scale
• Sorting