Food Security and Agriculture

Training Course on Data Analytics with Advanced Excel

Course Overview

The Data Analytics with Advanced Excel training offers a comprehensive exploration of Excel\\\'s capabilities in data analysis.  Throughout the course, you will delve into advanced techniques for cleaning and preparing data, mastering complex formulas and functions,  and creating impactful visualizations like charts, graphs, and interactive dashboards.  By the end of this program, you will possess the skills and confidence to extract valuable insights from data, enabling you to make informed decisions and drive organizational success through data-driven strategies.

Course Duration: 10 days

Module 1: Introduction to Data Analytics

  • Importance in decision-making
  • Key concepts and terminology
  • Advantages of using Excel
  • Introduction to Excel data analysis tools

Module 2: Data Cleaning and Preparation

  • External data connections
  • Importing data from different sources
  • Removing duplicates and inconsistencies
  • Text to columns, data validation, and formatting

Module 3: Exploratory Data Analysis (EDA)

  • Mean, median, mode
  • Measures of dispersion
  • Creating charts (bar, line, pie)
  • Conditional formatting for visual insights

Module 4: Advanced Excel Functions for Data Analysis

  • Statistical Functions - AVERAGEIF, COUNTIF, SUMIF
  • Statistical analysis with Excel functions
  • Combining functions for dynamic analysis

Module 5: PivotTables and PivotCharts

  • Summarizing and analyzing data
  • Grouping and filtering data
  • Creating dynamic charts linked to PivotTables
  • Using slicers for interactivity

Module 6: Power Query and Power Pivot

  • Data import and transformation
  • Merging and appending queries
  • Creating data models
  • DAX (Data Analysis Expressions) introduction

Module 7: Data Analysis with What-If Analysis Tools

  • Performing sensitivity analysis
  • Creating and managing scenarios
  • Optimization and constraint-based analysis
  • Solver for linear programming problems

Module 8: Regression Analysis in Excel

  • Linear regression basics
  • Multiple regression analysis
  • Data preparation for regression
  • Interpreting regression results

Module 9: Automation with Macros and VBA

  • Recording and executing macros
  • Writing simple VBA code for automation
  • Integrating VBA with data analysis tasks

Module 10: Real-world Applications and Case Studies

  • Application of data analytics in various sectors
  • Extracting actionable insights from real-world data
  • Applying learned concepts to a comprehensive data analysis project
  • Peer review and feedback

Note: This outline provides a general structure for the training. The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.

Classroom Training Schedule

Start Date End Date Location Cost Apply
May 20, 2024 May 31, 2024 Nairobi $ 1800 Register
Jun 24, 2024 Jul 05, 2024 Nairobi $ 1800 Register
Jul 29, 2024 Aug 09, 2024 Nairobi $ 1800 Register
Sep 02, 2024 Sep 13, 2024 Nairobi $ 1800 Register
Oct 07, 2024 Oct 18, 2024 Nairobi $ 1800 Register
Nov 11, 2024 Nov 22, 2024 Nairobi $ 1800 Register

Virtual Training Schedule

Start Date End Date Location Cost Apply
Jun 03, 2024 Jun 14, 2024 Online $ 700 Register
Jul 08, 2024 Jul 19, 2024 Online $ 700 Register
Aug 12, 2024 Aug 23, 2024 Online $ 700 Register
Sep 16, 2024 Sep 27, 2024 Online $ 700 Register
Oct 21, 2024 Nov 01, 2024 Online $ 700 Register
Nov 25, 2024 Dec 06, 2024 Online $ 700 Register

Registration Process

Enrolling in our training programs is effortless! Upon submitting your details on the course registration link, a representative will get in touch with the relevant information.

Group Discounts

Boost your team's skills and maximize value with our attractive group discounts. Enroll 3 or more participants and enjoy significant discounts on any of our training programs.

Course Language

This Training course is offered in ENGLISH . Please indicate the language of choice during registration.

Training Approach

Our instructor-led trainings use well guided presentations, practical exercises, and group acivities. Participants are encouraged to bring any data relevant to their job responsibilities. Training manuals and additional reference materials are provided to the participants.


Upon completion of training, the participant will be issued with a certificate of Completion.

Post Training Support

Our commitment our clients success extends beyond the training program. We offer ongoing 3 months support through Q&A sessions, online forums, and access to our expert instructors.

Tailor-Made Course

We design customized training programs and inhouse workshops to meet specific training needs and organizational goals. Contact us to find out more: