Excel (2024 and Microsoft 365 versions) – Advanced techniques

You master the essential commands and wish to evolve towards more advanced techniques. This training programme will make it possible for you to discover or improve your knowledge on formula, tools for calculations, pivot tables, sharing workbooks…

Target audience:
Users who have mastered the essential commands and wish to move towards more advanced techniques.

Level required:
The essential commands must be mastered in order to access Excel’s advanced techniques without difficulty.

MEDIAplus elearning
This module offers interactive training consisting of 60 training videos and 60 exercises.
Excel (2024 and Microsoft 365 versions) – Level 2: Intermediate skills

• Move on to more complex tables
  • Displaying several lines in one cell
  • Absolute reference
  • Paste Options
  • Control date and date formats
  • Simple conditions
  • Custom formats
  • Conditional formatting
  • Managing conditional formatting
  • Named range
  • Validation rules
  • Cell ranges in functions
• Let charts explain your data
  • Creating a chart
  • Managing a chart
  • Selecting chart elements
  • Adding, removing and moving elements
  • Formatting chart elements
  • Modifying chart text elements
  • Legend and plot area
  • Chart printing and page layout
• Create striking charts
  • Editing data labels
  • Chart axes
  • Managing series
  • Options specific to different chart types
  • Managing chart templates
  • Map charts
  • Creating sparklines
  • Managing sparklines
• Illustrate your data
  • Creating drawing objects
  • Selecting and deleting objects
  • Copying and moving objects
  • Resizing objects
  • Editing text boxes
  • Editing shapes
  • Formatting objects
  • Inserting pictures
  • Managing pictures
  • Rotating and aligning objects
  • Stacking and grouping objects
• Database functionality with an Excel table
  • Subtotal rows
  • Creating and managing a data table
  • Presenting and sorting data in a data table
  • Adding calculations in a data table
  • Filtering data
  • Custom filters
  • Filtering using slicers
  • Text, date and number filters
  • Removing duplicates
  • Data sorting and filtering functions
• See your data from a different angle: pivot tables and charts
  • Creating a pivot table
  • Editing a pivot table’s fields and labels
  • Adding calculations and managing totals in pivot tables
  • Changing a pivot table’s source
  • Selecting, copying, moving or deleting in pivot tables
  • Pivot table layout and printing
  • Formatting pivot tables
  • Filtering pivot tables
  • Filtering with slicers
  • Creating pivot tables based on several tables
  • Adding calculated fields or elements
  • Grouping data
  • Pivot charts

MEDIAplus elearning
This module offers interactive training consisting of 37 training videos and 37 exercises.
Excel (2024 and Microsoft 365 versions) – Level 3: Advanced skills

• Grasped the basics? Take the next step
  • Converting data
  • Creating a data series
  • Custom views
  • Comments
  • Detecting errors
  • Evaluating formulas
  • The Watch Window
• Find the right function for your calculation
  • Lookup tables and functions
  • Text functions
  • Time calculations
  • Date calculations
  • Conditional arithmetic functions
  • Logical functions with several conditions and responses
  • Dynamic array functions
  • Calculating with copied values
  • Consolidation
  • Financial functions
  • Double entry data table
• Discover unexpected features
  • Creating and using templates
  • Editing and deleting templates
  • Goal seek
  • The Solver
  • Managing scenarios
  • Creating a custom function
  • Hyperlinks
  • Creating and custom a theme
  • Publishing a workbook to PDF or XPS and sending via email
  • Saving to different formats: OpenOffice, LibreOffice and Google Sheets
  • Importing data
  • Updating and managing imported data
  • Workbook properties
• Share and collaborate effectively
  • Protecting workbooks
  • Protecting sheets and their contents
  • Sharing workbooks
  • Finalising workbooks
• Find out more…
  • Macros
  • File versions and recovery

Video
This module offers to view a video lasting 1h.
Copilot for Excel Microsoft 365 – Use cases and best practices

• Discover Copilot
  • What is Copilot?
  • How to access Copilot
  • Copilot and data confidentiality
  • Copilot on the Web
  • Copilot in Bing
  • Copilot in Microsoft Edge
  • Copilot for Microsoft 365
  • Copilot Pages
• Copilot for Excel
  • Getting started with Copilot in Excel
  • Creating formulas
  • Analysing data
  • Displaying data
• Write effective prompts
  • Adopting best practices
  • Adapting prompts to your needs
  • Structuring your prompts

Additional MEDIAplus elearning content
This module offers interactive training consisting of 45 training videos and 45 exercises.
Excel (2024 and Microsoft 365 versions) – Level 1: Essential skills