Excel (2024 and Microsoft 365 versions) – Getting started

E-Learning MEDIAplus elearning™

Excel (2024 and Microsoft 365 versions) - Getting started

3h12

FR - ES - DE - EN

En_EB31-730

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 provide you with the basics in order to create tables autonomously: discover the Excel spreadsheet, input data, perform easy calculations, format the table and manage the workbook. After taking the course, you will be able to easily and quickly create a basic data table.

Prerequisites

Target audience:
Any user who wishes to discover or deepen Excel’s basics.

Level required:
No prior knowledge of Excel is necessary.

Course goals

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

  • Get started in Excel – Theme
    • Opening a workbook
    • Overview of the environment
    • Moving around a workbook
    • Data input
    • Editing a cell’s contents
    • Using Excel’s Help
    • Display zoom
  • Copying and moving, clearing – Theme
    • Selecting cells
    • Undoing and redoing an action
    • AutoFill
    • Moving cells
    • Copying to non-adjacent cells
  • Set out your first Excel calculations – Theme
    • Entering a calculation formula
    • Sum and other basic functions
    • Calculating a percentage
    • Absolute references
    • Cell ranges in functions
  • Format the table – Theme
    • Column width and row height
    • Simple number formats
    • Formatting characters
    • Character font and size
    • Aligning cell contents
    • Inserting and deleting rows, columns and cells
  • Managing and printing the workbook – Theme
    • Saving a workbook
    • Page layout
    • Print preview and printing
    • Creating a new workbook

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