Course

Introduction to Data Analysis in Excel

This interactive course will help you to take your first steps in your data analysis learning journey. It will teach you the foundations of working will data, from understanding how data can benefit decision-making to understanding the data analysis process. By the end, you’ll be able to apply the core concepts of data analysis with real-world data.

Enroll for free

Part of the Excel, and Business Analyst (Power BI) paths.

4.8 (359 reviews)

30,795 learners enrolled in this course.

Beginner friendly
4 hours
Self paced
3 lessons

“I can’t believe how easily and clearly complex material is presented on Dataquest. Even beginners can learn on Dataquest.”

Viktoria Jorayeva

Consultant, Business Analyst @Fractal

Introduction to Data Analysis in Excel

Enroll For Free

Course overview

This course will help you gain the practical skills in Excel to perform data analysis and visualization — and ultimately help organizations make more-informed decisions. We designed it for aspiring data professionals with little experience or learners who use basic Excel in their daily jobs and want to enhance their skills.

Best of all, you’ll learn by doing — you’ll practice and get feedback directly in the browser.

Key skills

Defining, Categorizing, and evaluating data
Identifying ways data use in everyday business
Organizing data for data analysis
Defining the key steps of the data analysis process

Course outline

Introduction to Data Analysis in Excel [3 lessons]

Defining Data 1h

Lesson Objectives

Define data and variable
Distinguish between qualitative and quantitative data
Read tabular data

How to Use Data 2h

Lesson Objectives

Convert data intro actionable insights
Employ data-driven decision-making
Interpret data from a dashboard

The Data Analysis Process 2h

Lesson Objectives

Identify and frame a data question
Describe the steps of the data analysis process
Answer data questions using Excel

The Dataquest guarantee

Dataquest has helped thousands of people start new careers in data. If you put in the work and follow our path, you’ll master data skills and grow your career.

We believe so strongly in our paths that we offer a full satisfaction guarantee. If you complete a career path on Dataquest and aren’t satisfied with your outcome, we’ll give you a refund.

Master skills faster with Dataquest

Go from zero to job-ready

Learn exactly what you need to achieve your goal. Don’t waste time on unrelated lessons.

Build your project portfolio

Build confidence with our in-depth projects, and show off your data skills.

Challenge yourself with exercises

Work with real data from day one with interactive lessons and hands-on exercises.

Showcase your path certification

Impress employers by completing a capstone project and certifying it with an expert review.

Grow your career with
Dataquest.

98%

of learners recommend

Dataquest for career advancement

4.85

Dataquest rating

SwitchUp Best Bootcamps

$30k

Average salary boost

for learners who complete a path

Aaron Melton

Business Analyst at Aditi Consulting

“Dataquest starts at the most basic level, so a beginner can understand the concepts. I tried learning to code before, using Codecademy and Coursera. I struggled because I had no background in coding, and I was spending a lot of time Googling. Dataquest helped me actually learn.”

Jessica Ko

Machine Learning Engineer at Twitter

“I liked the interactive environment on Dataquest. The material was clear and well organized. I spent more time practicing then watching videos and it made me want to keep learning.”

Victoria E. Guzik

Associate Data Scientist at Callisto Media

“I really love learning on Dataquest. I looked into a couple of other options and I found that they were much too handhold-y and fill in the blank relative to Dataquest’s method. The projects on Dataquest were key to getting my job. I doubled my income!”