MO-200: Microsoft Excel (Excel and Excel 2019) Exam Training Course

MO-200: Microsoft Excel (Excel and Excel 2019)

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The MO-200 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft MO-200 test with flying colors.

133 Students Enrolled 146 Lectures 11:08:00 Hours

Curriculum For This Course

Introduction

1Lectures

Time 00:10:00

Level 1, Section 1 - An introduction to Excel

5Lectures

Time 00:26:00

Level 1, Section 2 - Create worksheets and workbooks

6Lectures

Time 00:36:00

Level 1, Section 3 - Configure worksheets and workbooks to save

3Lectures

Time 00:16:00

Level 1, Section 4 - Basic formulas

6Lectures

Time 00:34:00

Level 2, Section 1 - Navigate through Excel worksheets and workbooks

4Lectures

Time 00:17:00

Level 2, Section 2 - Format worksheets and workbooks

8Lectures

Time 00:31:00

Level 2, Section 3 - Customise options and views for worksheets and workbooks

13Lectures

Time 00:45:00

Level 2, Section 4 - Configure Excel worksheets and workbooks to print

11Lectures

Time 00:34:00

Level 2, Section 5- Utilise cell ranges and references informulas and functions

3Lectures

Time 00:14:00

Level 3, Section 1 - Insert data in cells and ranges

7Lectures

Time 00:41:00

Level 3, Section 2 - Format cells and ranges

11Lectures

Time 00:43:00

Level 3, Section 3 - Highlight and filter cells and ranges in Excel

6Lectures

Time 00:33:00

Level 3, Section 4 - Summarise data with Excel functions

9Lectures

Time 00:33:00

Level 4, Section 1 - Create a table

4Lectures

Time 00:19:00

Level 4, Section 2 - Modify a table

3Lectures

Time 00:14:00

Level 4, Section 3 - Filtering, Sorting and Grouping

9Lectures

Time 01:04:00

Level 4, Section 4 - Utilise conditional logic in functions

8Lectures

Time 00:49:00

Level 5, Section 1 - Create a chart in Excel

7Lectures

Time 00:25:00

Level 5, Section 2 - Format a chart in Excel

4Lectures

Time 00:21:00

Level 5, Section 3 - Insert and format an object

9Lectures

Time 00:31:00

Level 5, Section 4 - create and modify images by using the Image Editor

5Lectures

Time 00:15:00

Level 5, Section 5 - Format and modify text with functions

4Lectures

Time 00:17:00

Introduction
	1. Curriculum	10:00

Level 1, Section 1 - An introduction to Excel
	1. Creating new blank workbooks	3:00
	2. Entering data	9:00
	3. An introduction to fonts and highlighting	6:00
	4. Saving and closing your workbook	5:00
	5. Practice Activity Number 1 - The Solution	3:00

Level 1, Section 2 - Create worksheets and workbooks
	1. Creating new workbooks using templates	6:00
	2. Menus and toolbars	7:00
	3. Managing multiple workbooks	4:00
	4. Importing files and Opening non-native files directly in Excel	10:00
	5. Adding worksheets to existing workbooks	3:00
	6. Copying and moving worksheets, and changing spreadsheet order	6:00

Level 1, Section 3 - Configure worksheets and workbooks to save
	1. Saving workbooks in alternate file formats	9:00
	2. Maintaining backward compatibility	5:00
	3. Saving files to remote locations	2:00

Level 1, Section 4 - Basic formulas
	1. Using basic operators	6:00
	2. Order of operations	6:00
	3. How to enter numbers and dates in Excel	4:00
	4. Referencing cell ranges in formulas	11:00
	5. Solution to the above exercise	2:00
	6. Practice Activity Number 2 - Solution	5:00

Level 2, Section 1 - Navigate through Excel worksheets and workbooks
	1. Searching for data within a workbook	5:00
	2. Hyperlinks	4:00
	3. Using Go To and Using Name Box	5:00
	4. Hot Keys	3:00

Level 2, Section 2 - Format worksheets and workbooks
	1. Changing worksheet tab colour	3:00
	2. Inserting and deleting columns and rows	6:00
	3. Undo and Redo	4:00
	4. File Management tips	5:00
	5. Adjusting row height and column width	4:00
	6. Hiding columns and rows	3:00
	7. Selecting multiple ranges	3:00
	8. Practice Activity Number 3 - Solution	3:00

Level 2, Section 3 - Customise options and views for worksheets and workbooks
	1. Hiding worksheets	3:00
	2. Customising the Quick Access toolbar	3:00
	3. Customising the Ribbon	5:00
	4. Assigning shortcut keys	2:00
	5. Recording simple macros	5:00
	6. Managing macro security	8:00
	7. Changing workbook views	3:00
	8. Using zoom	2:00
	9. Adding values to workbook properties	3:00
	10. Displaying formulas	2:00
	11. Freezing panes	4:00
	12. Splitting the window	2:00
	13. Practice Activity Number 4 - The Solution	3:00

