Microsoft Excel Excel 2019 Advanced and Expert E-learning
Excel 2019 Advanced and Expert E-learning
Microsoft Excel

Excel 2019 Advanced and Expert E-learning

EUR 95,00 Excl. tax
  • Buy 3 for €92,15 each and save 3%
  • Buy 5 for €90,25 each and save 5%
  • Buy 10 for €85,50 each and save 10%
  • Buy 25 for €80,75 each and save 15%
  • Buy 50 for €70,00 each and save 26%
  • Buy 150 for €65,00 each and save 32%
  • Buy 300 for €60,00 each and save 37%

Take an Excel 2019 Basic and Advanced course now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.

  • E-Learning - Online toegang: 365 dagen
  • Taal: Nederlands of Engels
  • Certificaat van deelname
In stock
Order before 4:00 PM and start today.
  • Ordered before 23:00:00, delivered tomorrow
  • Gecertificeerde docenten
  • Interactieve training + praktijkopdrachten
  • Certificaat van deelname
  • More information? Contact us about this product
Product description

Elearning Course Excel 2019 Advanced & Expert Package 

Take these unique Elearning courses from Microsoft Excel 2019 on a advanced and expert level online, 1 year 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, speech, subtitling, practical assignments with real -time analysis of your answers, progress monitoring through reports to prepare you for the Microsoft Office Specialist (MOS) exam thanks to high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) including reports and after> 70% of the course a certificate of participation.

You have mastered the basic operations, but you want to learn how to use advanced functionality of Excel. Thanks to this training you will get to know new functionalities and make better use of others. The following topics will be covered, among others: formulas and other calculation functionalities, pivot tables and securing and sharing your workbooks.

Target audience
Anyone who has mastered the basic operations in Excel and wants to learn advanced functionalities optimally

Required level
The basic operations in Excel must be mastered in order to transition to the
advanced functionalities.

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

Content of the training

This module offers you an interactive training, consisting of 60 lesson videos, 60 assignments and
5 files 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 format
Control conditional formatting
Range of cells 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
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
Managing sparklines

Decorate 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

Leverage 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

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
Scenario management
What you should 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

Share workbooks securely
Workbook security
Protect cells
Share a workbook
Track changes to workbook
Merge workbooks
Completion of a workbook
Digital signature
Create a form
Secure and use a form

To find out 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, 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 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.
Set 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

Analyze library visits
Presentation of the use case
The graph Development of the number of visitors
Create the pivot tables

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

Reduce costs
Presentation of the use case
Create the formulas
Fix the problem with the Solver

Delivery time
Online access
Lesson duration
Study load
Certificate of participation
Learning methods
Operating systems
Included services
Supported browsers
MOS Exam
Extra options
Access to teacher
What our customers say

average of 0 review(s)

No reviews found
Read or write a review
* We'll never share your email with anyone else.
We are happy to help you. Provide our customer service advice
My account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Your cart is empty
Search suggestions
No courses or trainings found...
Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »