IBM

Excel Basics for Data Analysis

369,046 already enrolled

Gain insight into a topic and learn the fundamentals.
4.8

(8,104 reviews)

Beginner level

Recommended experience

Flexible schedule
Approx. 11 hours
Learn at your own pace
96%
Most learners liked this course
Gain insight into a topic and learn the fundamentals.
4.8

(8,104 reviews)

Beginner level

Recommended experience

Flexible schedule
Approx. 11 hours
Learn at your own pace
96%
Most learners liked this course

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

Taught in English

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 videos1 reading2 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 quizzes3 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,694 ratings)
Sandip Saha Joy
IBM
5 Courses450,603 learners
Steve Ryan
IBM
12 Courses462,290 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 8104

4.8

8,104 reviews

  • 5 stars

    80.36%

  • 4 stars

    16.44%

  • 3 stars

    2.12%

  • 2 stars

    0.47%

  • 1 star

    0.58%

TH
5

Reviewed on Dec 23, 2021

SB
5

Reviewed on Oct 13, 2022

MW
5

Reviewed on Jul 23, 2023

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