Level 2, Section 4 - Configure Excel worksheets and workbooks to print
	1. Printing individual worksheets	3:00
	2. Printing an entire workbook and printing a selection	2:00
	3. Setting a print area	3:00
	4. Page setup, Part 1 (first two tabs)	4:00
	5. Page setup, Part 2 (Repeating headers and footers)	2:00
	6. Adding dynamic text to headers and footers	3:00
	7. Inserting watermarks	4:00
	8. Page setup, Part 3 (Headings etc.)	5:00
	9. Configuring workbooks to print	2:00
	10. Inspecting your workbook prior to distribution	4:00
	11. Practice Activity Number 5 - The Solution	2:00

Level 2, Section 5- Utilise cell ranges and references informulas and functions
	1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)	8:00
	2. Practice Activity - multiplication table	2:00
	3. Answer - multiplication table	4:00

Level 3, Section 1 - Insert data in cells and ranges
	1. Appending data to Excel worksheets	3:00
	2. Setting data validation	11:00
	3. Finding and replacing data	7:00
	4. Copying and pasting data, including Paste Special	6:00
	5. Cutting and moving cell data	4:00
	6. Using AutoFill tool, and Expanding data across columns	7:00
	7. Practice Activity Number 6 - The Solution	3:00

Level 3, Section 2 - Format cells and ranges
	1. Modifying cell alignment and indentation	5:00
	2. Wrapping text within cells	4:00
	3. Merging cells and Shrink to Fit	5:00
	4. Changing font and font styles	5:00
	5. Applying highlighting	3:00
	6. Applying Number format	10:00
	7. Applying borders	4:00
	8. Applying cell styles	2:00
	9. Using Format Painter	2:00
	10. Changing text to WordArt	1:00
	11. Practice Activity Number 7 - The Solution	2:00

Level 3, Section 3 - Highlight and filter cells and ranges in Excel
	1. Applying conditional formatting - highlighting	11:00
	2. Applying conditional formatting - Bars, Scales and Sets	7:00
	3. Transposing columns and rows, and #####s	3:00
	4. Inserting sparklines, and how to define a range	4:00
	5. Customising Sparklines	6:00
	6. Practice Activity Number 8 - The Solution	2:00

Level 3, Section 4 - Summarise data with Excel functions
	1. Doing calculations without formulas	2:00
	2. Utilising the SUM function	3:00
	3. Formula syntax - SUM function	5:00
	4. Utilising the COUNT function	5:00
	5. Utilising the AVERAGE and other averaging functions	5:00
	6. Utilising the MIN and MAX functions	2:00
	7. Creating named ranges	5:00
	8. Getting help with functions	3:00
	9. Practice Activity Number 9 - The Solution	3:00

Level 4, Section 1 - Create a table
	1. Moving between tables and ranges	4:00
	2. Adding and removing cells within tables	3:00
	3. Formulas in tables	7:00
	4. Defining titles	5:00

Level 4, Section 2 - Modify a table
	1. Inserting total rows	6:00
	2. Adding and removing styles and Banding rows and columns	6:00
	3. Practice Activity Number 10 - The Solution	2:00

Level 4, Section 3 - Filtering, Sorting and Grouping
	1. Setting up a filter and Filtering records	7:00
	2. More advanced filtering options	13:00
	3. Using sort options	6:00
	4. Sorting data on multiple columns; changing sort order	5:00
	5. Removing duplicates	6:00
	6. Inserting subtotals	5:00
	7. Creating outlines; collapsing groups of data in outlines	9:00
	8. Utilising the SUBTOTAL function	8:00
	9. Practice Activity Number 11 - The Solution	5:00

Level 4, Section 4 - Utilise conditional logic in functions
	1. Utilising the IF function	15:00
	2. Utilising the SUMIF function	5:00
	3. Utilising the COUNTIF function	4:00
	4. Utilising the AVERAGEIF function	3:00
	5. Evaluate Formulas	7:00
	6. Nested IFs	8:00
	7. The CHOOSE function	4:00
	8. Practice Activity Number 12 - The Solution	3:00

Level 5, Section 1 - Create a chart in Excel
	1. Creating charts and graphs	4:00
	2. Adding and removing additional data series	3:00
	3. Exploring the Column charts	4:00
	4. Line, bar and area charts	4:00
	5. Pie charts	3:00
	6. Other graph types	5:00
	7. Switching between rows and columns in source data	2:00

Level 5, Section 2 - Format a chart in Excel
	1. Adding legends	6:00
	2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets	5:00
	3. Modifying chart and graph parameters	8:00
	4. Applying chart layouts and styles	2:00

Level 5, Section 3 - Insert and format an object
	1. Inserting text boxes and positioning objects	3:00
	2. Inserting SmartArt	4:00
	3. Inserting ClipArt and images	3:00
	4. Inserting Screenshots	2:00
	5. Adding borders to objects	4:00
	6. Inserting shapes	4:00
	7. Adding styles and effects to objects	3:00
	8. Changing workbook themes	3:00
	9. Modifying object size and properties, including adding alternate text	5:00

Level 5, Section 4 - create and modify images by using the Image Editor
	1. Making corrections to an image	3:00
	2. Using picture colour tools	2:00
	3. Send to front and back, and transparent colour	4:00
	4. Changing artistic effects on an image	2:00
	5. Crop picture	4:00

Level 5, Section 5 - Format and modify text with functions
	1. Utilising the CONCATENATE function	5:00
	2. Utilising the RIGHT, LEFT and MID functions	6:00
	3. Utilising the LEN function	3:00
	4. Utilising the UPPER and LOWER functions	3:00