Master Excel basics: data entry, formulas, formatting, charts, and table management.
This training course helps you discover Excel, master data entry and simple formulas, format and lay out tables and charts, manage large tables by sorting and filtering, and summarize data using pivot tables.
Is it for you ?
Any user who is a beginner or has some basic knowledge and needs to master the fundamental commands of Excel.
Prerequisites
No prior knowledge of Excel is required. You only need to be familiar with the keyboard and mouse.
Training content
1 Excel (2024 and Microsoft 365 versions) – Level 1: Essential Knowledge
2 Discover Excel, complete a table
- Opening a workbook
- Environment overview
- Navigating a workbook
- Data entry
- Selecting cells
- Undoing and redoing an action
- Column width/row height
- Saving a workbook
- Editing cell content
- Creating a new workbook
3 Perform your first calculations
- Entering a calculation formula
- Sum and other simple calculations
- Percentage calculation
- Copying to adjacent cells
4 Present your data minimally
- Simple numeric formats
- Applying a theme
- Enhancing characters
- Font and font size
- Cell content alignment
- Cell color
- Cell borders
5 Print and page layout your workbooks
- Page layout
- Print preview and printing
- Page break
- Print area
- Header and footer
6 Become more efficient
- Using help
- Spell check
- Find and replace
- Display zoom
- Inserting/deleting rows, columns, and cells
- Moving cells
- Copying to non-adjacent cells
- Quick copy of cell formatting
- Merging cells
- Cell content orientation
- Cell styles
- Data sorting
7 Manage sheets and display your data
- Changing sheet name and tab color
- Inserting, deleting, and background of sheets
- Moving, copying, and hiding a sheet
- Splitting a window/Freezing rows and columns
- Repeating column/row titles on print
- Hiding elements in a sheet
- Grouping data as an outline
8 Excel (2024 and Microsoft 365 versions) – Level 2: Intermediate Knowledge
9 Evolve to more complex tables
- Displaying multiple lines in a cell
- Absolute reference in a formula
- Using paste options
- System date and date format
- Simple condition
- Custom format
- Conditional formatting
- Managing conditional formatting
- Cell range name
- Validation criterion
- Cell range in a function
10 Present your figures in charts
- Creating a chart
- Managing a chart
- Selecting chart elements
- Arranging, adding, and deleting elements
- Formatting chart elements
- Modifying chart text elements
- Legend and plotting area
- Printing and page layout of a chart
11 Enhance your chart presentation
- Modifying data labels
- Chart axes
- Managing series
- Specific options for different chart types
- Managing chart templates
- Creating a Map chart
- Creating sparkline charts
- Managing sparkline charts
12 Enhance your tables
- Creating graphic objects
- Selecting and deleting objects
- Copying and moving objects
- Resizing an object
- Modifying a text box
- Modifying a shape
- Formatting objects
- Inserting an image
- Managing images
- Rotating and aligning objects
- Layering and grouping objects
13 Leverage your data list tables
- Calculating subtotals
- Creating and managing a data table
- Presenting and sorting data in a data table
- Adding calculations to a data table
- Filtering data
- Filtering with slicers
- Text, date, and numeric filters
- Removing duplicates
- Data sorting and filtering functions
14 Create and use PivotTables and PivotCharts
- Creating a PivotTable
- Modifying PivotTable fields and labels
- Adding calculations and managing totals in a PivotTable
- Modifying the source of a PivotTable
- Selecting, copying, moving, and deleting in a PivotTable
- Layout and printing of a PivotTable
- Formatting a PivotTable
- Filtering a PivotTable
- Filtering a PivotTable using slicers
- Creating a PivotTable based on multiple tables
- Adding calculated data to a PivotTable
- Grouping data
- Creating a PivotChart
15 Copilot for Excel Microsoft 365 – Use Cases and Best Practices
16 Discover Copilot
- What is Copilot?
- Access methods for Copilot
- Copilot and data privacy
- Copilot on the Web
- Copilot in Bing
- Copilot in Microsoft Edge
- Copilot for Microsoft 365
- Copilot Pages
17 Copilot for Excel
- Getting started with Copilot for Excel
- Creating formulas
- Analyzing data
- Visualizing data
18 Write effective prompts
- Adopt best practices
- Adapt prompts to your needs
- Structure your prompts
19 Complementary book
20 This module offers the consultation of digital course material.
Excel (2024 and Microsoft 365 versions)
21 This module offers an interactive training course composed of 37 training videos and 37 practice exercises.
Excel 2021 – Level 3: Advanced Knowledge
See more
📌 Practical information
100% online training. Accessible anytime from anywhere for one year. If you have any questions about registration, the language of instruction, or the cancellation terms, please consult our FAQ
Trainers
Upcoming information