IBM

Excel Basics for Data Analysis

This course is part of multiple programs.

Taught in English

Some content may not be translated

Sandip Saha Joy
Steve Ryan

Instructors: Sandip Saha Joy

291,697 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.8

(7,246 reviews)

|

96%

Beginner level

Recommended experience

11 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll learn

  • Display working knowledge of Excel for Data Analysis.

  • Perform basic spreadsheet tasks including navigation, data entry, and using formulas.

  • Employ data quality techniques to import and clean data in Excel.

  • Analyze data in spreadsheets by using filter, sort, look-up functions, as well as pivot tables.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

12 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.8

(7,246 reviews)

|

96%

Beginner level

Recommended experience

11 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is available as part of
When you enroll in this course, you'll also be asked to select a specific program.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 5 modules in this course

In this module, you will learn about the fundamentals of spreadsheet applications, and you will be introduced to the Excel interface and learn how to navigate your way around a worksheet and workbook.

What's included

5 videos2 readings2 quizzes3 plugins

In this module you will learn how to perform basic spreadsheet tasks, such as viewing, entering and editing data, and moving, copying and filling data. In addition, you will learn about the fundamentals of formulas, and learn about the most common functions used by a data analyst. Finally, you will learn how to reference data in formulas.

What's included

5 videos1 reading2 quizzes2 plugins

In this module, you will learn about the importance of data quality, and you will learn how to import file data in to Excel. You will also learn about the fundamentals of data privacy. In addition, you will learn how to remove duplicate and inaccurate data, and how to remove empty rows in your data. Finally, you will learn how to deal with inconsistencies in your data and how to use the Flash Fill and Text to Columns features to help you manipulate and standardize your data.

What's included

8 videos2 readings4 quizzes1 plugin

In this module, you will learn about the fundamentals of analyzing data using a spreadsheet, and learn how to filter and sort data. You will also learn how to use some of the most useful functions for a data analyst, and how to use the VLOOKUP and HLOOKUP reference functions. In addition, you will learn how to create pivot tables in Excel, and use several pivot table features.

What's included

8 videos2 readings4 quizzes2 plugins

Great! You have now completed all four modules of this course. In this final module, you will be introduced to a hands-on lab where you will complete a graded assignment for cleaning and preparing data, and then analyzing data using an Excel spreadsheet. This final assignment will be graded by your peers.

What's included

2 readings1 peer review2 plugins

Instructors

Instructor ratings
4.7 (2,461 ratings)
Sandip Saha Joy
IBM
5 Courses360,162 learners
Steve Ryan
IBM
11 Courses355,571 learners

Offered by

IBM

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 7246

4.8

7,246 reviews

  • 5 stars

    80.47%

  • 4 stars

    16.41%

  • 3 stars

    2.10%

  • 2 stars

    0.42%

  • 1 star

    0.59%

SB
5

Reviewed on Oct 13, 2022

TH
5

Reviewed on Dec 23, 2021

FK
5

Reviewed on May 24, 2022

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions