Best seller!
Best seller!
$27.49
$24.99
MO-200: Microsoft Excel (Excel and Excel 2019) Certification Video Training Course
The complete solution to prepare for for your exam with MO-200: Microsoft Excel (Excel and Excel 2019) certification video training course. The MO-200: Microsoft Excel (Excel and Excel 2019) certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft Excel MO-200 exam dumps, study guide & practice test questions and answers.
112 Students Enrolled
11:08:00 Hours
MO-200: Microsoft Excel (Excel and Excel 2019) Certification Video Training Course Exam Curriculum
1
Introduction
1 Lectures
Time 00:10:00
2
Level 1, Section 1 - An introduction to Excel
5 Lectures
Time 00:26:00
3
Level 1, Section 2 - Create worksheets and workbooks
6 Lectures
Time 00:36:00
4
Level 1, Section 3 - Configure worksheets and workbooks to save
3 Lectures
Time 00:16:00
5
Level 1, Section 4 - Basic formulas
6 Lectures
Time 00:34:00
6
Level 2, Section 1 - Navigate through Excel worksheets and workbooks
4 Lectures
Time 00:17:00
7
Level 2, Section 2 - Format worksheets and workbooks
8 Lectures
Time 00:31:00
8
Level 2, Section 3 - Customise options and views for worksheets and workbooks
13 Lectures
Time 00:45:00
9
Level 2, Section 4 - Configure Excel worksheets and workbooks to print
11 Lectures
Time 00:34:00
10
Level 2, Section 5- Utilise cell ranges and references informulas and functions
3 Lectures
Time 00:14:00
11
Level 3, Section 1 - Insert data in cells and ranges
7 Lectures
Time 00:41:00
12
Level 3, Section 2 - Format cells and ranges
11 Lectures
Time 00:43:00
13
Level 3, Section 3 - Highlight and filter cells and ranges in Excel
6 Lectures
Time 00:33:00
14
Level 3, Section 4 - Summarise data with Excel functions
9 Lectures
Time 00:33:00
15
Level 4, Section 1 - Create a table
4 Lectures
Time 00:19:00
16
Level 4, Section 2 - Modify a table
3 Lectures
Time 00:14:00
17
Level 4, Section 3 - Filtering, Sorting and Grouping
9 Lectures
Time 01:04:00
18
Level 4, Section 4 - Utilise conditional logic in functions
8 Lectures
Time 00:49:00
19
Level 5, Section 1 - Create a chart in Excel
7 Lectures
Time 00:25:00
20
Level 5, Section 2 - Format a chart in Excel
4 Lectures
Time 00:21:00
21
Level 5, Section 3 - Insert and format an object
9 Lectures
Time 00:31:00
22
Level 5, Section 4 - create and modify images by using the Image Editor
5 Lectures
Time 00:15:00
23
Level 5, Section 5 - Format and modify text with functions
4 Lectures
Time 00:17:00
Introduction
-
10:00
1. Curriculum
Level 1, Section 1 - An introduction to Excel
-
3:00
1. Creating new blank workbooks
-
9:00
2. Entering data
-
6:00
3. An introduction to fonts and highlighting
-
5:00
4. Saving and closing your workbook
-
3:00
5. Practice Activity Number 1 - The Solution
Level 1, Section 2 - Create worksheets and workbooks
-
6:00
1. Creating new workbooks using templates
-
7:00
2. Menus and toolbars
-
4:00
3. Managing multiple workbooks
-
10:00
4. Importing files and Opening non-native files directly in Excel
-
3:00
5. Adding worksheets to existing workbooks
-
6:00
6. Copying and moving worksheets, and changing spreadsheet order
Level 1, Section 3 - Configure worksheets and workbooks to save
-
9:00
1. Saving workbooks in alternate file formats
-
5:00
2. Maintaining backward compatibility
-
2:00
3. Saving files to remote locations
Level 1, Section 4 - Basic formulas
-
6:00
1. Using basic operators
-
6:00
2. Order of operations
-
4:00
3. How to enter numbers and dates in Excel
-
11:00
4. Referencing cell ranges in formulas
-
2:00
5. Solution to the above exercise
-
5:00
6. Practice Activity Number 2 - Solution
Level 2, Section 1 - Navigate through Excel worksheets and workbooks
-
5:00
1. Searching for data within a workbook
-
4:00
2. Hyperlinks
-
5:00
3. Using Go To and Using Name Box
-
3:00
4. Hot Keys
Level 2, Section 2 - Format worksheets and workbooks
-
3:00
1. Changing worksheet tab colour
-
6:00
2. Inserting and deleting columns and rows
-
4:00
3. Undo and Redo
-
5:00
4. File Management tips
-
4:00
5. Adjusting row height and column width
-
3:00
6. Hiding columns and rows
-
3:00
7. Selecting multiple ranges
-
3:00
8. Practice Activity Number 3 - Solution
Level 2, Section 3 - Customise options and views for worksheets and workbooks
-
3:00
1. Hiding worksheets
-
3:00
2. Customising the Quick Access toolbar
-
5:00
3. Customising the Ribbon
-
2:00
4. Assigning shortcut keys
-
5:00
5. Recording simple macros
-
8:00
6. Managing macro security
-
3:00
7. Changing workbook views
-
2:00
8. Using zoom
-
3:00
9. Adding values to workbook properties
-
2:00
10. Displaying formulas
-
4:00
11. Freezing panes
-
2:00
12. Splitting the window
-
3:00
13. Practice Activity Number 4 - The Solution
Level 2, Section 4 - Configure Excel worksheets and workbooks to print
-
3:00
1. Printing individual worksheets
-
2:00
2. Printing an entire workbook and printing a selection
-
3:00
3. Setting a print area
-
4:00
4. Page setup, Part 1 (first two tabs)
-
2:00
5. Page setup, Part 2 (Repeating headers and footers)
-
3:00
6. Adding dynamic text to headers and footers
-
4:00
7. Inserting watermarks
-
5:00
8. Page setup, Part 3 (Headings etc.)
-
2:00
9. Configuring workbooks to print
-
4:00
10. Inspecting your workbook prior to distribution
-
2:00
11. Practice Activity Number 5 - The Solution
Level 2, Section 5- Utilise cell ranges and references informulas and functions
-
8:00
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)
-
2:00
2. Practice Activity - multiplication table
-
4:00
3. Answer - multiplication table
Level 3, Section 1 - Insert data in cells and ranges
-
3:00
1. Appending data to Excel worksheets
-
11:00
2. Setting data validation
-
7:00
3. Finding and replacing data
-
6:00
4. Copying and pasting data, including Paste Special
-
4:00
5. Cutting and moving cell data
-
7:00
6. Using AutoFill tool, and Expanding data across columns
-
3:00
7. Practice Activity Number 6 - The Solution
Level 3, Section 2 - Format cells and ranges
-
5:00
1. Modifying cell alignment and indentation
-
4:00
2. Wrapping text within cells
-
5:00
3. Merging cells and Shrink to Fit
-
5:00
4. Changing font and font styles
-
3:00
5. Applying highlighting
-
10:00
6. Applying Number format
-
4:00
7. Applying borders
-
2:00
8. Applying cell styles
-
2:00
9. Using Format Painter
-
1:00
10. Changing text to WordArt
-
2:00
11. Practice Activity Number 7 - The Solution
Level 3, Section 3 - Highlight and filter cells and ranges in Excel
-
11:00
1. Applying conditional formatting - highlighting
-
7:00
2. Applying conditional formatting - Bars, Scales and Sets
-
3:00
3. Transposing columns and rows, and #####s
-
4:00
4. Inserting sparklines, and how to define a range
-
6:00
5. Customising Sparklines
-
2:00
6. Practice Activity Number 8 - The Solution
Level 3, Section 4 - Summarise data with Excel functions
-
2:00
1. Doing calculations without formulas
-
3:00
2. Utilising the SUM function
-
5:00
3. Formula syntax - SUM function
-
5:00
4. Utilising the COUNT function
-
5:00
5. Utilising the AVERAGE and other averaging functions
-
2:00
6. Utilising the MIN and MAX functions
-
5:00
7. Creating named ranges
-
3:00
8. Getting help with functions
-
3:00
9. Practice Activity Number 9 - The Solution
Level 4, Section 1 - Create a table
-
4:00
1. Moving between tables and ranges
-
3:00
2. Adding and removing cells within tables
-
7:00
3. Formulas in tables
-
5:00
4. Defining titles
Level 4, Section 2 - Modify a table
-
6:00
1. Inserting total rows
-
6:00
2. Adding and removing styles and Banding rows and columns
-
2:00
3. Practice Activity Number 10 - The Solution
Level 4, Section 3 - Filtering, Sorting and Grouping
-
7:00
1. Setting up a filter and Filtering records
-
13:00
2. More advanced filtering options
-
6:00
3. Using sort options
-
5:00
4. Sorting data on multiple columns; changing sort order
-
6:00
5. Removing duplicates
-
5:00
6. Inserting subtotals
-
9:00
7. Creating outlines; collapsing groups of data in outlines
-
8:00
8. Utilising the SUBTOTAL function
-
5:00
9. Practice Activity Number 11 - The Solution
Level 4, Section 4 - Utilise conditional logic in functions
-
15:00
1. Utilising the IF function
-
5:00
2. Utilising the SUMIF function
-
4:00
3. Utilising the COUNTIF function
-
3:00
4. Utilising the AVERAGEIF function
-
7:00
5. Evaluate Formulas
-
8:00
6. Nested IFs
-
4:00
7. The CHOOSE function
-
3:00
8. Practice Activity Number 12 - The Solution
Level 5, Section 1 - Create a chart in Excel
-
4:00
1. Creating charts and graphs
-
3:00
2. Adding and removing additional data series
-
4:00
3. Exploring the Column charts
-
4:00
4. Line, bar and area charts
-
3:00
5. Pie charts
-
5:00
6. Other graph types
-
2:00
7. Switching between rows and columns in source data
Level 5, Section 2 - Format a chart in Excel
-
6:00
1. Adding legends
-
5:00
2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets
-
8:00
3. Modifying chart and graph parameters
-
2:00
4. Applying chart layouts and styles
Level 5, Section 3 - Insert and format an object
-
3:00
1. Inserting text boxes and positioning objects
-
4:00
2. Inserting SmartArt
-
3:00
3. Inserting ClipArt and images
-
2:00
4. Inserting Screenshots
-
4:00
5. Adding borders to objects
-
4:00
6. Inserting shapes
-
3:00
7. Adding styles and effects to objects
-
3:00
8. Changing workbook themes
-
5:00
9. Modifying object size and properties, including adding alternate text
Level 5, Section 4 - create and modify images by using the Image Editor
-
3:00
1. Making corrections to an image
-
2:00
2. Using picture colour tools
-
4:00
3. Send to front and back, and transparent colour
-
2:00
4. Changing artistic effects on an image
-
4:00
5. Crop picture
Level 5, Section 5 - Format and modify text with functions
-
5:00
1. Utilising the CONCATENATE function
-
6:00
2. Utilising the RIGHT, LEFT and MID functions
-
3:00
3. Utilising the LEN function
-
3:00
4. Utilising the UPPER and LOWER functions
About MO-200: Microsoft Excel (Excel and Excel 2019) Certification Video Training Course
MO-200: Microsoft Excel (Excel and Excel 2019) certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's MO-200: Microsoft Excel (Excel and Excel 2019) video training course for passing certification exams is the only solution which you need.
Pass Microsoft Excel MO-200 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
$11.76
MO-200 Premium Bundle
$38.22
$49.98
- Training Course 146 Video Lectures
- Study Guide 179 Pages
$49.98
$38.22
Student Feedback
4.4
Good
Only Registered Members
Can View Online Video Courses
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
