Statistical Analysis with Excel Course

Event: Statistical Analysis with Excel Course

Venue: Indepth Research Services, Naivasha, Kenya.

Event Date: 12th March – 16th March 2018

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.

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)

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]

Others Details

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]