Advanced Spreedsheet

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)
Pivot Tables
Exchanging Data with Other Applications
Protection & Security

Lectures, demonstrations and practical exercises.
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

Additional Info

  • Course Code: IT: 201-03
  • Start Date: Monday, 22 August 2016
  • End Date: Friday, 26 August 2016
  • School: Distance learning and Information Technology
  • Department: Information Technology
  • Centre: Main Campus