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
INTERNATIONAL PARTICIPANTS: $ 238
Accommodation (excludingmeals): 30,000/= per night
$ 22 per night
DATES: February 20 – 24, 2017
August14 – 18, 2017
CODE: IT: 201 –03