Practice Exams:

View All

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.

Rating

4.47

Students

119

Duration

11:08:00 h

$16.49

$14.99

Curriculum for MO-200 Certification Video Course

Introduction

1 Lectures

Time 00:10:00

Level 1, Section 1 - An introduction to Excel

5 Lectures

Time 00:26:00

Level 1, Section 2 - Create worksheets and workbooks

6 Lectures

Time 00:36:00

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

3 Lectures

Time 00:16:00

Level 1, Section 4 - Basic formulas

6 Lectures

Time 00:34:00

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

4 Lectures

Time 00:17:00

Level 2, Section 2 - Format worksheets and workbooks

8 Lectures

Time 00:31:00

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

13 Lectures

Time 00:45:00

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

11 Lectures

Time 00:34:00

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

3 Lectures

Time 00:14:00

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

7 Lectures

Time 00:41:00

Level 3, Section 2 - Format cells and ranges

11 Lectures

Time 00:43:00

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

6 Lectures

Time 00:33:00

Level 3, Section 4 - Summarise data with Excel functions

9 Lectures

Time 00:33:00

Level 4, Section 1 - Create a table

4 Lectures

Time 00:19:00

Level 4, Section 2 - Modify a table

3 Lectures

Time 00:14:00

Level 4, Section 3 - Filtering, Sorting and Grouping

9 Lectures

Time 01:04:00

Level 4, Section 4 - Utilise conditional logic in functions

8 Lectures

Time 00:49:00

Level 5, Section 1 - Create a chart in Excel

7 Lectures

Time 00:25:00

Level 5, Section 2 - Format a chart in Excel

4 Lectures

Time 00:21:00

Level 5, Section 3 - Insert and format an object

9 Lectures

Time 00:31:00

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

5 Lectures

Time 00:15:00

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

4 Lectures

Time 00:17:00

Name of Video	Time
1. Curriculum	10:00

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
1. Saving workbooks in alternate file formats	9:00
2. Maintaining backward compatibility	5:00
3. Saving files to remote locations	2:00

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Name of Video	Time
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

Microsoft Excel MO-200 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft Excel MO-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

$29.98

$24.54

MO-200 Premium Bundle

Training Course: 146 Video Lectures
Study Guide: 179 Pages

Latest Questions
100% Accurate Answers
Fast Exam Updates

MO-200 Premium Bundle

Training Course: 146 Video Lectures
Study Guide: 179 Pages

Latest Questions
100% Accurate Answers
Fast Exam Updates

$29.98

$24.54

Microsoft MO-200 Training Course

Want verified and proven knowledge for Microsoft Excel (Excel and Excel 2019)? Believe it's easy when you have ExamSnap's Microsoft Excel (Excel and Excel 2019) certification video training course by your side which along with our Microsoft MO-200 Exam Dumps & Practice Test questions provide a complete solution to pass your exam Read More.

Prepared by Top Experts, the top IT Trainers ensure that when it comes to your IT exam prep and you can count on ExamSnap Microsoft Excel (Excel and Excel 2019) certification video training course that goes in line with the corresponding Microsoft MO-200 exam dumps, study guide, and practice test questions & answers.

Purchase Individually