Excel - Excel 2019 Intermediate + Advanced

Excel 2019 Intermediate + Advanced.

Master intermediate and advanced Excel 2019 skills in a structured online learning environment featuring interactive videos, spoken explanations, subtitles, and automatically reviewed practical assignments.

Track your progress with ease and receive personalized feedback to support your development.

Bonus: Includes the free video course Microsoft Copilot. Learn how to use AI within Microsoft 365 to work more efficiently and effectively.

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

Course content

Excel 2019

Get to know the spreadsheet program Excel and master the basic to the expert functionalities. After following this training, full use can be made of Excel. All necessary themes are covered such as: entering and formatting data, simple to complex calculations, graphs, managing large tables, pivot tables and advanced functionalities.

Expected duration for the indispensable modules
9 hours 30 min. (Video clips averaging 2 to 5 minutes)

Advanced

This module offers you an interactive training, consisting of 60 lesson videos, 60 assignments and
5 dossiers with additional information, evolving into complicated tables

• Display 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 formatting
• Control conditional formatting
• Range of cells name
• Validation criterion
• Ranges of cells in functions Present your numbers in graph form
• What you need to know about: Charts
• Create and move a chart
• Managing a chart
• Select chart elements
• Add or remove chart elements
• Format chart elements
• Change graph text elements
• Legend and plot area
• 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 the size of a graphic object
• Change a text box
• Edit a shape
• Format drawing objects
• Insert a picture
• Manage images
• Rotate and align objects
• Overlap and group objects Take advantage of your data lists
• Calculate subtotals
• Create and manage a data table
• View and sort 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 with 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: Pivot Tables 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
• Structure and print a pivot table
• Format of a pivot table
• Filtering a pivot table
• Filter using slicers
• Base a pivot table on multiple data tables
• Add fields or calculated elements
• Group data
• Create a pivot chart

Expert

This module offers you an interactive training, consisting of 42 lesson videos, 42 assignments and
5 files with additional information. Work even more efficiently

• Convert data
• What you need to know about: Autofill
• Using data series
• Custom Views
• Note to cell
• Error checking
• Evaluate formulas
• Control window Use advanced function calculations
• Search table and functions
• Text functions
• Calculate time
• Calculate dates
• Conditions with AND, OR, NOT
• some conditions
• Conditional functions
• Matrix formula
• Calculations with copies
• To merge
• Financial functions
• Double entry table Discover new functionalities
• Goal Seeking
• Solver
• Scenario management
• Hyperlink
• What you need to know about: Styles and templates
• Create and modify a theme
• Create and use a template
• What you need to know about: Import, export and interoperability
• Edit and delete a template
• Excel data transfer: PDF, XPS, email and web page
• Convert excel files
• Import data
• Update and manage imported data
• Workbook properties Securely share workbooks
• Workbook security
• Protect cells
• Share a workbook
• Track changes to workbook
• Merge workbooks
• Completion of a workbook
• Digital signature
• Create a form
• Securing and Using a Form To learn more about it ...
• Macro command
• Restore versions and files
• What you need to know about: Customize the ribbon
• What you need to know about: Good spreadsheet habits
• What you need to know about: Collaborate on a workbook

Office 2019: Cases
Excel 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 on 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.
Setting up a quality control Presentation of the use case
Create the statistical formulas
Prepare the diagram
Create control chart
Adjust the display of the control chart
Conclusion Analyzing library visits
Presentation of the use case
The graph Development of the number of visitors
Create the pivot tables
Conclusion Keeping budget
Presentation of the use case
Create the pivot tables
Create the charts
Create the dashboard
Conclusion Reduce costs
Presentation of the use case
Create 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.