Excel (2024 and Microsoft 365 versions) – Protecting, sharing and optimising data

E-Learning MEDIAplus elearning™

Excel (2024 and Microsoft 365 versions) - Protecting, sharing and optimising data

1h25

FR - ES - DE - EN

En_EB31-733

Want to offer this online course to your learners?
Our teams are here to help.

ENI calls you back
Download the brochure

MEDIAplus elearning is an online training solution, unique in the market. Learning through practice, directly within the studied app and with immediate results analysis and solution.

Find out more
Download the brochure

Course goals

This course aims to teach you how to protect, share and optimise your data. After taking this course, you will know how to work collaboratively in Excel and you will increase your efficiency when managing data.

Prerequisites

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.

Course goals

MEDIAplus elearning
This module offers interactive training consisting of 4 training videos and 4 exercises.
Excel (2024 and Microsoft 365 versions) – Collaborative work

  • Protect your data – Theme
    • Protecting workbooks
    • Protecting sheets and their contents
  • Share your data – Theme
    • Sharing a workbook
    • Finalising a workbook

MEDIAplus elearning
This module offers interactive training consisting of 13 training videos and 13 exercises.
Excel (2024 and Microsoft 365 versions) – Optimising data

  • Grasped the basics? Take the next step – Theme
    • Find and replace
    • Sorting data
    • Named range
    • Validation rules
    • Converting data
    • Creating data series
    • Grouping data in an outline
    • Comments
    • Hyperlinks
  • Import / export – 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

Additional MEDIAplus elearning content
This module offers interactive training consisting of 27 training videos and 27 exercises.
Excel (2024 and Microsoft 365 versions) – Table creation basics