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

• Analyse relationships across information and data using MS Excel
• Generate data forecast using MS Excel
• Organise data in a more structured manner
• Analyse data effectively using various MS Excel techniques
• Select appropriate chart for your data.

Introduction to the MS Excel Environment

• Cell referencing, cell formatting and entering formula
• Workbooks versus Worksheets
• Filtering and 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

Formatting Data with Pivot Tables

• Running the PivotTable Wizard
• Pivot Table Field Options
• Pivot Table Design and Options
• PivotTables and PivotCharts

Statistical Functions in Excel

• Calculating Mean, Mode and Median
• Standard Deviation and Variance
• Basic Statistical Functions in Excel
• Excel Functions for Data Analysis
• Normal Distribution

Descriptive Statistics Using Excel

• Using the Excel Analysis Tool Pack
• Frequency Measures
  • MIN, MAX, COUNT, Frequency, and Percent Functions
• Central Tendency Measures
  • Mode, Mean, and Median functions
• Dispersion or Variation Measures
  • Variance, Range, and Standard Deviation
• Calculating Moving Averages
• Exponential Smoothing
• Creating a Histogram

Inferential Statistics Using Excel

• Setting-up Hypotheses
• Student’s t-test
• Z-test
• Analysis of Variance (ANOVA)
• Correlation Analysis
• Regression Analysis
• Covariance Analysis
• Interpreting Results

Visualizing Data Using Excel Pivot Charts

• Excel Pivot Charts
• Changing Pivot Chart Types
• Building interactive dashboards
• Utilizing Slicers and Timelines
• Generating Reports with Data Visualization Techniques

This course is suitable for a wide range of professionals, including the following:

• Data Analysts and Professionals
• Administrators with a need to improve data management techniques
• Researchers and Academics
• Students and Beginners
• Government and Policy Analysts

The Data Management and Analysis Using Excel training is delivered by our seasoned trainers who have vast experience as expert professionals in their respective fields of practice. The course employs a mix of methodologies including presentations, group exercises, case studies, and much more. Group work is an essential component of the course. The course is designed to be primarily workshop-based, in which participants can work through tasks and problems that mimic their daily activities. Instructors are there to facilitate the group work, addressing real-world concerns.

At Virgon Africa, we believe in experiential learning. We value active participation in our courses through sharing experiences, ideas and practices.