Indepthresearch
outreach@indepthresearch.org
  + 254 20 211 3814 | +254 731 240 802
   +254 735 331 020 | +254 715 077 817
Westlands, Rhapta Road
Njema Court, Suite R2
fb twitter LinkedIn flikr flikr G+


Statistical Analysis with Excel Course

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:

3 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.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

TRAINING VENUE 

The venue of the training includes IRES training Centre or another location chosen by the group or in-house for corporates. For locations outside IRES training Centre, the participants are required to have laptops where the software and other materials for the training will be loaded.

TRAINING FEES

Payment should be transferred to IRES account through bank on or before C.O.B  7th August 2017.

Send proof of payment to outreach@indepthresearch.org.

Email: outreach@indepthresearch.org.  

Mob: +254 715 077 817

Tel: 020 211 3814

CANCELLATION POLICY

Payment for the all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

  1. Participants may cancel attendance 14 days or more prior to thecommencement date.
  2. No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met.

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

Event Properties

Duration 3 Days
Event Date 14-08-2017
Event End Date 16-08-2017
Cut off date 07-08-2017
Individual Price (Kenyan) KES 45,000.00
Individual Price (International) EUR 608.00
Individual Price (International) USD 660.00
Location Nairobi, Kenya

Group Tariffs

Group Size Kenyan Rate Per day (KES) International Rate Per day (USD/EURO)
6-10 95,000.00 $ 1,118.00
€ 1,018.00
11-15 146,250.00 $ 1,721.00
€ 1,567.00
16-20 191,250.00 $ 2,250.00
€ 2,048.00
21-25 230,000.00 $ 2,706.00
€ 2,463.00
26-30 262,500.00 $ 3,089.00
€ 2,811.00
30-50 309,825.00 $ 4,556.00
€ 0.00
3-5 62,500.00 $ 736.00
€ 670.00
Share this event:



↑ Top

© Indepth Research Services Ltd 2017