ChatGPT Image Jun 25, 2025, 03_26_40 PM

Data Analytics with Microsoft Excel

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
Pre Course Introduction
What is Data? (Simple real-life examples: test scores, social media stats, game scores)
What is Data Cont.
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
Assignment
Week 3: Basic Formulas and Functions
What are formulas? How do they work?
Basic Functions: =SUM(), =AVERAGE(), =MAX(), =MIN()
Basic Functions: COUNT()
Basic Function =IF()
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
Assignment