Excel (2024 and Microsoft 365 versions) – Advanced Features

1 Excel (2024 and Microsoft 365 versions) – Level 2: Intermediate Knowledge

2 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

3 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

4 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

5 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

6 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

7 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

8 Excel (2024 and Microsoft 365 versions) – Level 3: Advanced Knowledge

9 Increase efficiency

• Data conversion
• Creating data series
• Custom views
• Cell annotation
• Error checking
• Formula evaluation
• Watch Window

10 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

11 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

12 Share securely

• Workbook protection
• Cell protection
• Workbook sharing
• Finalizing a workbook

13 To learn even more

• Macro
• File versioning and recovery

14 Copilot for Excel Microsoft 365 – Use Cases and Best Practices

15 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

16 Copilot for Excel

• Getting started with Copilot for Excel
• Creating formulas
• Analyzing data
• Visualizing data

17 Write effective prompts

• Adopt best practices
• Adapt prompts to your needs
• Structure your prompts

18 Complementary book

19 This module offers the consultation of digital course material.

Excel (2024 and Microsoft 365 versions)

20 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