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
NEED MORE INFORMATION ABOUT THIS COURSE?
Complete the fields below to receive the course information pack. *Required fields
By providing us with your contact details, you agree to the use of your data as described in our terms and conditions to receive communications. You may opt out of receiving communications at any time.
