About this Course

298,366 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 13 hours to complete
English

Skills you will gain

Data ScienceSpreadsheetMicrosoft ExcelData AnalysisPivot Table
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 13 hours to complete
English

Offered by

Placeholder

IBM

Syllabus - What you will learn from this course

Week
1

Week 1

2 hours to complete

Introduction to Data Analysis Using Spreadsheets

2 hours to complete
5 videos (Total 26 min), 1 reading, 2 quizzes
5 videos
Introduction to Spreadsheets5m
Spreadsheet Basics - Part 15m
Spreadsheet Basics - Part 26m
Viewpoints: Using Spreadsheets as a Data Analysis Tool5m
1 reading
Summary and Highlights10m
2 practice exercises
Practice Quiz10m
Graded Quiz15m
Week
2

Week 2

2 hours to complete

Getting Started with Using Excel Speadsheets

2 hours to complete
5 videos (Total 35 min), 1 reading, 2 quizzes
5 videos
Copying, Filling, and Formatting Cells and Data7m
The Basics of Formulas7m
Intro to Functions5m
Referencing Data in Formulas9m
1 reading
Summary and Highlights10m
2 practice exercises
Practice Quiz15m
Graded Quiz20m
Week
3

Week 3

3 hours to complete

Cleaning & Wrangling Data Using Spreadsheets

3 hours to complete
8 videos (Total 48 min), 2 readings, 4 quizzes
8 videos
Importing File Data5m
Basics of Data Privacy5m
Viewpoints: Data Quality and Privacy4m
Removing Duplicated or Inaccurate Data and Empty Rows8m
Dealing with Inconsistencies in Data9m
More Excel Features for Cleaning Data6m
Viewpoints: Issues with Data Quality4m
2 readings
Summary and Highlights10m
Summary and Highlights10m
4 practice exercises
Practice Quiz10m
Graded Quiz10m
Practice Quiz15m
Graded Quiz25m
Week
4

Week 4

3 hours to complete

Analyzing Data Using Spreadsheets

3 hours to complete
8 videos (Total 57 min), 2 readings, 4 quizzes
8 videos
Filtering and Sorting Data in Excel7m
Viewpoints: Filtering and Sorting1m
Useful Functions for Data Analysis11m
Using VLOOKUP and HLOOKUP Functions9m
Introduction to Creating Pivot Tables in Excel7m
Viewpoints: Pivot Tables3m
Pivot Table Features9m
2 readings
Summary and Highlights10m
Summary and Highlights10m
4 practice exercises
Practice Quiz15m
Graded Quiz15m
Practice Quiz10m
Graded Quiz15m

Reviews

TOP REVIEWS FROM EXCEL BASICS FOR DATA ANALYSIS

View all reviews

Frequently Asked Questions

More questions? Visit the Learner Help Center.