Save for later

Introduction to Data Analysis Using Excel

This course is a part of Business Statistics and Analysis, a 5-course Specialization series from Coursera.

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 and Enroll Now

OpenCourser is an affiliate partner of Coursera.

Set Reminder Save for later

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Coursera

&

Rice University

Rating 4.6 based on 614 ratings
Length 5 weeks
Effort 4 weeks of study, 1-3 hours/week
Starts Jul 15 (4 days ago)
Cost $79
From Rice University via Coursera
Instructor Sharad Borle
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

According to other learners, here's what you need to know

easy to understand in 23 reviews

Very useful and easy to understand.

Awesome tutor and course 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.

Read more

pivot tables in 13 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.

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.

Read more

data analysis using in 12 reviews

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.

It's an amazing course for people who are looking to get an insight of data analysis using Excel.

Please add more manipulations within basic data analysis using excel course It was very nice to get my skills expanded.

I enjoyed it and would recommend it to my friends with similar knowledge level Good very helpful Very good course Great course to understand the basics of Excel A very good course to know about data analysis using excel.Nice examples given to understand various concepts THE best course I have pursued in a long time in terms of making hard to understand concepts easily comprehensible through a hands on approach and crisp, lucid lectures.

I would like thank you for the session.i just wanted to jot you a note of thanks to say how much i enjoyed your session on Data Analysis Using Excel.

Introduction to Data Analysis Using Excel is a fun fast paced course that will teach you practical knowledge in a short amount of time.

Thanks A lot it is very useful course Excellent course Good Course on introduction Data Analysis using Excel.

Read more

sharad borle in 7 reviews

A special thanks to the instructor Sharad Borle.

Sharad Borle explained Excel with precision and ease - highly recommended!

I thank Sharad Borle sir for explaining the course in an easy and perfect way.

Thanks a lot to all behind this course ( specially the course instructor Mr. Sharad Borle for his clear and to the point presentation) .

Fantastic teaching by Prof.Sharad Borle.

Many thanks to Professor Sharad Borle, Rice and Coursera!

Read more

familiar with in 6 reviews

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.

Course load is a little less if you're familiar with Excel before, otherwise learning while doing is really easy.

There is some help with navigation, but to be successful in this class it would be very helpful for a person to already be fairly familiar with the Excel ribbon and basic Excel navigation.

For someone who is very unfamiliar with Excel and Data Analysis, this course really help me to understand the concept of each functions which are useful for data analysis.

Read more

enjoyed this course in 5 reviews

I really enjoyed this course, and feel like I learnt a lot from taking it.

Thoroughly enjoyed this course.

Really enjoyed this course.

I enjoyed this course very much.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Event Specialist and Data Collection Specialist $40k

Data Steward/Analyst $52k

Sn Data Analyst $75k

LAN/WAN Data Analyst $84k

Mobile Data Analyst $92k

Analyst, Fixed Income Data Management Consultant $101k

Assistant Research and Data Analyst Consultant $104k

Vice Assistant President Data Scientist Development Program $106k

Deputy Data Management Specialist $127k

Big Data Analytics Platform Architect and Business Intelligence Leader $143k

Data warehouse & BI professional $175k

Data Warehouse Solutions Architect $192k

Write a review

Your opinion matters. Tell us what you think.

Coursera

&

Rice University

Rating 4.6 based on 614 ratings
Length 5 weeks
Effort 4 weeks of study, 1-3 hours/week
Starts Jul 15 (4 days ago)
Cost $79
From Rice University via Coursera
Instructor Sharad Borle
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Business
Tags Data Science Data Analysis Business Business Essentials

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now