This training course is intended for users who already master the essential basic commands and want to move on to Excel’s advanced features. It will help you discover or strengthen your knowledge of formulas, calculation tools, pivot tables, as well as workbook protection and sharing.
Objectives
By the end of the training course, the participant will be able to use Excel’s advanced features, including formulas, calculation tools, pivot tables, workbook protection, and sharing.
Is it for you ?
Any user who has mastered the essential basic commands and wishes to discover or deepen their knowledge of advanced features.
Prerequisite
The basic commands must be mastered in order to access Excel's advanced features without difficulty.
Content
Excel (2024 and Microsoft 365 versions) – Level 2: Intermediate Knowledge
Evolve to more complex tables
- Displaying multiple lines in a cell
- Absolute reference in a formula
- Using paste options
- System date and date format
- Simple condition
- Custom format
- Conditional formatting
- Managing conditional formatting
- Cell range name
- Validation criterion
- Cell range in a function
Present your figures in charts
- Creating a chart
- Managing a chart
- Selecting chart elements
- Arranging, adding, and deleting elements
- Formatting chart elements
- Modifying chart text elements
- Legend and plotting area
- Printing and page layout of a chart
See more + / -
Enhance your chart presentation
- Modifying data labels
- Chart axes
- Managing series
- Specific options for different chart types
- Managing chart templates
- Creating a Map chart
- Creating sparkline charts
- Managing sparkline charts
Enhance your tables
- Creating graphic objects
- Selecting and deleting objects
- Copying and moving objects
- Resizing an object
- Modifying a text box
- Modifying a shape
- Formatting objects
- Inserting an image
- Managing images
- Rotating and aligning objects
- Layering and grouping objects
Leverage your data list tables
- Calculating subtotals
- Creating and managing a data table
- Presenting and sorting data in a data table
- Adding calculations to a data table
- Filtering data
- Filtering with slicers
- Text, date, and numeric filters
- Removing duplicates
- Data sorting and filtering functions
Create and use PivotTables and PivotCharts
- Creating a PivotTable
- Modifying PivotTable fields and labels
- Adding calculations and managing totals in a PivotTable
- Modifying the source of a PivotTable
- Selecting, copying, moving, and deleting in a PivotTable
- Layout and printing of a PivotTable
- Formatting a PivotTable
- Filtering a PivotTable
- Filtering a PivotTable using slicers
- Creating a PivotTable based on multiple tables
- Adding calculated data to a PivotTable
- Grouping data
- Creating a PivotChart
Excel (2024 and Microsoft 365 versions) – Level 3: Advanced Knowledge
Increase efficiency
- Data conversion
- Creating data series
- Custom views
- Cell annotation
- Error checking
- Formula evaluation
- Watch Window
Use advanced calculation functions
- Table lookup
- Text functions
- Time calculations
- Date calculations
- Conditional arithmetic functions
- Logical functions with multiple conditions and responses
- Dynamic arrays
- Calculations during copying
- Consolidation
- Financial functions
- Two-way table
Discover unsuspected features
- Creating and using a template
- Modifying and deleting a template
- Goal Seek
- Solver
- Scenario Manager
- Creating a custom function
- Hyperlink
- Creating a custom theme
- Exporting a workbook to PDF or XPS and emailing it
- Saving in OpenOffice, LibreOffice, and Google Sheets formats
- Importing data
- Refreshing and managing imported data
- Workbook properties
Share securely
- Workbook protection
- Cell protection
- Workbook sharing
- Finalizing a workbook
To learn even more
- Macro
- File versioning and recovery
Copilot for Excel Microsoft 365 – Use Cases and Best Practices
Discover Copilot
- What is Copilot?
- Access methods for Copilot
- Copilot and data privacy
- Copilot on the Web
- Copilot in Bing
- Copilot in Microsoft Edge
- Copilot for Microsoft 365
- Copilot Pages
Copilot for Excel
- Getting started with Copilot for Excel
- Creating formulas
- Analyzing data
- Visualizing data
Write effective prompts
- Adopt best practices
- Adapt prompts to your needs
- Structure your prompts
Complementary book
This module offers the consultation of digital course material.
Excel (2024 and Microsoft 365 versions)
This module offers an interactive training course composed of 46 training videos and 46 practice exercises.
Excel (2024 and Microsoft 365 versions) – Level 1: Essential Knowledge
💡 Useful information
100% online training. Accessible anytime, from anywhere, giving a one year of access to the training. If you have any questions regarding registration, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote