Country dropdown

Intermediate Data Management and Analysis using Excel

INTRODUCTION

Microsoft Excel version 9 and above provides a set of data analysis tools called the Analysis ToolPak which you can use to save steps when you develop complex statistical analyses. You provide the data and parameters for each analysis; the tool uses the appropriate statistical macro functions and then displays the results in an output table. Some tools generate charts in addition to output tables.

This training deals with the use of Excel for data summary, presentation, and for other basic statistical analysis. It is targeted at participants who work with large volumes of data in their daily work, and wish to learn how to save time and work managing and analyzing their dataset by effectively using advanced data management and analysis feature in Excel.

DURATION

5 days

TRAINING OBJECTIVES

This course teaches the learner to manage and analyses data using advanced formulas, lists and comments, exporting and importing of files and data, link and Query external databases, perform statistical analysis on their datasets using the analysis tool kit and present analysis results using pivot tables and pivot charts.

TOPICS TO BE COVERED

  • Introduction
  • Creating a list
  • Manipulating data using formulas
  • Data Aggregation
  • Outlining and Sorting data
  • Entering Data: Data Forms
  • Finding Records Using Criteria
  • Filtering Data
  • Totals and Subtotals Total
  • Subtotals
  • Linking Data
  • Using the Analysis tool pack
  • Descriptive Statistics
  • Normal Distribution
  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • ANOVA: Analysis of Variances
  • Goodness-of-Fit Test for Discrete Random Variables
  • Test of Independence: Contingency Tables
  • Test Hypothesis Concerning the Variance of Two Populations
  • Linear Correlation and Regression Analysis
  • Analysis by goal seek
  • Analysis by pivot tables
  • Presentation using Pivot charts
  • Printing Analysis Results
  • Automating Analysis: Macros with VBA

REQUIREMENTS

Participants should be reasonably proficient in English. Applicants must live up to Indepth Research Services (IRES) admission criteria.

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise 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 training is residential and will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

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

Email:This email address is being protected from spambots. You need JavaScript enabled to view it..  

Mob: +254 715 077 817

Tel: 020 211 3814

TAILOR- MADE

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our training center or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814 or mail This email address is being protected from spambots. You need JavaScript enabled to view it.

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B. 17th June 2019.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

CANCELLATION POLICY

Payment for 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 the training commencement 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

Event Duration 5 Days
Event Date 24-06-2019
Event End Date 28-06-2019
Cut off date 17-06-2019
Individual Price(Kenyan) KES 69,000
Individual Price (International) EUR 790
Individual Price(International in Dollars) USD 920
Location Nairobi, Kenya
Share this event:

Contact Us

+254 715077817 | +254 792516000
outreach@indepthresearch.org
Westlands, Rhapta Road
Njema Court, Suite R2

Search