Excel (2024 and Microsoft 365 versions) – Finalising tables: formatting and printing

E-Learning MEDIAplus elearning™

Excel (2024 and Microsoft 365 versions) - Finalising tables: formatting and printing

2h35

FR - ES - DE - EN

En_EB31-731

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 advanced formatting and how to manage its printing. After taking this course, you will be able to properly finalise all types of data tables.

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 25 training videos and 25 exercises.
Excel (2024 and Microsoft 365 versions) – Formatting tables

  • Format your data – Theme
    • Simple number formats
    • Formatting characters
    • Character font and size
    • Aligning cell contents
    • Cell colour
    • Cell borders
    • Format painting
    • Merging cells
    • Cell contents orientation
    • Cell styles
    • Control date and date formats
  • Edit the spreadsheets – Theme
    • Column width and row height
    • Inserting and deleting rows, columns and cells
    • Managing sheets: Sheet name and tab colour
    • Managing sheets: inserting, deleting and adding a background
    • Managing sheets: Moving, copying, hiding
  • Improve table formatting – Theme
    • Applying
    • Displaying several lines in one cell
    • Custom formats
    • Conditional formatting
    • Managing conditional formatting
    • Hiding sheet items • Creating and using templates
    • Editing and deleting templates
    • Creating a custom theme

MEDIAplus elearning
This module offers interactive training consisting of 6 training videos and 6 exercises.
Excel (2024 and Microsoft 365 versions) – Printing tables

  • Print your tables – Theme
    • Page layout
    • Print preview and printing
    • Repeating rows/columns on printed pages
    • Page breaks
    • Print areas
    • Headers and footers

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