Save

Introduction to Data Analysis Using Excel

This course is part of a Specialization (series of courses) called Business Statistics and Analysis.

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. 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. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.

To successfully complete course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later.
________________________________________
WEEK 1
Module 1: Introduction to Spreadsheets
In this module, you will be introduced to the use of Excel spreadsheets and various basic data functions of Excel.

Topics covered include:
• Reading data into Excel using various formats
• Basic functions in Excel, arithmetic as well as various logical functions
• Formatting rows and columns
• Using formulas in Excel and their copy and paste using absolute and relative referencing
________________________________________
WEEK 2
Module 2: Spreadsheet Functions to Organize Data
This module introduces various Excel functions to organize and query data. Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel.

Topics covered include:
• IF and the nested IF functions
• VLOOKUP and HLOOKUP
• The RANDBETWEEN function
________________________________________
WEEK 3
Module 3: Introduction to Filtering, Pivot Tables, and Charts
This module introduces various data filtering capabilities of Excel. You’ll learn how to set filters in data to selectively access data. A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel.

Topics covered include:
• VLOOKUP across worksheets
• Data filtering in Excel
• Use of Pivot tables with categorical as well as numerical data
• Introduction to the charting capability of Excel
________________________________________
WEEK 4
Module 4: Advanced Graphing and Charting
This module explores various advanced graphing and charting techniques available in Excel. Starting with various line, bar and pie charts we introduce pivot charts, scatter plots and histograms. You will get to understand these various charts and get to build them on your own.

Topics covered include
• Line, Bar and Pie charts
• Pivot charts
• Scatter plots
• Histograms

Get Details Enroll Now

OpenCourser is an affiliate partner of Coursera.

Coursera

&

Rice University

Rating 4.6 based on 423 ratings
Length 5 weeks
Effort 4 weeks of study, 1-3 hours/week
Starts May 21 (31 weeks ago)
Cost $79
From Rice University via Coursera
Instructor Sharad Borle
Free Limited Content
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Create an Alert

Not ready to take this course yet? Sign up for a one-time email reminder with a link to this course.

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

data analysis in 21 reviews

Although I wish some of the content were more challenging, the quiz did a good job for soliciting good understanding of the material Great course for advanced excel topics Very good basic Excel for data analysis course.

This course gave me a very basic understanding about excel.It started with basic level and went to advanced level gradually.The course will help me to do data analysis much better.

First step to Excel Data Analysis Excellent course and teacher!!!!

Good for Data Analyst Beginner Perfectly suited for beginner or those looking for thorough review of basic data analysis.

I learned a lot and everything was very well done Very By learning data analysis using explore one can easily learn the basics of MS-Excel First of all Question 2 on the Week 3 quiz is horseshit & while the instructors have not gotten back to me on that run-on paragraph of nonsense at least one other student seems to agree with me.

quality content and really make people get familiar with data analysis with excel easily!!

Great Course Cource is dedicated to those who are not familiar with Excel and provides a good overview on most commonly used Excel features for data analysis.

Excel has an infinite number of learning paths this one is fragmented to empower you and keep you on of the data analysis route.

easy to understand in 17 reviews

Very useful and easy to understand.

Awesome tutor and course Easy To understand.

Short, simple and comprehensive Very informative and easy to understand.

the course for the beginners is good.Its is easy to understand and learn.Lectures , videos and assignment are best.

The course was very useful & also the teaching style of the professor was very easy to understand.

Very easy to understand and follow.

very easy to understand and follow this is perfect course designed for excel beginners or intermediate learners.

Best Course, Easy to understand and grasp concept.

pivot tables in 10 reviews

Pivot tables and charts are very relevant for business analytics, so I think the skills learned can be applied immediately.

Overall good course, I could have used some additional work on charting and Pivot Tables.

A very well taught, comprehensive course on Excel, VLookups, Pivot Tables, Pivot Charts, etc, etc.

Great review on basic Excel tools and also goes into Pivot Tables and charts The course was smooth, interactive and very helpful This course helped reinforce some of the excel data analysis I learned during my MBA statistics class.

The most useful content for me was vlookup and pivot tables.

Great start....I have used basic Excel skills in the past but this class allow me to start using special V functions, pivot tables and charts, and histograms which I have never used.

The most useful tool I learned was the VLOOKUP function and pivot tables.

So I just used this course for learning Vlookup, Hlookup, and pivot tables.

very good course in 9 reviews

Very good course for someone who is not an experienced Excel user.

very good course with precise descriptions of all excel functions Excellent Course.

Very Good course to get better understanding on LOOKUP, IF functions and Charts VERY THANKS Excellent course It is realy raly good course.I learn lot in Excel.

Very good course, everything explained, not questions to add Great introductory Excel course.

A very good course; well structured and laid out and I learned a lot from it Could have included more material and introduced more functions.

Very good course for everyone.

Extremely engaging and practical course Very good course I found out I already knew alot of the beginning material in this course.

Very good course and instructor Good informational & well planned course The course was really helpful.

course for beginners in 6 reviews

Great course for beginners or those looking to brush up on their Excel skills.

Brilliant course for beginners.

Very informative course and will help one to enhance Excel skills A very good course for beginners.

good course Great course for Beginners and mid level.

Very useful but not necessarily a course for beginners.

Awesome course for beginners.

introduction to excel in 5 reviews

Thank you Very helpful for teaching basic excel skills with applications in data analytics It is really and introduction to Excel.

It provides a clear and basic introduction to Excel.

Thank you very much for this valuable experience The course is really helpful as it equips one to use basic and advanced functions of excel and explain concepts in clear details Excellent course content This is one of finest course in excel i came across Well organized introduction to Excel analysis.

not worth it to pay money for it Excellent introduction to Excel.

material is very important for anyone in industry Nice introduction to Excel for data analysis.

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).

WHOLESALE DATA ENTRY COORDINATOR $28k

Data Architects $72k

Clinical Data Specialist 3 $78k

Data Management Specialist 3 $78k

Data Management Study Coordinator Manager $88k

Systems Data Analyst $92k

BI Data Architect Manager $101k

Team Data Specialist Lead $105k

Data Consultant Lead $125k

Data Architect Expert $132k

Senior Supervisor Data Science Manager $135k

Enterprise Data Warehouse Architect $143k

Write a review

Your opinion matters. Tell us what you think.

Coursera

&

Rice University

Rating 4.6 based on 423 ratings
Length 5 weeks
Effort 4 weeks of study, 1-3 hours/week
Starts May 21 (31 weeks ago)
Cost $79
From Rice University via Coursera
Instructor Sharad Borle
Free Limited Content
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials