The Institute of Certified Public Accountants of Uganda in collaboration with Data House Business Solutions invites you for Advanced Excel tools & formulae for Finance & Accounting, scheduled as follows:
DATE: 17 MAY 2019
VENUE: IMPERIAL ROYALE HOTEL, KAMPALA
TIME: 8:00 AM TO 5:00 PM
OVERVIEW
Advanced Excel focus solely on solving complex problems with your data
LEARNING OUTCOMES
This one day Excel training will help accountants ramp up their Excel skills so that they are able to use Excel more effectively and efficiently. It provides the expert tips and techniques that save accountants time, stress, yet improve on the way they work.
At the end of the course, participants will learn about:
Financial functions – to calculate financial information, such as net present value and payments
Logic functions – e.g. the IF Function and its variations, such as SUMIF and SUMIFS
Different lookup functions available and their benefits and limitations
Pivot Tables – one of the most powerful functions for finance executives
Formula Auditing – how to trace formulas that others have created
Data analysis including sorting, filter by selection and subtotals
Goal seek – how to use this important “what-if” tool
Charting – create useful chats with ease
WHO SHOULD ATTEND?
This course is designed for accountants and finance professionals including budget analysts, management analysts, cost and financial accountants, practising accountants, staff of internal audit functions and others who need to support managerial decision-making based on large volume of data
This is an intermediate - advanced level Microsoft Excel training course. Participants must have some basic spreadsheet skills and should be able to: use excel formulas; link worksheets and understand how cells are referenced. Participants will need a laptop with Microsoft® Excel 2010 or later version.
Class size is limited to 60 participants only. Attendance is strictly by registration at www.icpau.co.ug
FEES (MEALS AND REFRESHMENT INCLUSIVE):
UGX 250,000 per participant.
Payments can be by: Cheque/Direct Credit or Mobile Money using member/student ID number.
Deadline for booking is Wednesday, 15 May 2019
ACCOUNT DETAILS
Account Name: Institute of Certified Public Accountants of Uganda
Account Number: 3100009548
Bank: Centenary Rural Development Bank Limited
Branch: Lugogo, Kampala
Plot 3A2 – 3A3, Kampala
Swift Code: 163047
Institute of Certified Public Accountants of Uganda
42 Bukoto Street Kololo, P.O. Box 12464, Kampala, Uganda
Tel: 0393–262333, 0393–266920, 0312-265590, 0417-788700
Email: icpau@icpau.co.ug, cpd@icpau.co.ug Website: www.icpau.co.ug