MO-200 Microsoft Excel 2019
share to:

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

Practice Lab

MO-200

MO-200 Microsoft Excel 2019

R1,590.00

Practice Lab

Entry

19 hours

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.

R1,590.00

course fees

30

modules

19 hours

duration

Anytime

registration

R1,590.00

course fees

30

modules

19 hours

duration

Anytime

registration

Payment options available to you

Certification

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

Practice Lab

PLAB-AZ3

PLAB-AZ3 Azure Storage Management

Practice Lab

PLAB-AZ4

PLAB-AZ4 Azure Security Concepts

Practice Lab

PLAB-AZ2

PLAB-AZ2 Azure Management Concepts

Practice Lab

PLAB-AZ2

PLAB-AZ1 Azure Fundamentals

Practice Lab

200-301

200-301 Cisco Certified Network Associate (CCNA)