Introduction to Data Analysis Using Excel

Name: Introduction to Data Analysis Using Excel
Rating: 5.0 (2 reviews)
Author: Rice University

Archived

Course

English

Subtitles available

4 h

(2 reviews2)

You can't access an archived course

Source

From www.coursera.org

Conditions

Self-paced
Free Access
Fee-based Certificate

More info

4 Sequences
Introductive Level
Subtitles in Arabic

You can't access an archived course

Their employees are learning daily with

Learn more

Course details

Syllabus

Week 1 - Introduction to Spreadsheets
Introduction to spreadsheets, reading data, manipulating data. Basic spreadsheet operations and functions.
Week 2 - Spreadsheet Functions to Organize Data
Introduction to some more useful functions such as the IF, nested IF, VLOOKUP and HLOOKUP functions in Excel.
Week 3 - Introduction to Filtering, Pivot Tables, and Charts
Introduction to the Data filtering capabilities of Excel, the construction of Pivot Tables to organize data and introduction to charts in Excel.
Week 4 - Advanced Graphing and Charting
Constructing various Line, Bar and Pie charts. Using the Pivot chart features of Excel. Understanding and constructing Histograms and Scatterplots.

Prerequisite

None.

Instructors

Sharad Borle
Associate Professor of Management
Jones Graduate School of Business

Editor

Rice University is a private American research university located in Houston, Texas. It is located in the city's Museum District and is adjacent to the Texas Medical Center. It was founded by William Marsh Rice (en) in 1891 as The William Marsh Rice Institute for the Advancement of Letters, Science, and Art, and was inaugurated in 1912 with Edgar Odell Lovett as its first president.

Platform

Coursera is a digital company offering massive open online course founded by computer teachers Andrew Ng and Daphne Koller Stanford University, located in Mountain View, California.

Coursera works with top universities and organizations to make some of their courses available online, and offers courses in many subjects, including: physics, engineering, humanities, medicine, biology, social sciences, mathematics, business, computer science, digital marketing, data science, and other subjects.