Skip to main content
HomeExcel

Data Analysis in Excel

4.4+
25 reviews
Beginner

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
3 hours9 videos28 exercises62,400 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

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.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Excel Fundamentals

Go To Track
  1. 1

    Exploring data with PivotTables

    Free

    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.

    Play Chapter Now
    Introduction to data analysis
    50 xp
    Which steps should I take?
    100 xp
    Exploratory data analysis in PivotTables
    50 xp
    Getting started with PivotTables
    100 xp
    Calculated fields in PivotTables
    100 xp
    Custom grouping in PivotTables
    100 xp
    Slicing data in PivotTables
    100 xp
  2. 2

    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. You’ll utilize functions such as Nested IFs, SWITCH, and COUNTIFS.

    Play Chapter Now
    Diving deeper with logical functions
    50 xp
    IF versus SWITCH
    100 xp
    Intermediate logical functions in Excel
    50 xp
    Swapping values with SWITCH
    100 xp
    Nesting logical functions
    100 xp
    Using COUNTIF and SUMIF
    100 xp
    COUNTIFS and SUMIFS
    100 xp
  3. 3

    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.

    Play Chapter Now
    What if...
    50 xp
    What if this or that?
    50 xp
    What-if analysis in Excel
    50 xp
    Manual scenario creation
    100 xp
    Using Goal Seek
    100 xp
    What-if analysis with Scenario Manager
    100 xp
    Sensitivity analysis with Data Tables
    100 xp
  4. 4

    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.

    Play Chapter Now
    Forecasting
    50 xp
    The truth about forecasting
    50 xp
    Forecasting techniques in Excel
    50 xp
    Moving averages
    100 xp
    Trendline forecasts
    100 xp
    Forecast Sheet
    100 xp
    Congratulations!
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Excel Fundamentals

Go To Track

datasets

Exercises and DatasetsExcel Formula Translations

collaborators

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Jess Ahmet

prerequisites

Introduction to Excel
Nick Edwards HeadshotNick Edwards

Analyst at Roofstock

Nick Edwards is an Analyst at Roofstock, a PropTech startup, where he uses data and BI tools to unlock the full strength of financial analysis. With over seven years of experience in finance, he realized honing data science skills would greatly benefit his career and believes it will for you, too!
See More

Don’t just take our word for it

*4.4
from 25 reviews
60%
28%
8%
4%
0%
Sort by
  • Khin C.
    11 days

    I really enjoyed this course and found it highly beneficial. The explanations were clear, and the practical examples helped me understand the material well. I feel confident about applying what I learned. I am very satisfied with the experience and would recommend this course to others!

  • fareedah i.
    about 1 month

    It just makes sense tbh. It’s easy to understand and comprehend

  • David M.
    3 months

    It was a great course and gave me great insight into using excel for analysis.

  • Ryan B.
    3 months

    L

  • Luis P.
    4 months

    Great content

"I really enjoyed this course and found it highly beneficial. The explanations were clear, and the practical examples helped me understand the material well. I feel confident about applying what I learned. I am very satisfied with the experience and would recommend this course to others!"

Khin C.

"It just makes sense tbh. It’s easy to understand and comprehend"

fareedah i.

"It was a great course and gave me great insight into using excel for analysis."

David M.

FAQs

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

Create Your Free Account

GoogleLinkedInFacebook

or

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