MO-200 Microsoft Excel 2019

Information and Technology


19 Hours


Equip yourself with hands-on experience and practical knowledge with the Microsoft Practice Lab environment course.


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 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

Payment options available to you

Need more information about this course?

Complete the fields below to receive the course information pack.

    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.