• Home
uCertify Logo
  • Search Titles
  • Career Tracks
  • platform
    • Learn
    • Course
    • Lab
    • Test
    • Mobile App
    • Create
  • partner with us
    • Educator
    • Publisher
    • Request Demo
  • 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Request Demo
  • Browse Titles
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Course Categories
    • IT / Computer Science
    • Project Management
    • Vocational Training
    • Coding
  • Technology
    • Learn
    • Course
    • Lab
    • Test
    • Learn Smart App
    • Create
  • I am...
    • Professional (Self-Paced Learner)
    • Educator
    • Publisher
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Help
    • Keyboard Shortcuts
    • Features
    • Send Feedback
Scroll to top button

Microsoft Excel 2019

(MO-200.AI1) / ISBN: 9781644591826
This course includes
Lessons
TestPrep
LiveLab
MO-200.AI1 : Microsoft Excel 2019
Share
$279.99
Try This Course
Are you an instructor?
Request a free evaluation copy

Microsoft Excel 2019

Gain the skills required to pass the Microsoft Excel MO-200 exam with the Microsoft Excel 2019 course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any text-book, course, or training. The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.
Here's what you will get

The Microsoft Excel 2019 certification validates a candidate's skills in managing worksheets and workbooks; data cells and ranges; and tables, table data and charts; and performing operations using formulas and functions. The MO-200 exam provides the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.

Lessons
  • 24+ Lessons
  • 234+ Quizzes
  • 210+ Flashcards
  • 210+ Glossary of terms
TestPrep
  • 28+ Pre Assessment Questions
  • 28+ Post Assessment Questions
Lab
  • 50+ Performance lab
  • 108+ Video tutorials
  • 01:51+ Hours
Video Lessons
  • 1+ Videos
Here's what you will learn
Download Course Outline
Lesson 1: Introduction
Lesson 2: Fundamentals
  • Module A: Getting around
  • Module B: Workbook basics
  • Summary
Lesson 3: Creating worksheets
  • Module A: Entering data
  • Module B: Formulas
  • Module C: Functions
  • Module D: Moving and copying data
  • Module E: Reference types
  • Summary
Lesson 4: Formatting
  • Module A: Text formatting
  • Module B: Number formatting
  • Module C: Alignment
  • Module D: Borders and highlighting
  • Module E: Styles and themes
  • Summary
Lesson 5: Manipulating data
  • Module A: Data entry shortcuts
  • Module B: Paste options
  • Module C: Inserting, deleting, and hiding
  • Summary
Lesson 6: Charts
  • Module A: Creating charts
  • Module B: Chart types and elements
  • Summary
Lesson 7: Output
  • Module A: Managing worksheet windows
  • Module B: Printing worksheets
  • Module C: Sharing workbooks
  • Summary
Lesson 8: Settings and templates
  • Module A: Workbook options and properties
  • Module B: Templates
  • Summary
Lesson 9: Introduction
Lesson 10: Managing workbooks
  • Module A: Managing worksheets
  • Module B: Customizing Excel
  • Summary
Lesson 11: Named ranges
  • Module A: Using names in formulas
  • Summary
Lesson 12: Tables
  • Module A: Sorting
  • Module B: Filtering tables
  • Module C: Structured references
  • Module D: Validation
  • Module E: Transposing data
  • Summary
Lesson 13: Summarizing data
  • Module A: Consolidation
  • Module B: Subtotals
  • Summary
Lesson 14: PivotTables
  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: PivotCharts
  • Summary
Lesson 15: Presentation features
  • Module A: Conditional formats
  • Module B: Custom Formats
  • Module C: Graphics
  • Summary
Lesson 16: Advanced charts
  • Module A: Special chart types
  • Module B: Sparklines
  • Module C: Quick Analysis
  • Summary
Lesson 17: Collaboration
  • Module A: Permissions
  • Module B: Shared workbooks
  • Summary
