Data Management And Analysis Using Microsoft Excel

Introduction 

Most people use Excel for basic data manipulation and analysis and are not aware of its sophisticated data management and charting techniques and advanced data analysis capability.

This course will build the participant’s current Excel skills on the use of Excel’s powerful tools for data management and statistical analysis.

Duration

5 Days

Target Participants

This course is aimed at professionals in different areas of practice who are looking at improving their data management and analysis skills using Excel. 

COURSE LEVEL:

Register for the course


Face to Face Schedules By Location
Nairobi Schedules:
Code Date Duration Location Fees
DMA001 13 Feb 2023 - 17 Feb 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 13 Mar 2023 - 17 Mar 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 10 Apr 2023 - 14 Apr 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 8 May 2023 - 12 May 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 12 Jun 2023 - 16 Jun 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 10 Jul 2023 - 14 Jul 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 14 Aug 2023 - 18 Aug 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 11 Sep 2023 - 15 Sep 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 9 Oct 2023 - 13 Oct 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 13 Nov 2023 - 17 Nov 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
DMA001 11 Dec 2023 - 15 Dec 2023 5 days Nairobi, Kenya KES 75,000 | USD 1,100 Register
Kigali Schedules:
Mombasa Schedules:
Nakuru Schedules:
Kisumu Schedules:
Naivasha Schedules:
Virtual Trainer Led Schedules
Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected] for a virtual schedule.
E-Learning

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected] for E-Learning course.


By the end of this course the participants will be able to:

  • Analyze relationships across information and data using MS Excel
  • Generate data forecasts using MS Excel
  • Organize data in a more structured manner
  • Analyze data effectively using various MS Excel techniques
  • Apply most appropriate charting technique  data

Course Outline

Introduction to Excel Environment

  • Cell referencing, cell formatting and entering formula
  • Variables in Excel
  • Introduction to Excel Tables
  • Filtering data
  • Sorting data
  • Use of conditional formatting

Data Cleaning and manipulation using Excel

  • Importing data into Workbook
  • Move, copy, resize and delete columns and/or rows and/or sheets
  • Format cell contents
  • Clear formatting and cell contents
  • Find and Replace data
  • Cleaning Data with Text Functions

Using PivotTables

  • Running the PivotTable Wizard
  • Pivot Table Field Options
  • Pivot Table Design and Options
  • Building PivotTable Formulas
  • Pivot Charts

Using Charts in Excel

  • Selecting a Chart Type
  • Working with Chart Styles
  • Changing Chart Layout
  • Changing a Chart’s Location
  • Formatting 3-D Charts

Excel  Statistic Functions

  • Counting Items in a Data Set
  • Average and Average IF
  • Means, Modes, and Medians
  • Min Max
  • Finding Values, Ranks, and Percentiles
  • Standard Deviations and Variances
  • Normal Distributions

Descriptive Statistics using Excel

  • Using the Excel Analysis tool pack
  • Creating a Histogram
  • Ranking by Percentile
  • Calculating Moving Averages
  • Exponential Smoothing

Inferential Statistics using Excel

  • Using the t-test Data Analysis Tool
  • Performing z-test Calculations
  • Using the Correlation Analysis Tool
  • Using the Regression Data Analysis Tool
  • Using the Covariance Analysis Tool
  • Using the ANOVA Data Analysis Tools

Course Administration Details:

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 Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.

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

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.

Email:[email protected] or [email protected]  

Mob: +254 715 077 817 or +250 789 621 067

TAILOR- MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817 or +250 789 621 067

Mob: +254 792516000+254 792516010+250 789 621 067 or mail [email protected] or [email protected]

PAYMENT

Payment should be transferred to IRES account through bank on or before course start date.

Send proof of payment to [email protected]  or [email protected]


DOWNLOADABLE DOCUMENTS:
No documents uploaded