Current Status

Pre-order

Price

NGN 10,000.00

Get Started

Goal: By the end of this course, the students should be able to collect, clean, analyze, and
present data using Excel.

Course Content

Week 1: Introduction to Data & Excel Basics
Types of Data: Qualitative vs Quantitative
Different Sources of Data
Getting to Know Excel
Week 2: Data Entry, Cleaning & Sorting
Entering Data Accurately
Spotting and fixing common errors
Sorting and Filtering (e.g., filter top scores or sort by birth date)
Removing duplicates
Hands-on Activity: Clean a messy student score sheet
Week 3: Basic Formulas and Functions
What are formulas? How do they work?
Basic Functions: =SUM(), =AVERAGE(), =MAX(), =MIN(), =COUNT(), =IF()
Using cell references (relative vs absolute)
Hands-on Activity: Calculate total and average scores for a mock exam
Week 4: Data Visualization with Charts
Why visualize data?
Types of Charts: Bar chart, Pie chart, Line chart
Creating Charts in Excel
Chart Customization: colors, labels, titles
1 of 2