Skip to main content
HomeExcel

Course

Data Analysis in Excel

BeginnerSkill Level
4.7+
1,553 reviews
Updated 02/2025
Learn how to analyze data with PivotTables and intermediate logical functions before moving on to tools such as what-if analysis and forecasting.
Start Course for Free

Included withPremium or Teams

ExcelReporting3 hours9 videos28 Exercises2,250 XP92,949Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

Exploring PivotTables

You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables. Additionally, you’ll learn how to use keyboard shortcuts to speed up your workflow.

Intermediate Logical Functions

You’ll identify your ideal customer profile using logical functions and create targeted marketing strategies. You’ll explore the concept of customer segmentation and gain the skills to maximize customer success, increase revenue and boost business growth.

What-if Analysis

You’ll master the art of scenario analysis using Excel’s built-in What-If Analysis tool. You’ll understand how different variables can impact your sales, perform sensitivity analysis and use it to make informed predictions to stay ahead in dynamic business environments.

Forecasting

You will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders. You’ll leverage moving averages and trendlines to communicate your findings.

Prerequisites

Introduction to Excel
1

Exploring data with PivotTables

Start Chapter
2

Intermediate Logical Functions

Start Chapter
3

What-if analysis

Start Chapter
4

Forecasting

Start Chapter
Data Analysis in Excel
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll Now

Don’t just take our word for it

*4.7
from 1,553 reviews
81%
17%
2%
0%
0%
  • Noor
    1 minute

  • Roshi
    about 2 hours

  • Rhenaldo
    about 10 hours

  • Chris
    about 10 hours

  • Jacob
    about 16 hours

  • Med Amine
    about 17 hours

    This one's special, it provided info that I would've never figured out myself

Rhenaldo

Jacob

"This one's special, it provided info that I would've never figured out myself"

Med Amine

FAQs

Join over 17 million learners and start Data Analysis in Excel today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.