MO-200 Video Course

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