Event: Statistical Analysis with Excel Course

Venue: Indepth Research Services, Naivasha, Kenya.

Event Date: 12th March – 16th March 2018

NITA CERTIFIED.

RECENT CLIENTS

Introduction
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 outreach@indepthresearch.org

ACCOMMODATION
Accommodation is arranged upon request. For reservations contact the Training Officer.
Email: outreach@indepthresearch.org.
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 outreach@indepthresearch.org