Excel - Excel 2019 Beginner + Intermediate with Copilot

Excel 2019 Beginner + Intermediate with Copilot

Learn the essential and intermediate skills of Excel 2019 step by step in an interactive online learning environment with videos, spoken explanations, subtitles, and practical assignments that are automatically reviewed.

Monitor your progress effortlessly and receive personalized feedback to support your learning journey.

Bonus: Includes the free Microsoft Copilot video course. Discover how to boost your productivity using AI in Microsoft 365.

After completing 70% of the training, you will receive a certificate of participation.

Required level

No knowledge of Excel is required. With minimal use of the program, progress will be made faster.

Expected duration for the indispensable modules

9 hours 30 min.
(Video clips averaging 2 to 5 minutes)

Content of the training

Basic

This module offers you an interactive training, consisting of 45 lesson videos, 45 assignments and
5 files with additional information.

Introduction to Excel, fill in a table

• What you need to know about: Spreadsheets
• Open workbooks
• General working environment
• Move in workbook
• What you need to know about: Input Help
• Enter data
• What you need to know about: Select, copy and move
• Select and clear cells
• Cancel and restore operation
• Column width/row height
• What you need to know about: Saving files
• Save workbooks
• Adjust cell contents
• Create new workbook

Make your first calculations

• Enter formulas
• Sum and other simple calculations
• Calculate percentage
• Copy to adjacent cells
• Take care of the formatting of your data
• Simple number formats
• Apply theme
• character format
• Font and size
• Align Cell Contents
• Cell color
• cell borders
• Print and set page layout your worksheets
• Page layout
• Print preview and printing
• Page break
• Print Range
• What you need to know about: Header and Footer
• Header and Footer

Work more efficiently with Excel

• Using Excel Help
• spell check
• Find and replace
• Zoom in and out
• Insert or delete rows, columns, and cells
• Moving cells
• Copy to non-adjacent cells
• Quick copy cell formatting
• Merge cells
• Cell contents orientation
• Cell Styles
• Sort a table

Manage the worksheets

• Worksheet name and tab color
• Insert, delete worksheets and set background
• Move, copy, and hide worksheets
• Block column/row, split screen
• Print column and row titles repeatedly
• Hide items on worksheet
• Group data in overview

Advanced

This module offers you an interactive training, consisting of 60 teaching videos, 60 assignments and
5 files with additional information.

Evolving into complicated tables

• Show multiple lines in cell
• An absolute reference in formula
• Copy, transpose calculation results and links
• What you need to know about: Entering functions
• System date and date format
• Simple condition
• Custom format
• Apply a conditional format
• Manage conditional formatting
• Cell range name
• Validation criterion
• Cell ranges in functions

Present your figures in graph form

• What you need to know about: Charts
• Create and move a chart
• Manage a chart
• Select chart elements
• Add or remove chart elements
• Formatting chart elements
• Change Chart Text Elements
• Legend and Artboard
• Print a chart and page layout

Improve the layout of your charts

• Change data labels
• Data series and chart axes
• Manage sequences
• Chart Type Options
• Manage chart templates
• Create a 2D map chart
• Create a sparkline chart
• Manage Sparklines

Beautify your tables

• Create a graphic object
• Select and delete objects
• Copy and move objects
• Determine graphic object size
• Change a text box
• Edit a shape
• Formatting drawing objects
• Insert an image
• Manage images
• Rotate and align objects
• Overlap and group objects

Take advantage of your data lists

• Calculating Subtotals
• Create and manage a data table
• Displaying and sorting data from a data table
• Add calculation to a data table
• Automatic filtering
• Custom filters
• Empty and duplicate values
• What you need to know about: Criteria ranges
• Filter by criteria range
• Filter and copy rows with criteria range
• Criteria Range Calculations

Create and use pivot tables and charts

• What you need to know about: PivotTables and Charts
• Create pivot table
• Modify a pivot table and add calculations
• Change the source of a pivot table
• Select, copy, move, and delete a pivot table
• PivotTable Structure and Printing
• Layout of a pivot table
• Filtering a pivot table
• Filter using slicers
• Base a pivot table on multiple data tables op
• Add fields or calculated elements
• Group data
• Create a pivot chart

Office 2019: Cases
Excel, Word or PowerPoint with an Office 365 subscription
This module offers you a video with a length of 20 minutes.

An e-mail message from Office with or without an Office 365 subscription: what are the differences?
Create and save Office documents to OneDrive, SharePoint Online or Teams
Edit a document from OneDrive, SharePoint, or Teams
Share Office documents with colleagues or with people outside the organization
Collaborate on a file

Excel 2019: Cases
This module offers you a video with a length of 48 minutes.
Set up a quality control

Presentation of the use case
Creating the Statistical Formulas
Prepare the chart
Create control chart
Customize control chart display
Conclusion

Analyzing library visits
Presentation of the use case
The graph Evolution of visitor numbers
Creating the pivot tables
Conclusion

Keep track of budget Budget
Presentation of the use case
Creating the pivot tables
Creating the charts
Create the dashboard
Conclusion

Reduce costs
Presentation of the use case
Creating the Formulas
Solve the problem with the Solver
Conclusion

Excel 2019 – Versions 2019 and Office 365 Online Book
In this module you can consult an online book.