This course gives practical experience in the use of Microsoft Excel for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel, such as array functions. We look at data entry and management, pivot tables, and graphics.

We also review Excel's facilities for statistical analysis, advising on their use and limitations, and we show how add-ins can be used to enhance Excel's capabilities.

Duration:

5 days

Who Should Attend?

Participants are assumed to have some experience in Excel. This course is intended for anyone who currently uses or is thinking of using Excel for handling data and for their statistical work. It is also for statisticians, if they need to advise and support others on the efficient use of Excel.

Learning Objective:

This course is designed to turn your general Excel capabilities into skills in the use of Excel for data processing and basic statistical applications.

Topics to be covered:

Structured tables
Data entry and validation
Efficient data management, named ranges and VLOOKUP
Using Index, Match and Offset function for advanced data management
Pivot tables for cross tabulations
Good statistical graphics
Conditional operations and array functions
Data summary and analysis; pros and cons of the Analysis Toolpak
Extending Excel with Add-ins for statistical analysis
The use of SSC-Stat, an Excel add-in for efficient statistical work.

Visit our website for more details.

How to participate

Tailor make your course.
Register as an individual.
Register as a group.
Become one of our partners.
Purchase software’s
Frequently Asked Questions (FAQ’s)

View related courses

Data Management, Analysis, and Graphics using Stata Course
Research Design, Data Management, Analyses & Use Course
Data Management, Analysis and Graphics with R Course
Panel Data Analysis with Stata Course
Analysis of Complex Sample Survey Data Course
Data Management and Analysis for M&E in Development Programmes Course
Using Participatory Action Research to Improve Development Practice Course

The most popular courses

Food Security Analysis Course
Diseases Surveillance and Reporting Course
M & E, Data Management & Analysis for Agriculture & Rural Development Programmes Course
ICT for Disaster Response Course
Contingency Planning Course
GIS Analysis for Health Sector Programmes Course
Debt Collection and Credit Management Course

View course catalogue in Research Institute

For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814.

Email [email protected]

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email: [email protected].

Mob: +254 715 077 817

Tel: 020 211 3814

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B 05th March 2018.

Send proof of payment to [email protected]

Reviews

Be the first to write a review about this course.

Write a Review

Indepth Research Services (IRES) is a global institutional capacity building, technical and management consultancy firm with its head office in Nairobi, Kenya.

IRES offers technical and management consultancy services as well as education and training services designed for individuals’ and groups from organizations working in public, not for profit and private sectors.

IRES Kenya has identified itself with a niche market that largely comprises of Government ministries, departments and agencies (MDA’s) and UN agencies, Non-Governmental Organizations, from Africa, Europe, Asia, Middle-East and the Caribbean. We have also served academic institutions, international research organizations, financial institutions and private companies from across the globe. As at 2018 we offer our services in more than 15 locations globally.

Our technical and management consultancy services are in the areas of Agriculture, Education, Energy, Oil and gas, Health, Environment and natural resources, ICT for development, spatial planning, Governance, Management and leadership, communication, transport, revenue management, marketing development and environment among others.
Our education and training services are aimed helping individuals improve their professional knowledge, competence, skill, and effectiveness and enable the institutions to get the best out of their workforce. This is achieved through conducting high impact professional diploma and certificate courses, short courses, conferences, workshops and seminars. ...

View Complete Profile

Vocational Skills