About this Course

970,036 recent views

Learner Career Outcomes

48%

started a new career after completing these courses

41%

got a tangible career benefit from this course

10%

got a pay increase or promotion

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.

Approx. 20 hours to complete

English

Subtitles: English, Spanish, Arabic

Skills you will gain

Lookup TableData AnalysisMicrosoft ExcelPivot Table

Learner Career Outcomes

48%

started a new career after completing these courses

41%

got a tangible career benefit from this course

10%

got a pay increase or promotion

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.

Approx. 20 hours to complete

English

Subtitles: English, Spanish, Arabic

Offered by

Rice University logo

Rice University

Syllabus - What you will learn from this course

Content RatingThumbs Up92%(15,250 ratings)Info
Week
1

Week 1

5 hours to complete

Introduction to Spreadsheets

5 hours to complete
8 videos (Total 40 min), 5 readings, 7 quizzes
8 videos
Reading Data into Excel7m
Basic Data Manipulation in Excel5m
Arithmetic Manipulation in Excel4m
Basic Functions in Excel6m
Functions Using Absolute and Relative References6m
Functions Explained7m
Week 1 Recap51s
5 readings
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 Excel30m
Basic Data Manipulation in Excel30m
Arithmetic Manipulation in Excel30m
Basic Functions in Excel30m
Functions Using Absolute and Relative References30m
Functions Explained30m
Introduction to Spreadsheets1h
Week
2

Week 2

5 hours to complete

Spreadsheet Functions to Organize Data

5 hours to complete
8 videos (Total 44 min)
8 videos
The “IF” Command in Excel Using Numerical Data3m
The "Nested IF" Command in Excel7m
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 Excel30m
The “IF” Command in Excel Using Numerical Data30m
The "Nested IF" Command in Excel30m
The "VLOOKUP" Function in Excel30m
Another "VLOOKUP" Example30m
The "HLOOKUP" Function in Excel30m
Professor 'Know-it-all' Needs Help!30m
Spreadsheet Functions to Organize Data1h
Week
3

Week 3

4 hours to complete

Introduction to Filtering, Pivot Tables, and Charts

4 hours to complete
7 videos (Total 42 min)
7 videos
Data Filtering in Excel6m
Use of Pivot Tables in Excel6m
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 Worksheets30m
Data Filtering in Excel30m
Use of Pivot Tables in Excel30m
More Pivot Table Options30m
Application of Pivot Tables to Numeric Data4m
Introduction to Charts in Excel30m
Introduction to Filtering, Pivot Tables, and Charts1h
Week
4

Week 4

5 hours to complete

Advanced Graphing and Charting

5 hours to complete
7 videos (Total 41 min), 1 reading, 7 quizzes
7 videos
Bar Graphs and Pie Charts9m
Pivot Charts5m
Scatter Plots7m
Histograms Part 14m
Histograms Part 27m
Week 4 Recap46s
1 reading
End-of-Course Survey10m
7 practice exercises
Line Graphs30m
Bar Graphs and Pie Charts30m
Pivot Charts30m
Scatter Plots30m
Histograms Part 130m
Histograms Part 230m
Advanced Graphing and Charting1h

About the Business Statistics and Analysis Specialization

The Business Statistics and Analysis Specialization is designed to equip you with a basic understanding of business data analysis tools and techniques. You’ll master essential spreadsheet functions, build descriptive business data measures, and develop your aptitude for data modeling. You’ll also explore basic probability concepts, including measuring and modeling uncertainty, and you’ll use various data distributions, along with the Linear Regression Model, to analyze and inform business decisions. The Specialization culminates with a Capstone Project in which you’ll apply the skills and knowledge you’ve gained to an actual business problem. To successfully complete all course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later. To see an overview video for this Specialization, click here!...
Business Statistics and Analysis

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

More questions? Visit the Learner Help Center.