Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »

MO-201 Microsoft Excel 2019 Expert Exam Certification Package

MO-201 Microsoft Excel 2019 Expert Exam Certification Package

345,00 417,45 Incl. tax

With this MO-201 Microsoft Excel 2019 Expert Exam Certification Package, you can become a Microsoft Office Specialist in Excel 2019. It contains the complete Excel 2019 course, a Gmetrix MOS practice Exam MO-201 and the Excel 2019 Microsoft Online Exam MO

Read more
Availability:
In stock
Delivery time:
Ordered before 5 p.m.! Start today.
  • Award Winning E-learning
  • Lowest price guarantee
  • Personalized service by our expert team
  • Pay safely online or by invoice
  • Order and start within 24 hours

MO-201 Microsoft Excel 2019 Expert Exam Certification Package

This package includes: 1 Online Excel 2019 Basic Advanced and Expert course (course is accessible for 1 year), 1x Gmetrix MOS practice exam MO-201 and 1x MO-201 Excel 2019 Expert (online) exam.

With this package you prepare exactly for the Microsoft Office Specialist MO-201 Microsoft Excel 2019 Expert Exam. You start with the online Excel 2019 E-Learning course, after which you take the Gmetrix MO-201 practice exam. If necessary, you then train the parts in the E-Learning course on which you score too low. Then you take the mock exam again. As soon as you score sufficiently, you can make an appointment with us to take the exam with us in Almere or Online.

Excel 2019 365 Basic Advanced Expert + Online Book.

Excel 365 E-Learning version 2019 in a virtual Office 365 Cloud environment with practical assignments and rich interactive videos with speech and subtitles with real-time analysis of your answers, progress monitoring through reports. This E-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Door developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. Reports in the Learning Portal (LMS) and a certificate of participation after >70% of the course. SCORM capability.

Target
Get to know the spreadsheet program Excel and master the basic to advanced 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.

Target audience
Anyone who wants to (re)learn to use the basic operations in Excel and who wants to master the advanced functionalities.

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
14 hours 50 minutes
(Video clips averaging 2 to 5 minutes)

Content of the training

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
  • 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
  • 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 FastFill
  • 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 combine
  • 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 securely

  • Workbook security
  • 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: 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
    Preparing the diagram
    Creating the control diagram
    Customizing the display of the rule diagram
    Conclusion
    Analyzing library visits
    Presentation of the use case
    The graph Development of the number of visitors
    Creating the pivot tables
    Conclusion
    Budget tracking
    Presentation of the use case
    Creating pivot tables
    Creating the charts
    Creating the dashboard
    Conclusion
    Reducing costs
    Presentation of the use case
    Creating the formulas
    Solving the problem with the Solver
    Conclusion

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

Online access 365 days
Lesson duration 13:10 hours
Study load Variable because of practical assignments.
Certificate of participation Yes, after 70% of the successful assignments
Learning methods Instruction video, Demonstration video, Knowledge Base
Operating systems Microsoft Windows, Google Chrome OS, Apple MacOS
Included services Progress report, 24/7 online access
Supported browsers Internet Explorer, Edge, Firefox, Safari en Chrome
MOS Exam Possible for corresponding exam number
Total
10/10 (2 Reviews)

    "Overzichtelijke toets, werkt soepel en snel. Duidelijke uitleg aan het begin en fijn dat er verschillende indicatiemogelijkheden op zitten, zoals een vinkje als je de opdracht hebt gemaakt of een vlaggetje als je er later op wil terug komen."

    Anna Pilic on 06 Feb 2024

    "Hele fijne ervaring, leuke begeleiding oftewel examinator aanwezig op de locatie in Almere en de toets in de eerste poging gehaald. Ik kan het iedereen aanraden! Het ging makkelijk, snel en was erg overzichtelijk. Ik ben blij met het resultaat! Ik kijk uit naar mijn volgende PowerPoint en Word examen."

    Monsels on 06 Feb 2024

Loading...

OEM Office Elearning Menu Trots Genomineerd voor 'Beste Opleider van Nederland'

OEM Office Elearning Menu is vereerd met de nominatie voor 'Beste Opleider van Nederland' door Springest by STUDYTUBE, een blijk van erkenning voor onze excellente trainingen en toewijding aan kwaliteitsonderwijs. Dank aan alle cursisten.

Reviews

Total
10/10 (2 Reviews)

    "Overzichtelijke toets, werkt soepel en snel. Duidelijke uitleg aan het begin en fijn dat er verschillende indicatiemogelijkheden op zitten, zoals een vinkje als je de opdracht hebt gemaakt of een vlaggetje als je er later op wil terug komen."

    Anna Pilic on 06 Feb 2024

    "Hele fijne ervaring, leuke begeleiding oftewel examinator aanwezig op de locatie in Almere en de toets in de eerste poging gehaald. Ik kan het iedereen aanraden! Het ging makkelijk, snel en was erg overzichtelijk. Ik ben blij met het resultaat! Ik kijk uit naar mijn volgende PowerPoint en Word examen."

    Monsels on 06 Feb 2024

25.000+

Deelnemers getrained

Springest: 9.1 - Edubookers 8.9

Gemiddeld cijfer

3500+

Aantal getrainde bedrijven

20+

Jaren ervaring

Even more knowledge

Read our most recent articles

View blog