Skip to main content
HomeExcelLearn Excel

Learn Excel

4.4+
79 reviews
Beginner

Master the Excel basics and learn to use this spreadsheet tool to conduct impactful analysis.

Start Course for Free
4 hours13 videos36 exercises81,323 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

Getting started with Excel

In this Excel course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to manage tables and apply calculations to your data to provide new insights

Learn Functions

You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. We’ll start your journey into understanding the full potential of Excel’s functions and leverage built-ins such as SUM, AVERAGE, COUNT, UPPER, LEFT, and more.

Visualizing data

We’ll finish this course by explaining the basics of using Excel to effectively communicate data through compelling visuals. You’ll explore the versatility of area, column, and pie charts to help tell a story to bring your analysis to life.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Excel Fundamentals

Go To Track
  1. 1

    Getting started with Excel

    Free

    In this chapter, you’ll learn how to navigate Excel and understand how best to work with tables. You will cover topics such as navigating the grid layout, importing data, manipulating data with tables, and creating basic formulas.

    Play Chapter Now
    Introduction to Excel
    50 xp
    The possibilities of Excel
    100 xp
    Navigating Excel
    50 xp
    Loading workbooks
    100 xp
    Working with data
    100 xp
    Creating first formula
    100 xp
    Working with tables
    50 xp
    Referencing cells
    50 xp
    Managing data with tables
    50 xp
    Working with structured cell references
    100 xp
    Filtering data
    100 xp
    LAST STEP INSTRUCTIONS Formatting tables
    100 xp
  2. 2

    Managing data and applying aggregate functions

    In this chapter, you’ll learn how to work with data in a tabular layout. You will cover topics such as creating named ranges, using subtotals to summarize groups of data, and applying data validation rules. Additionally, you’ll learn how to use aggregate functions in Excel to help summarize your data.

    Play Chapter Now
    Managing and formatting data
    50 xp
    Manage vs. Format
    100 xp
    Managing data
    50 xp
    Naming ranges
    100 xp
    Sub-totals
    100 xp
    Custom formats and validation
    100 xp
    Aggregate and Arithmetic operations
    50 xp
    Order of operations
    100 xp
    Understanding house prices
    50 xp
    Summarizing sales
    100 xp
    Calculating sales and profit
    100 xp
  3. 3

    Other functions and visualizing data

    Finally, in this chapter, we’ll finish by looking at the various functions available within Excel and learn how to start visualizing basic data. You will cover text, date and time, statistical functions, and learning to use built-in Excel features to visualize your data.

    Play Chapter Now
    Other functions in Excel
    50 xp
    To the left, to the left
    50 xp
    Applying formatting functions
    50 xp
    Product profiles
    100 xp
    Profit performance
    100 xp
    Formatting with functions
    100 xp
    Visualizing data in Excel
    50 xp
    Do you know the meaning of data viz?
    50 xp
    How to visualize data
    50 xp
    Visualizing categories
    100 xp
    Capturing parts of a whole
    100 xp
    Capturing a trend
    100 xp
    Congratulations!
    50 xp
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

Excel Fundamentals

Go To Track

datasets

Excel Function TranslationsExercises and Datasets

collaborators

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Carl Rosseel
Collaborator's avatar
Iason Prassides
Jess Ahmet HeadshotJess Ahmet

Content Developer at DataCamp

Jess is a Content Developer at DataCamp. Prior to joining DataCamp, she worked in various analyst roles within healthcare and most recently online gambling. She has a passion for education, data, and business which she has been able to combine in her role at DataCamp. Outside of work, you can often find her in front of a TV watching Soccer and Formula 1.
See More

Don’t just take our word for it

*4.4
from 79 reviews
68%
18%
10%
1%
3%
Sort by
  • Ross D.
    4 days

    Great course. Eventhough i’ve been using excel since 90’s, there is always something new to learn

  • Nathan J.
    7 days

    Learned a lot

  • Victor J.
    12 days

    It was a great introduction to a very important tool. Sometimes it was kind of difficult to understand what the instructor was saying.

  • rose i.
    18 days

    Comprehensive and detailed.

  • Ricardo M.
    about 1 month

    Excelent Experience

"Great course. Eventhough i’ve been using excel since 90’s, there is always something new to learn"

Ross D.

"Learned a lot"

Nathan J.

"It was a great introduction to a very important tool. Sometimes it was kind of difficult to understand what the instructor was saying."

Victor J.

FAQs

Join over 14 million learners and start Learn 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.