This training course helps you discover Excel and master its features, from the basics to advanced commands. You will progress through the main areas of the software: data entry and formatting, simple and advanced formulas, charts, large table management, pivot tables, and advanced tools.
Objectives
By the end of the training course, the participant will be able to use Excel, from basic features to advanced commands.
Is it for you ?
Any user wishing to discover or review the fundamentals of Excel and looking to explore advanced features.
Prerequisite
No prior knowledge of Excel is required. Minimal experience with the software can help you progress faster.
Content
Excel (2024 and Microsoft 365 versions) – Level 1: Essential Knowledge Discover
Excel, complete a table
- Opening a workbook
- General environment overview
- Navigating within a workbook
- Data entry
- Selecting cells
- Undo and redo an action
- Column width/row height
- Saving a workbook
- Editing cell content
Creating a new workbook
- Perform your first calculations
- Entering a calculation formula
- Sum and other simple calculations
- Calculating a percentage
- Copying to adjacent cells
- Present your data with basic formatting
- Simple number formats
- Applying a theme
- Highlighting text
- Font and font size
- Aligning cell content
- Cell color
- Cell borders
- Print and format your workbooks
- Page layout
- Print preview
- Page breaks
- Print area
- Header and footer
- Become more efficient
- Using Help
- Spell check
- Find and replace
- Zoom view
- Inserting/deleting rows, columns, and cells
- Moving cells
- Copying to non-adjacent cells
- Quick copy of cell formatting
- Merging cells
- Text orientation
- Cell styles
- Sorting data
- Manage sheets and data display
- Renaming a sheet and changing tab color
- Inserting, deleting, and adding a sheet background
- Moving, copying, and hiding a sheet
- Splitting a window/freezing rows and columns
- Repeating column/row titles when printing
- Hiding elements in a sheet
- Grouping data as an outline
See more + / -
Excel (2024 and Microsoft 365 versions) – Level 2: Intermediate Knowledge
Move toward more complex tables
- Displaying multiple lines in a cell
- Absolute references in a formula
- Using paste options
- System date and date format
- Simple conditions
- Custom format
- Conditional formatting
- Managing conditional formatting
- Naming a cell range
- Validation criteria
- Cell ranges in functions
- Present your figures using charts
- Creating a chart
- Managing a chart
- Selecting chart elements
- Layout, adding and deleting elements
- Formatting chart elements
- Editing chart text elements
- Legend and plot area
- Printing and formatting a chart
- Improve your chart presentation
- Editing data labels
- Chart axes
- Managing series
- Options specific to different chart types
- Managing chart templates
- Creating a map chart
- Creating sparklines
- Managing sparklines
- Enhance your tables
- Creating graphic objects
- Selecting and deleting objects
- Copying and moving objects
- Sizing an object
- Editing a text box
- Editing a shape
- Formatting objects
- Inserting an image
- Managing images
- Rotating and aligning objects
- Layering and grouping objects
- Leverage your data lists
- Calculating subtotals
Creating and managing a data table (List)
- Presenting and sorting data in a table
- Adding calculations to a table
- Filtering data
- Filtering with slicers
- Text, date, and number filters
- Removing duplicates
- Data sorting and filtering functions
- Create and use PivotTables and PivotCharts
Creating a PivotTable
- Editing fields and labels in a PivotTable
- Adding calculations and managing totals in a PivotTable
- Changing the data 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 your efficiency
- Converting data
- Creating data series
- Custom displays: Views
- Annotating a cell
- Error checking
- Formula evaluation
- Watch window
- Use advanced calculation functions
- Lookup in a table
- Text functions
- Time calculations
- Date calculations
- Conditional arithmetic functions
- Logical functions with multiple conditions and results
- Dynamic functions
- Calculations during copy/paste
- Consolidation
- Financial functions
- Two-variable data table
- Discover hidden features
- Creating and using a template
- Editing and deleting a template
- Goal Seek
- Solver
- Scenario manager
- Creating a custom function
- Hyperlinks
- Creating a custom theme
- Exporting a workbook to PDF or XPS and sending via email
- Saving in OpenOffice, LibreOffice, and Google Sheets formats
- Importing data
- Refreshing and managing imported data
- Workbook properties
- Share securely
- Protecting a workbook
- Protecting cells
- Sharing a workbook
- Finalizing a workbook
- To learn even more
- Macros
- Version history and file recovery
- Copilot for Excel
Microsoft 365 – Use cases and best practices
Discovering Copilot
- What is Copilot?
- How to access 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
- Writing effective prompts
- Adopting best practices
- Adapting prompts to your needs
- Structuring your prompts
Supplementary book
This module offers you access to digital course materials.
- Excel (2024 and Microsoft 365 versions)
💡 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
Upcoming information
Duration
13.0 hours
Regular fee
$199
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