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
Next Lesson
Pre Course Introduction
Data Analytics with Microsoft Excel
Pre Course Introduction
Please login for access.
Login
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
