Excel (2024 and Microsoft 365 versions) – Presenting data: charts and illustrations

This course aims to teach you how to create eloquent charts and to illustrate your tables. After taking this course, you will be able to present data visually and illustrate your tables using pictures and drawing objects.

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

• Let the figures do the talking – Theme
  • Creating a chart
  • Managing a chart
  • Selecting chart éléments
  • Adding, removing and moving elements
  • Formatting chart elements
  • Modifying chart text elements
  • Legend and plot area
  • Chart printing and page layout
  • Creating sparklines
  • Managing sparklines
• Create striking charts – Theme
  • Editing data labels
  • Chart axes
  • Managing series
  • Options specific to different chart types
  • Managing chart templates

MEDIAplus elearning
This module offers interactive training consisting of 11 training videos and 11 exercises.
Excel (2024 and Microsoft 365 versions) – Pictures and drawing objects

• Illustrate your data – Theme
  • Creating drawing objects
  • Selecting and deleting objects
  • Copying and moving objects
  • Resizing object
  • Editing text boxes
  • Editing shapes
  • Formatting objects
  • Inserting pictures
  • Managing pictures
  • Rotating and aligning objects
  • Stacking and grouping objects

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