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.