The web browser you are using is out of date, please upgrade.

  • Skip to content
  • Select language
  • Skip to search

OpenClassrooms becomes an accredited US university.

Discover what this means for you
OpenClassrooms.comOpenClassrooms.com
Our training programs
Online and at your own pace.
Compare our training programs
Learn a profession
Degree programs
Acquire in-demand skills with real-world projects and one-to-one mentoring.
Discover a topic
Free-access courses
Broaden your knowledge with 500+ regularly updated courses
For employers
Train and recruit talents through an all-in-one space.
Discover our solution
Upskilling & reskilling
Enhance your knowledge
with a library of 500+ self-guided courses - SPARK
Promote hard and soft skills
with mentor-led intensive programs - BOOST
Support career progression
with mentor-led training programs - PIVOT
Master the Fundamentals of Excel

Table of contents

  • Part 1

    Use Basic Excel Functionalities

    • 1

      Get the Most out of This Course

    • 2

      Take Your First Steps in Excel

    • 3

      Create Your First File

    • 4

      Enter and Modify Data

    • 5

      Copy Data

    • 6

      Create and Copy Formulas

    • 7

      Practice Entering Data in Excel

    • Quiz: Use Basic Excel Functionalities

  • Part 2

    Work With Your Excel File

    • 1

      Manipulate Rows and Columns

    • 2

      Work With Tabs

    • 3

      Set up the Page layout

    • 4

      Use Conditional Formatting

    • 5

      Use Filtering and Sorting Features

    • 6

      Practice Setting up Your Page Layout in Excel

    • Quiz: Set up a Page Layout in Excel

  • Part 3

    Manipulate Data in Excel

    • 1

      Perform Calculations Using Functions

    • 2

      Allow or Restrict Types of Data

    • 3

      Create Pivot Tables

    • 4

      Create Charts

    • 5

      Practice Processing Data in Excel

    • Quiz: Manipulate Data in Excel

Manipulate Data in Excel

Test your knowledge!

Create an account for free or log in to take this course and complete this quiz.
Create an accountLog in

Question 1

Question 2