Excel 2021: Mastering the fundamentals - online training

1 Essential modules

Excel 2021 - Level 1: Essential knowledge

This module offers interactive training with 45 training videos, 45 practice exercises and 5 additional information points.

2 Discover Excel, complete a table

• Worth knowing: Discovering the spreadsheet
• Opening a workbook
• General environment
• Moving around a workbook
• What you need to know : Input aids
• Data entry
• What you need to know : Selecting, copying and moving
• Selecting and deleting cells
• Undoing and redoing an action
• Column width/row height
• To know : Saving files
• Saving a workbook
• Modifying cell contents
• Creating a new workbook

3 Perform your first calculations

• Entering a calculation formula
• Sum and other simple calculations
• Calculating a percentage
• Copy to adjacent cells

4 Present your data

• Simple numerical formats
• Applying a theme
• Character enhancement
• Font and font size
• Cell content alignment
• Cell color
• Cell borders

5 Print and lay out your binders

• Page layout
• Preview and print
• Page break
• Print area
• Good to know : Header and footer
• Header and footer

6 Become more efficient

• Using Excel Help
• Spell checking
• Search, replace
• Zoom display
• Inserting/deleting rows, columns and cells
• Moving cells
• Copy to non-adjacent cells
• Quick copy of cell layout
• Merge cells
• Orientation of cell contents
• Cell styles
• Data sorting

7 Manage sheets and data display

• Sheet name, tab color
• Insert, delete and background sheets
• Move, copy and hide sheets
• Freeze columns/rows on screen, window splitting
• Repeating column/line titles on printout
• Hiding sheet elements
• Grouping data as a map

Translated with DeepL.com (free version)

8 Excel 2021 - Level 2: Intermediate knowledge

This module offers interactive training with 61 training videos, 61 practice exercises and 5 additional information points.

9 Move on to more complex tables

• Display multiple rows in a cell
• Absolute reference in a formula
• Copy values, copy with link or transpose
• Worth knowing: Entering calculation functions
• System date and date format
• Simple condition
• Custom format
• Conditional formatting
• Managing conditional formatting
• Cell range name
• Validation criteria
• Cell range in a function

10 Present your figures on graphs

• Worth knowing: Graphs
• Creating and moving a graph
• Managing a graph
• Selecting chart elements
• Adding and deleting elements
• Formatting chart elements
• Modifying graph text elements
• Legend and plotting area
• Graph printing and layout

11 Enhance the presentation of your graphs

• Modifying data labels
• Data series and chart axes
• Managing series
• Chart type options
• Managing chart templates
• Creating a 2D Map chart
• Creating sparkline charts
• Managing sparkline charts

Translated with DeepL.com (free version)

12 Enhance your tables

• Creating graphic objects
• Select and delete objects
• Copying and moving objects
• Sizing a graphic object
• Modifying a text box
• Modifying a drawing
• Formatting drawing objects
• Inserting an image
• Image management
• Rotating and aligning objects
• Overlaying and grouping objects

13 Exploit your data list tables

• Worth knowing : Instant fill
• Calculating subtotals
• Creating and managing a data table
• Presenting and sorting data in a data table
• Adding calculations to a data table
• Automatic filters
• Custom filters
• Empty values and duplicates
• Worth knowing: The criteria zone
• Using a criteria area
• Filtering and copying lines by criteria area
• Statistics with criteria fields
• Data sorting and filtering functions

14 Create and use pivot tables and charts

• Worth knowing : Pivot tables and pivot charts
• Creating a pivot table
• Modifying and adding calculations to a pivot table
• Modifying the source of a pivot table
• Selecting, copying, moving and deleting pivot tables
• Structure and print a pivot table
• Formatting a pivot table
• Filtering a pivot table
• Filtering using segments
• Creating a low-level pivot table

15 Microsoft Office: use cases

Excel, Word or PowerPoint with a Microsoft 365 subscription

Video: This module features a 23-minute video.

• Office with or without a Microsoft 365 subscription: what are the differences?
• Creating and saving Office documents on OneDrive, SharePoint Online or Teams
• Edit Office documents from OneDrive, SharePoint or Teams
• Share Office documents with colleagues or people outside your organization
• Co-edit files

16 Excel 2021: use cases

Video: This module includes a 55-minute video.

Setting up a quality control system

• Case study presentation
• Setting up statistical formulas
• Preparing to set up the graph
• Setting up the control chart
• Improving the control chart
• Conclusion

17 Analyzing library use

• Case study
• Creating the Evolution of patronage graph
• Creating pivot tables
• Conclusion

18 Budget monitoring

• Case study
• Creating pivot tables
• Creating pivot charts
• Creating the dashboard
• Conclusion

19 Solving a cost minimization problem

• Case study
• Setting up formulas
• Solving the problem with the Solver
• Conclusion

20 Additional modules

Excel 2021

Digital book: This module allows you to consult a digital course material.

21 Excel 2021 - Level 3: Advanced Knowledge

This module offers interactive training with 42 training videos, 42 practice exercises and 5 additional information points.