Excel 2019 Beginner + Intermediate + Advanced

Excel 2019 Beginner + Intermediate + Advanced with Copilot

Gain complete proficiency in Excel 2019—from beginner to advanced level—in a comprehensive online learning environment with interactive videos, spoken explanations, subtitles, and practical assignments that are automatically reviewed.

Track your progress easily and receive personalized feedback to guide your development.

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

After 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, you can make full use 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
14 hours 50 minutes
(Video clips averaging 2 to 5 minutes)

Basic

This module offers you an interactive training, consisting of 45 teaching 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
• Move 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
• Filtering using slicers
• Basing a PivotTable 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 teaching videos, 42 assignments and
5 files with additional information.

Work even more efficiently

• Convert data
• What you need to know about: Auto-Fast Fill
• 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
• Array 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 customize a theme
• Create and use a template
• What you need to know about: Import, export and interoperability
• Editing and Deleting a Template
• Transfer Excel data: PDF, XPS, email and web page
• Convert Excel files
• Import data
• Update and manage imported data
• Workbook properties
  

Share workbooks in a safe way

Security workbook Protect cells Share a workbook Track workbook changes 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: Customizing the ribbon What you need to know about: Good Spreadsheet Habits What you need to know about: Collaborate on a workbook Office 2019: CasesExcel, Word or PowerPoint with an Office 365 subscriptionThis 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 TeamsEdit a document from OneDrive, SharePoint, or TeamsShare Office documents with colleagues or with people outside the organizationCollaborate on a fileExcel 2019: CasesThis module offers you a video with a length of 48 minutes.Set up a quality controlPresentation of the use caseCreating the Statistical FormulasPrepare the chartCreate control chartCustomize control chart displayConclusionAnalyzing library visitsPresentation of the use caseThe graph Evolution of visitor numbersCreate the pivot tablesConclusionKeep track of budgetPresentation of the use caseCreate the pivot tablesCreating the chartsCreate the dashboardConclusionReduce costsPresentation of the use caseCreating the FormulasSolve the problem with the SolverConclusionExcel 2019 – Versions 2019 and Office 365 Online BookIn this module you can consult an online book.