Video Course
BEST SELLER

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

Looking for studying for MO-200: Microsoft Excel (Excel and Excel 2019) certification training course. Our MO-200 certification video training course training course is your number one assistant. Pass with our MO-200: Microsoft Excel (Excel and Excel 2019) certification training course on the first try and become a certified professional in no time.

  • 95 Students Enrolled
  • 146 Lectures
  • 1 Hours
  • 5.0 Rating
$27.49
$24.99

Curriculum For This Course

  • Introduction

    Video Name Time
    1. Curriculum 10:00

  • Level 1, Section 1 - An introduction to Excel

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

  • Level 1, Section 2 - Create worksheets and workbooks

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

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

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

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

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

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

  • Level 2, Section 2 - Format worksheets and workbooks

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

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

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

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

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

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

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

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

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

  • Level 3, Section 2 - Format cells and ranges

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

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

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

  • Level 3, Section 4 - Summarise data with Excel functions

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

  • Level 4, Section 1 - Create a table

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

  • Level 4, Section 2 - Modify a table

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

  • Level 4, Section 3 - Filtering, Sorting and Grouping

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

  • Level 4, Section 4 - Utilise conditional logic in functions

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

  • Level 5, Section 1 - Create a chart in Excel

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

  • Level 5, Section 2 - Format a chart in Excel

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

  • Level 5, Section 3 - Insert and format an object

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

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

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

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

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

Student Feedback

  1. 52%
  2. 48%
  3. 0%
  4. 0%
  5. 0%

Excellent Overall Rating

5.0

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login