Advanced Spreed sheet

ADVANCED SPREADSHEETS

RATIONALE:
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.
TARGET GROUP:
Persons who handle data/tabulation such as Accounts staff, Secretaries, Administrators etc. 
Prerequisite: Applicants must have basic working knowledge of spread sheets.
OBJECTIVES:
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
CONTENT:
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
TRAINING METHODS:
Lectures, demonstrations and practical exercises.
DURATION: 1 week
TUITION:
UGANDANS: 320,000/=
INTERNATIONAL PARTICIPANTS: $ 238
Accommodation (excludingmeals): 30,000/= per night
$ 22 per night
DATES: February 20 – 24, 2017
August14 – 18, 2017
CODE: IT: 201 –03

Additional Info

  • Course Code: IT: 201 –03
  • Start Date: Monday, 14 August 2017
  • End Date: Friday, 18 August 2017
  • School: Distance learning and Information Technology
  • Department: Distance Learning
  • Centre: Main Campus