Take a guided and practical approach to learning everything you need to pass the Microsoft Excel 2019 MO-200 exam with our live Practice Lab. This Practice Lab is ideal for those wishing to discover how to use the new features and functions found in Excel 2019, or if you’re new to Excel you can learn the fundamentals and be up-to-date with the latest additions. No matter what experience you have, completing this lab will put you one step ahead of the rest. For those that are familiar with Microsoft Excel 2016 (77-727), you’ll discover numerous new learning objectives. Improve your productivity, get real work done and learn invaluable skills that can be applied to thousands of jobs, or become better organised with household tasks within your home.
Once you feel confident to take the Microsoft certification exam, you will need to follow the process below to register and pay for your exam. The exam can be taken online or in a test centre near you.
Go to Certifications and select the certification you would like to write, click register for exam
Select “Schedule with Pearson VUE” when choosing an exam delivery partner
Sign into your Microsoft account, or create a certification profile
Complete the required information
Follow the on-screen steps to select a proctoring method (if available), schedule your exam appointment, and complete payment (if applicable).
Run a systems check if taking the exam online
Once registered, your appointment should appear in the Certification Dashboard. You can also cancel or reschedule your appointment here if you need. If you are taking an online exam, you will start your exam from here as well.
Module Outline
MODULE 1 | Worksheet and Workbook Navigation
MODULE 2 | Formatting Worksheets and Workbooks
MODULE 3 | Customizing the Quick Access Toolbar
MODULE 4 | Importing Data from Text Files and Comma-Separated Value (CSV) Files
MODULE 5 | Manipulating Data in Worksheets – Part 1
MODULE 6 | Manipulating Data in Worksheets – Part 2
MODULE 7 | Searching Data within a Workbook
MODULE 8 | Working with Hyperlinks
MODULE 9 | Working with Window Views
MODULE 10 | Filtering Records
MODULE 11 | Sorting Table Data
MODULE 12 | Working with References
MODULE 13 | Using Mathematical Functions
MODULE 14 | Using COUNT Functions
MODULE 15 | Using IF() Function
MODULE 16 | Working with Text Functions
MODULE 17 | Formatting Cells – Part 1
MODULE 18 | Formatting Cells – Part 2
MODULE 19 | Summarizing Data Visually
MODULE 20 | Working with Excel Tables
MODULE 21 | Formatting Excel Tables
MODULE 22 | Creating Charts
MODULE 23 | Modifying Charts
MODULE 24 | Working with Sparklines and Chart Layouts and Styles
MODULE 25 | Adding Alternative Text to Objects
MODULE 26 | Inspecting Workbooks
MODULE 27 | Modifying Workbook Properties and Display Formulas
MODULE 28 | Saving Workbooks in Alternative File Formats
MODULE 29 | Setting a Print Area
MODULE 30 | Configure Print Settings
Related Products
Practice Lab
MD-100
MD-100 Windows 10
Practice Lab
77-729
77-729 PowerPoint 2016 - Core Presentation Design and Delivery Skills
Exam Prep
77-884
77-884 Outlook 2010
Practice Lab
98-366
98-366 Networking Fundamentals
Practice Lab
MO-100
MO-100 Microsoft Word 2019
Practice Lab
77-725
77-725 Microsoft Office – Word 2016
Practice Lab
MD-101
MD-101 Managing Modern Desktops
Practice Lab
98-382
98-382 Introduction to Programming Using JavaScript
Practice Lab
98-383
98-383 Introduction to Programming Using HTML and CSS
Practice Lab
98-375
98-375 HTML5 Application Development Fundamentals
Exam Prep
77-727
77-727 Excel 2016 - Core Data Analysis, Manipulation and Presentation
Exam Prep
77-882
77-882 Excel 2010
Practice Lab
98-364-r1
98-364-r1 Database Fundamentals - SQL Server 2016 Update
Practice Lab
98-364
98-364 Database Administration Fundamentals
Practice Lab
ORACLE-1Z0-062
ORACLE-1Z0-062 Oracle Database 12c - Installation and Administration
Exam Prep
1Z0-051
1Z0-051 Database 11g SQL Fundamentals 1
Practice Lab
SY0-601
SY0-601 CompTIA Security+
Practice Lab
N10-008
N10-008 CompTIA Network+
Practice Lab
N10-007
N10-007 CompTIA Network+
Practice Lab
XK0-004
XK0-004 CompTIA Linux+
Practice Lab
FC0-U61
FC0-U61 CompTIA IT Fundamentals+
Practice Lab
CS0-002
CS0-002 CompTIA Cybersecurity Analyst (CySA+)
PLAB-SERVER-2016-SANDBOX
PLAB-SERVER-2016-SANDBOX Practice Labs Server 2016 Sandbox
PLAB-SERVER-2012-R2-SANDBOX
PLAB-SERVER-2012-R2-SANDBOX Practice Labs Server 2012R2 Sandbox
PLAB-WS01
PLAB-WS01 Practice Labs Introduction to Wireshark
PLAB-CEH-v10
PLAB-CEH-v10 Practice Labs - Ethical Hacker v10
PLAB-WS-NMAP
PLAB-WS-NMAP Introduction to Network Security Tools
IC3-GS5 IC3
IC3-GS5 IC3 Digital Literacy Certification - Global Standard 5
Practice Lab
PLAB-DIG-LIT
PLAB-DIG-LIT Digital Literacy
Practice Lab
PLAB-CS-FUND
PLAB-CS-FUND Cyber Security Fundamentals
Practice Lab
PLABS-DFORENSIC
PLABS-DFORENSIC Computer Forensics and Investigations
