Excel 2021: Advanced features - online training

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 chart
• Creating sparkline charts
• Managing sparkline charts

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 pivot table based on

Excel 2021 - Level 3: Advanced Knowledge

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

Gain in efficiency

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

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

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

Share in total security

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

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

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

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 provides access to a digital course material.

Excel 2021 - Level 1: Essential knowledge

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