Skip to content
Data Analytics with Microsoft Excel
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
1 of 2
Previous Lesson
Next Lesson
What are formulas? How do they work?
Data Analytics with Microsoft Excel
What are formulas? How do they work?
Please login for access.
Login
Previous Lesson
Back to Course
Next Lesson
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