Lesson 18: Introduction
Lesson 19: Logical and Lookup Functions
  • Module A: Decision-making functions
  • Module B: Lookup and reference functions
  • Summary
Lesson 20: Advanced Formulas
  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays
  • Summary
Lesson 21: Special functions
  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions
  • Summary
Lesson 22: Importing and Exporting
  • Module A: The Power Pivot Data Model
  • Module B: Exporting data
  • Summary
Lesson 23: Analysis
  • Module A: What-if analysis
  • Module B: The Analysis Toolpak
  • Summary
Lesson 24: Macros and Forms
  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms
  • Summary

Hands on Activities (Performance Labs)

Fundamentals

  • Saving a Workbook

Creating worksheets

  • Creating a New Workbook
  • Performing Calculations with Formulas
  • Entering a Function
  • Using Relative, Absolute, and Mixed References

Formatting

  • Changing the Date Format
  • Formatting Numbers
  • Merging a Heading
  • Applying a Theme

Manipulating data

  • Inserting and Deleting Cell Ranges

Charts

  • Creating a Simple Chart
  • Changing the Chart Color
  • Changing the Chart Style
  • Editing a Legend in the Chart
  • Creating a Column Chart and Switching its Rows and Columns 

Output

  • Splitting a Large Worksheet
  • Setting Page Margin
  • Setting and Saving the Print Area
  • Adding a Header
  • Saving a Workbook as a PDF File

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template

Managing workbooks

  • Inserting Hyperlink to an Image

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names

Tables

  • Sorting Data
  • Sorting by Multiple Columns
  • Filtering Data 
  • Formatting Data as a Table
  • Creating Formulas Using Structured References

PivotTables

  • Creating a PivotTable Automatically

Presentation features

  • Inserting WordArt
  • Inserting SmartArt

Advanced charts

  • Inserting a Trendline on a Chart
  • Customizing Sparklines

Collaboration

  • Adding Comments
  • Merging Shared Workbooks

Logical and Lookup Functions

  • Using the IF Function
  • Using the SUMIF Function 
  • Using the SUMIFS Function
  • Using VLOOKUP
  • Using the MATCH Function

Advanced Formulas

  • Using an Array Formula 
  • Using an Array Function

Special functions

  • Performing Calculations Using Date Functions
  • Performing Simple Time Calculations
  • Using the Concatenate Function
  • Calculating the Minimum and Maximum Sales Value

Importing and Exporting

  • Importing Data from a File
  • Creating Relationships Between Tables
  • Exporting to a Text File

Macros and Forms

  • Creating a Blank Form
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for the certification exam.
What is the exam registration fee? USD 100
Where do I take the exam? Certiport
What is the format of the exam? The exam consists of performance based questions and is conducted in a live or simulated environment. 
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 90 minutes
What is the passing score? The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?

Microsoft Office Specialist (MOS) exam retake policy

  1. If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification? For life
Where can I find more information about this exam? To know more about the , click here.
What are the career opportunities after passing this exam?
  • Accountants
  • Cost Estimator
  • Data Journalist
  • Retail Manager
  • Project Manager
  • Business Analyst
  • Financial Analyst
  • Information Clerk
  • Administrative Assistant
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

ucertify logo
uCertify provides Courses, Lab, TestPrep for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe, Axelos and many more.

The logos and certification names are the trademarks of their respective owners.
Connect
  • About Us
  • Awards
  • Contact Us
  • Sitemap
  • Careers
  • Partners with us
  • Platform
Resources
  • Titles Catalog
  • Vendors
  • Certifications
  • Exams
  • Blog
  • Sitemap

Subscribe To Our Newsletters
Sign up for our monthly newsletter to get the latest news, updates and amazing offers delivered directly in your inbox.
Accessibility Terms & Conditions Privacy Statement
© 2002-2020 uCertify. All Rights Reserved
uCertify App
android app image
ios app image
We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept