Course name Microsoft MO-200: Microsoft Excel (Excel and Excel 2019)
Corresponding Certifications: MOS: Associate (Office 365 and Office 2019), MOS: Excel Associate (Excel and Excel 2019)

MO-200 Video Course

MO-200 Video Course is developed by Microsoft Professionals to help you pass the MO-200 exam.
You Will Learn:
Description
This course will improve your knowledge and skills required to pass Microsoft Excel (Excel and Excel 2019) exam.
Curriculum For This Course
-
1. Introduction 1 Videos 00:10:00
-
Curriculum 10:00
-
-
2. Level 1, Section 1 - An introduction to Excel 5 Videos 00:26:00
-
Creating new blank workbooks 3:00
-
Entering data 9:00
-
An introduction to fonts and highlighting 6:00
-
Saving and closing your workbook 5:00
-
Practice Activity Number 1 - The Solution 3:00
-
-
3. Level 1, Section 2 - Create worksheets and workbooks 6 Videos 00:36:00
-
Creating new workbooks using templates 6:00
-
Menus and toolbars 7:00
-
Managing multiple workbooks 4:00
-
Importing files and Opening non-native files directly in Excel 10:00
-
Adding worksheets to existing workbooks 3:00
-
Copying and moving worksheets, and changing spreadsheet order 6:00
-
-
4. Level 1, Section 3 - Configure worksheets and workbooks to save 3 Videos 00:16:00
-
Saving workbooks in alternate file formats 9:00
-
Maintaining backward compatibility 5:00
-
Saving files to remote locations 2:00
-
-
5. Level 1, Section 4 - Basic formulas 6 Videos 00:34:00
-
Using basic operators 6:00
-
Order of operations 6:00
-
How to enter numbers and dates in Excel 4:00
-
Referencing cell ranges in formulas 11:00
-
Solution to the above exercise 2:00
-
Practice Activity Number 2 - Solution 5:00
-
-
6. Level 2, Section 1 - Navigate through Excel worksheets and workbooks 4 Videos 00:17:00
-
Searching for data within a workbook 5:00
-
Hyperlinks 4:00
-
Using Go To and Using Name Box 5:00
-
Hot Keys 3:00
-
-
7. Level 2, Section 2 - Format worksheets and workbooks 8 Videos 00:31:00
-
Changing worksheet tab colour 3:00
-
Inserting and deleting columns and rows 6:00
-
Undo and Redo 4:00
-
File Management tips 5:00
-
Adjusting row height and column width 4:00
-
Hiding columns and rows 3:00
-
Selecting multiple ranges 3:00
-
Practice Activity Number 3 - Solution 3:00
-
-
8. Level 2, Section 3 - Customise options and views for worksheets and workbooks 13 Videos 00:45:00
-
Hiding worksheets 3:00
-
Customising the Quick Access toolbar 3:00
-
Customising the Ribbon 5:00
-
Assigning shortcut keys 2:00
-
Recording simple macros 5:00
-
Managing macro security 8:00
-
Changing workbook views 3:00
-
Using zoom 2:00
-
Adding values to workbook properties 3:00
-
Displaying formulas 2:00
-
Freezing panes 4:00
-
Splitting the window 2:00
-
Practice Activity Number 4 - The Solution 3:00
-
-
9. Level 2, Section 4 - Configure Excel worksheets and workbooks to print 11 Videos 00:34:00
-
Printing individual worksheets 3:00
-
Printing an entire workbook and printing a selection 2:00
-
Setting a print area 3:00
-
Page setup, Part 1 (first two tabs) 4:00
-
Page setup, Part 2 (Repeating headers and footers) 2:00
-
Adding dynamic text to headers and footers 3:00
-
Inserting watermarks 4:00
-
Page setup, Part 3 (Headings etc.) 5:00
-
Configuring workbooks to print 2:00
-
Inspecting your workbook prior to distribution 4:00
-
Practice Activity Number 5 - The Solution 2:00
-
-
10. Level 2, Section 5- Utilise cell ranges and references informulas and functions 3 Videos 00:14:00
-
Copying and pasting basics, and Utilising references (relative, mixed, absolute) 8:00
-
Practice Activity - multiplication table 2:00
-
Answer - multiplication table 4:00
-
-
11. Level 3, Section 1 - Insert data in cells and ranges 7 Videos 00:41:00
-
Appending data to Excel worksheets 3:00
-
Setting data validation 11:00
-
Finding and replacing data 7:00
-
Copying and pasting data, including Paste Special 6:00
-
Cutting and moving cell data 4:00
-
Using AutoFill tool, and Expanding data across columns 7:00
-
Practice Activity Number 6 - The Solution 3:00
-
-
12. Level 3, Section 2 - Format cells and ranges 11 Videos 00:43:00
-
Modifying cell alignment and indentation 5:00
-
Wrapping text within cells 4:00
-
Merging cells and Shrink to Fit 5:00
-
Changing font and font styles 5:00
-
Applying highlighting 3:00
-
Applying Number format 10:00
-
Applying borders 4:00
-
Applying cell styles 2:00
-
Using Format Painter 2:00
-
Changing text to WordArt 1:00
-
Practice Activity Number 7 - The Solution 2:00
-
-
13. Level 3, Section 3 - Highlight and filter cells and ranges in Excel 6 Videos 00:33:00
-
Applying conditional formatting - highlighting 11:00
-
Applying conditional formatting - Bars, Scales and Sets 7:00
-
Transposing columns and rows, and #####s 3:00
-
Inserting sparklines, and how to define a range 4:00
-
Customising Sparklines 6:00
-
Practice Activity Number 8 - The Solution 2:00
-
-
14. Level 3, Section 4 - Summarise data with Excel functions 9 Videos 00:33:00
-
Doing calculations without formulas 2:00
-
Utilising the SUM function 3:00
-
Formula syntax - SUM function 5:00
-
Utilising the COUNT function 5:00
-
Utilising the AVERAGE and other averaging functions 5:00
-
Utilising the MIN and MAX functions 2:00
-
Creating named ranges 5:00
-
Getting help with functions 3:00
-
Practice Activity Number 9 - The Solution 3:00
-
-
15. Level 4, Section 1 - Create a table 4 Videos 00:19:00
-
Moving between tables and ranges 4:00
-
Adding and removing cells within tables 3:00
-
Formulas in tables 7:00
-
Defining titles 5:00
-
-
16. Level 4, Section 2 - Modify a table 3 Videos 00:14:00
-
Inserting total rows 6:00
-
Adding and removing styles and Banding rows and columns 6:00
-
Practice Activity Number 10 - The Solution 2:00
-
-
17. Level 4, Section 3 - Filtering, Sorting and Grouping 9 Videos 01:04:00
-
Setting up a filter and Filtering records 7:00
-
More advanced filtering options 13:00
-
Using sort options 6:00
-
Sorting data on multiple columns; changing sort order 5:00
-
Removing duplicates 6:00
-
Inserting subtotals 5:00
-
Creating outlines; collapsing groups of data in outlines 9:00
-
Utilising the SUBTOTAL function 8:00
-
Practice Activity Number 11 - The Solution 5:00
-
-
18. Level 4, Section 4 - Utilise conditional logic in functions 8 Videos 00:49:00
-
Utilising the IF function 15:00
-
Utilising the SUMIF function 5:00
-
Utilising the COUNTIF function 4:00
-
Utilising the AVERAGEIF function 3:00
-
Evaluate Formulas 7:00
-
Nested IFs 8:00
-
The CHOOSE function 4:00
-
Practice Activity Number 12 - The Solution 3:00
-
-
19. Level 5, Section 1 - Create a chart in Excel 7 Videos 00:25:00
-
Creating charts and graphs 4:00
-
Adding and removing additional data series 3:00
-
Exploring the Column charts 4:00
-
Line, bar and area charts 4:00
-
Pie charts 3:00
-
Other graph types 5:00
-
Switching between rows and columns in source data 2:00
-
-
20. Level 5, Section 2 - Format a chart in Excel 4 Videos 00:21:00
-
Adding legends 6:00
-
Positioning and Resizing charts and graphs, inc. moving charts into chart sheets 5:00
-
Modifying chart and graph parameters 8:00
-
Applying chart layouts and styles 2:00
-
-
21. Level 5, Section 3 - Insert and format an object 9 Videos 00:31:00
-
Inserting text boxes and positioning objects 3:00
-
Inserting SmartArt 4:00
-
Inserting ClipArt and images 3:00
-
Inserting Screenshots 2:00
-
Adding borders to objects 4:00
-
Inserting shapes 4:00
-
Adding styles and effects to objects 3:00
-
Changing workbook themes 3:00
-
Modifying object size and properties, including adding alternate text 5:00
-
-
22. Level 5, Section 4 - create and modify images by using the Image Editor 5 Videos 00:15:00
-
Making corrections to an image 3:00
-
Using picture colour tools 2:00
-
Send to front and back, and transparent colour 4:00
-
Changing artistic effects on an image 2:00
-
Crop picture 4:00
-
-
23. Level 5, Section 5 - Format and modify text with functions 4 Videos 00:17:00
-
Utilising the CONCATENATE function 5:00
-
Utilising the RIGHT, LEFT and MID functions 6:00
-
Utilising the LEN function 3:00
-
Utilising the UPPER and LOWER functions 3:00
-
Download Free Microsoft MO-200 Testing Engine Demo
Experience Testking Microsoft MO-200 exam Q&A testing engine for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your Microsoft MO-200 exam.
- Customizable, interactive testing engine
- Simulates real exam environment
- Instant download
* Our demo shows only a few questions from Microsoft MO-200 exam for evaluating purposes