Excel 2021: Mastering the fundamentals - online training

Present your data

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

Print and lay out your binders

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

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

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)

Excel 2021 - Level 2: Intermediate knowledge

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

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

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

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)

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

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

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

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

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

Analyzing library use

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

Budget monitoring

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

Solving a cost minimization problem

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

Additional modules

Excel 2021

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

Excel 2021 - Level 3: Advanced Knowledge

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