McAfee-Secured Website

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:

Was 43.99 USD
Now 39.99 USD

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