Skip to content
Select language
Skip to search
OpenClassrooms.com
OpenClassrooms.com
Training programs
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
Apprenticeship
Apprenticeship
Online and at your own pace.
Students
Start an apprenticeship
Kick off a new career with our 100% online registered apprenticeship degrees, which offer a monthly salary and no fees.
Consult job opportunities
Access thousands of apprenticeship job opportunities across France all year round.
Employers
Hire apprentices
Access qualified candidates all year round, create a job posting with AI, or receive a tailored selection of top talent.
Finalize the hiring of a candidate
Found the perfect candidate? Share their details to proceed with the hiring process.
For employers
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
Recruitment
Foster talents
Access qualified candidates all year round, create a job offer with AI, or receive a tailored selection of top talent.
Finalize the hiring of a candidate
Found the perfect candidate? Share their details to proceed with the hiring process.
Get help
Master the Basics of Spreadsheets
Table of contents
Part 1
Edit a spreadsheet
1
Get the most out of this course
2
Find your way around a spreadsheet
3
Enter, copy, and reference data in your spreadsheet
4
Speed up data entry with autocompletion tools
Quiz: Editing a spreadsheet
Part 2
Format data in a spreadsheet
1
Increase readability by formatting the contents of cells
2
Create professional looking spreadsheet layouts with additional formatting
3
Highlight information automatically with conditional formatting
Quiz: Formatting a spreadsheet
Part 3
Analyze data in a spreadsheet
1
Filter and sort data to find information quickly
2
Make calculations in your spreadsheet with functions and formulas
3
Check if your data matches certain conditions with the IF function
4
Match up data from separate datasets with the VLOOKUP function
5
Set up data validation to avoid errors in data entry
Quiz: Analyzing data
Part 4
Visualize data in a spreadsheet
1
Summarize data quickly with pivot tables
2
Display information visually with charts
Quiz: Visualizing data
Table of contents
Part 1
Edit a spreadsheet
1
Get the most out of this course
2
Find your way around a spreadsheet
3
Enter, copy, and reference data in your spreadsheet
4
Speed up data entry with autocompletion tools
Quiz: Editing a spreadsheet
Part 2
Format data in a spreadsheet
1
Increase readability by formatting the contents of cells
2
Create professional looking spreadsheet layouts with additional formatting
3
Highlight information automatically with conditional formatting
Quiz: Formatting a spreadsheet
Part 3
Analyze data in a spreadsheet
1
Filter and sort data to find information quickly
2
Make calculations in your spreadsheet with functions and formulas
3
Check if your data matches certain conditions with the IF function
4
Match up data from separate datasets with the VLOOKUP function
5
Set up data validation to avoid errors in data entry
Quiz: Analyzing data
Part 4
Visualize data in a spreadsheet
1
Summarize data quickly with pivot tables
2
Display information visually with charts
Quiz: Visualizing data
Formatting a spreadsheet
Question 1
Question 2