152,278 recent views

#### 100% online

Start instantly and learn at your own schedule.

Reset deadlines in accordance to your schedule.

#### Approx. 12 hours to complete

Suggested: 4 weeks of study, 1-3 hours/week...

#### English

Subtitles: English, Spanish, Arabic

### Skills you will gain

Lookup TableData AnalysisMicrosoft ExcelPivot Table

#### 100% online

Start instantly and learn at your own schedule.

Reset deadlines in accordance to your schedule.

#### Approx. 12 hours to complete

Suggested: 4 weeks of study, 1-3 hours/week...

#### English

Subtitles: English, Spanish, Arabic

### Syllabus - What you will learn from this course

Week
1
3 hours to complete

## Introduction to Spreadsheets

8 videos (Total 40 min), 5 readings, 7 quizzes
8 videos
Arithmetic Manipulation in Excel4m
Basic Functions in Excel6m
Functions Using Absolute and Relative References6m
Functions Explained7m
Week 1 Recap51s
Course FAQs10m
Pre-Course Survey10m
Store Sales (Comma delimited).txt10m
Store Sales (Fixed width).txt10m
Stores Sales (Tab delimited Text).txt10m
7 practice exercises
Reading Data into Excel4m
Basic Data Manipulation in Excel4m
Arithmetic Manipulation in Excel4m
Basic Functions in Excel4m
Functions Using Absolute and Relative References4m
Functions Explained4m
Week
2
2 hours to complete

## Spreadsheet Functions to Organize Data

8 videos (Total 44 min), 8 quizzes
8 videos
The "VLOOKUP" Function in Excel8m
Another "VLOOKUP" Example6m
The "HLOOKUP" Function in Excel4m
Professor 'Know-it-all' Needs Help!4m
Week 2 Recap40s
8 practice exercises
The "IF" Command in Excel4m
The “IF” Command in Excel Using Numerical Data4m
The "Nested IF" Command in Excel4m
The "VLOOKUP" Function in Excel4m
Another "VLOOKUP" Example4m
The "HLOOKUP" Function in Excel4m
Professor 'Know-it-all' Needs Help!4m
Spreadsheet Functions to Organize Data1h
Week
3
2 hours to complete

## Introduction to Filtering, Pivot Tables, and Charts

7 videos (Total 42 min), 7 quizzes
7 videos
More Pivot Table Options5m
Application of Pivot Tables to Numeric Data8m
Introduction to Charts in Excel8m
Week 3 Recap52s
7 practice exercises
Using the “VLOOKUP” Function Across Worksheets4m
Data Filtering in Excel4m
Use of Pivot Tables in Excel4m
More Pivot Table Options4m
Application of Pivot Tables to Numeric Data4m
Introduction to Charts in Excel4m
Introduction to Filtering, Pivot Tables, and Charts1h
Week
4
2 hours to complete

## Advanced Graphing and Charting

7 videos (Total 41 min), 1 reading, 7 quizzes
7 videos
Scatter Plots7m
Histograms Part 14m
Histograms Part 27m
Week 4 Recap46s
End-of-Course Survey10m
7 practice exercises
Line Graphs4m
Bar Graphs and Pie Charts4m
Pivot Charts4m
Scatter Plots4m
Histograms Part 12m
Histograms Part 24m
Advanced Graphing and Charting1h
4.7
682 Reviews

## 53%

started a new career after completing these courses

## 43%

got a tangible career benefit from this course

### Top reviews from Introduction to Data Analysis Using Excel

By SSApr 28th 2017

good course gives a basic foundation for data analytics ! Excellent for beginners who have no idea how to use excel for want to learn systematically excel files given at every lecture are very useful.

By LCMay 18th 2018

Excellent class, well-written and presented with real-world examples that are challenging but not impossible to complete if you follow the small quizzes and stay on top of the deadlines. Great job!

## Instructor

Associate Professor of Management

## About Rice University

Rice University is consistently ranked among the top 20 universities in the U.S. and the top 100 in the world. Rice has highly respected schools of Architecture, Business, Continuing Studies, Engineering, Humanities, Music, Natural Sciences and Social Sciences and is home to the Baker Institute for Public Policy....