MO-201 Microsoft Excel 2019 Expert Exam Certification Package
MO-201 Microsoft Excel 2019 Expert Exam Certification Package
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- 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 |
-
"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
OEM Office Elearning Menu Genomineerd voor 'Beste Opleider van Nederland'
OEM Office Elearning Menu is trots genomineerd te zijn voor de titel 'Beste Opleider van Nederland' door Springest, een onderdeel van Archipel. Deze erkenning bevestigt onze kwaliteit en toewijding. Hartelijk dank aan al onze cursisten.
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