Rice University - Introduction to Data Analysis Using Excel

4.5 /5

(13 Ratings)

Offered byCoursera

Introduction to Data Analysis Using Excel
at
Coursera
Overview

Gain a comprehensive overview of the Data Analysis principles and concepts

Duration	19 hours
Mode of learning	Online
Credential	Certificate

Introduction to Data Analysis Using Excel
at
Coursera
Highlights

Earn a certificate of completion from Rice University

Introduction to Data Analysis Using Excel
at
Coursera
Course details

Skills you will learn

Excel Vlookup Operations Statistics Data analysis

What are the course deliverables?

Line, Bar and Pie charts
Pivot charts
Scatter plots
Histograms

More about this course

This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later
The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills
The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel

Introduction to Data Analysis Using Excel
at
Coursera
Curriculum

Introduction to Spreadsheets

Meet the Professor

Reading Data into Excel

Basic Data Manipulation in Excel

Arithmetic Manipulation in Excel

Basic Functions in Excel

Functions Using Absolute and Relative References

Functions Explained

Week 1 Recap

Spreadsheet Functions to Organize Data

The “IF” Command in Excel

The “IF” Command in Excel Using Numerical Data

The "Nested IF" Command in Excel

The "VLOOKUP" Function in Excel

Another "VLOOKUP" Example

The "HLOOKUP" Function in Excel

Professor 'Know-it-all' Needs Help!

Week 2 Recap

Introduction to Filtering, Pivot Tables, and Charts

Using the “VLOOKUP” Function Across Worksheets

Data Filtering in Excel

Use of Pivot Tables in Excel

More Pivot Table Options

Application of Pivot Tables to Numeric Data

Introduction to Charts in Excel

Week 3 Recap

Advanced Graphing and Charting

Line Graphs

Bar Graphs and Pie Charts

Pivot Charts

Scatter Plots

Histograms Part

Week 4 Recap

Introduction to Data Analysis Using Excel
at
Coursera
Faculty details

Sharad Borle

Sharad is a faculty of Management at the Jones Graduate School of Business at Rice University, Houston, Texas. He holds a Ph.D. from Carnegie Mellon University, and his expertise lies in Business statistics and data analytics.