A 5-Days Training workshop on Excel Application in Business was organised for staff of The Internal Audit Department at the UITS Training Center on 23rd August, 2021 to 27th August, 2021.
The Objective of the training was to sharpen and upgrade staff knowledge in the use of Excel tools in their analytical and data mining when performing auditing activities.
The lead Facilitator and Consultant Mr. Emmanuel Osei-Bonsu took the staff through basic and advance Excel tools and functionalities that would help them in their data analysis and other auditing processes.
Some of the topics covered were:
- Introduction to Excel and Data Management
- Business Intelligence Developing and Reporting
- Using Formulas and Excel Function
- Advanced ‘What-if-Analysis’: Business Decision Tools
- Time-Value-of Money Applications: Industrial Applications
- Automating Payroll Preparation: Payroll Audit
- Automating Budget & Financial Reporting systems: Cash Budget Application Model [Variance Analysis]
At the end of the training, staff were happy with the knowledge acquired which they believed met the desired objective
The Internal Auditor Mr. Daniel Bart-Plange presented certificates to all participants and encouraged the staff to use the knowledge acquired in their auditing activities.