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
The add-in module
Excel 2021
Digital book: This module lets you consult a digital course material.