Discover Excel and master all its features. From the basics to advanced commands, this training course will enable you to progress in all areas of the software (data entry and formatting, simple and advanced calculation formulas, graphics, long table management, pivot tables, advanced tools...).
Duration
14.5 hours
Regular fee
$199
Objectives of the training
At the end of the course, participants will be able to use the fundamental and advanced functions of Excel 2021.Targeted audience
Any user wishing to discover or revise the basics of Excel and tackle advanced functions.Prerequisite
No knowledge of Excel is required. Minimal practice with the software can help you progress more quickly.Trainers
Upcoming information
Course architecture
Essential modules
Excel 2021 - Level 1: Essential knowledge
This module offers interactive training with 45 training videos, 45 practice exercises and 5 additional information points.
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
- 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
Perform your first calculations
- Entering a calculation formula
- Sum and other simple calculations
- Calculating a percentage
- Copy to adjacent cells
- Entering a calculation formula
- Sum and other simple calculations
- Calculating a percentage
- Copy to adjacent cells
Present your data
- Simple numerical formats
- Applying a theme
- Character enhancement
- Font and font size
- Cell content alignment
- Cell color
- Cell borders
- 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
- 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
- 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
- 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
Excel 2021 - Level 2: Intermediate knowledge
This module offers interactive training with 61 training videos, 61 practice exercises and 5 additional information points.
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
- 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
- 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
- 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
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
- 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
- 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
- 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
Excel 2021 - Level 3: Advanced Knowledge
This module offers interactive training with 39 training videos, 39 practice exercises and 5 additional information points.
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
- 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
- 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
- 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
- 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
- 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
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.
Digital book: This module lets you consult a digital course material.
Training Notes
Complete online self-paced training. Accessible anytime from anywhere. One year access to the training and the digital book.
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
14.5 hours
Regular fee
$199
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote