A spreadsheet program provides one of the best Management Information Systems tools for policy analysis. The
modelling component of the course enables participants using Microsoft Excel to handle financial planning, budgeting,
payroll management, project cost projection, what-if analysis, cost planning and regressions. The course aims at
developing knowledge and skills in using advanced features of Ms-Excel.
Persons who handle data/tabulation such as Accounts staff, Secretaries, Administrators etc.
Prerequisite: Applicants must have basic working knowledge of spread sheets.
By the end of the course, participants will be able to:
Exchange Data with other application
Use MS Excel to produce budgets and analyse financial and Statistical data
Create charts based on worksheet data
Carry out simulations and modelling using spread sheets
MS-Excel Formulae and Functions
Manipulating Data & Named Ranges
Formatting & Displaying Data Techniques
Linking & Consolidating Data from multiple sheets (Using MS-Excel for Payroll and Financial Management)
Advanced Charts Formatting Techniques
Statistical Data Analysis in Ms-Excel
MS-Excel Functions (date/time, statistical)
MS-Excel Functions (text, financial, etc)
MS-Excel Functions (logical i.e nested If statements)
MS-Excel Functions (database)
Exchanging Data with Other Applications
Protection & Security
Lectures, demonstrations and practical exercises.
DURATION: 1 Week
DATE: April 25 - 29, 2016
August 22 - 26, 2016
TUITION FEES: Ug.Shs.320,000=
Accommodation (excluding meals) Ug.Shs.180,000=
VENUE: Uganda Management Institute - Kampala Centre
CODE: IT: 201-03