Excel 2021 : From the basics to advanced training - online training

1 Essential modules

2 Excel 2021 - Level 1: Essential knowledge

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

3 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

4 Perform your first calculations

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

5 Present your data

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

6 Print and lay out your binders

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

7 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

8 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

9 Excel 2021 - Level 2: Intermediate knowledge

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

10 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

11 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

12 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

13 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

14 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

15 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

16 Excel 2021 - Level 3: Advanced Knowledge

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

17 Gain in efficiency

• Data conversion
• Creating data series
• Customized views
• Cell annotation
• Error checking
• Formula evaluation
• Spy window

18 Use advanced calculation functions

• Look-up table and search functions
• Text functions
• Time calculations
• Date calculations
• AND, OR, NOT conditions
• Nested conditions
• Conditional functions
• Matrix formulas
• Copy calculations
• Consolidation
• Financial functions
• Double entry table

19 Discover unsuspected functions

• Target value
• The solver
• Scenario management
• Hypertext links
• Worth knowing : Styles and templates
• Creating and customizing a theme
• Creating and using a template
• What you need to know: Importing, exporting and Excel interoperability
• Modifying and deleting a template
• Excel data distribution: PDF, XPS, e-mail and Web page
• Converting Excel files
• Importing data
• Updating and managing imported data
• Workbook properties

20 Share in total security

• Binder protection
• Cell protection
• Share a workbook
• Finalize a workbook
• Creating a form
• Protecting and using a form

21 Find out more

• Macro commands
• File versioning and recovery
• What you need to know : Ribbon customization
• Good to know : Spreadsheet best practices
• Did you know? Collaborating on a workbook

22 Microsoft Office: use cases

Excel, Word or PowerPoint with a Microsoft 365 subscription

Video: This module includes 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

23 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

24 The add-in module

Excel 2021

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