Certification training

MO-200MO-200: Microsoft Excel (Excel and Excel 2019)

Prepare for your Microsoft exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

146Lectures
11h 8mDuration
MicrosoftVendor
MO-200: Microsoft Excel (Excel and Excel 2019) course cover Best seller
Microsoft certification training MO-200 146 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

23 sections, 146 lessons, and lecture-level duration details.

01 Curriculum 10m

01 Creating new blank workbooks 3m
02 Entering data 9m
03 An introduction to fonts and highlighting 6m
04 Saving and closing your workbook 5m
05 Practice Activity Number 1 - The Solution 3m

01 Creating new workbooks using templates 6m
02 Menus and toolbars 7m
03 Managing multiple workbooks 4m
04 Importing files and Opening non-native files directly in Excel 10m
05 Adding worksheets to existing workbooks 3m
06 Copying and moving worksheets, and changing spreadsheet order 6m

01 Saving workbooks in alternate file formats 9m
02 Maintaining backward compatibility 5m
03 Saving files to remote locations 2m

01 Using basic operators 6m
02 Order of operations 6m
03 How to enter numbers and dates in Excel 4m
04 Referencing cell ranges in formulas 11m
05 Solution to the above exercise 2m
06 Practice Activity Number 2 - Solution 5m

01 Searching for data within a workbook 5m
02 Hyperlinks 4m
03 Using Go To and Using Name Box 5m
04 Hot Keys 3m

01 Changing worksheet tab colour 3m
02 Inserting and deleting columns and rows 6m
03 Undo and Redo 4m
04 File Management tips 5m
05 Adjusting row height and column width 4m
06 Hiding columns and rows 3m
07 Selecting multiple ranges 3m
08 Practice Activity Number 3 - Solution 3m

01 Hiding worksheets 3m
02 Customising the Quick Access toolbar 3m
03 Customising the Ribbon 5m
04 Assigning shortcut keys 2m
05 Recording simple macros 5m
06 Managing macro security 8m
07 Changing workbook views 3m
08 Using zoom 2m
09 Adding values to workbook properties 3m
10 Displaying formulas 2m
11 Freezing panes 4m
12 Splitting the window 2m
13 Practice Activity Number 4 - The Solution 3m

01 Printing individual worksheets 3m
02 Printing an entire workbook and printing a selection 2m
03 Setting a print area 3m
04 Page setup, Part 1 (first two tabs) 4m
05 Page setup, Part 2 (Repeating headers and footers) 2m
06 Adding dynamic text to headers and footers 3m
07 Inserting watermarks 4m
08 Page setup, Part 3 (Headings etc.) 5m
09 Configuring workbooks to print 2m
10 Inspecting your workbook prior to distribution 4m
11 Practice Activity Number 5 - The Solution 2m

01 Copying and pasting basics, and Utilising references (relative, mixed, absolute) 8m
02 Practice Activity - multiplication table 2m
03 Answer - multiplication table 4m

01 Appending data to Excel worksheets 3m
02 Setting data validation 11m
03 Finding and replacing data 7m
04 Copying and pasting data, including Paste Special 6m
05 Cutting and moving cell data 4m
06 Using AutoFill tool, and Expanding data across columns 7m
07 Practice Activity Number 6 - The Solution 3m

01 Modifying cell alignment and indentation 5m
02 Wrapping text within cells 4m
03 Merging cells and Shrink to Fit 5m
04 Changing font and font styles 5m
05 Applying highlighting 3m
06 Applying Number format 10m
07 Applying borders 4m
08 Applying cell styles 2m
09 Using Format Painter 2m
10 Changing text to WordArt 1m
11 Practice Activity Number 7 - The Solution 2m

01 Applying conditional formatting - highlighting 11m
02 Applying conditional formatting - Bars, Scales and Sets 7m
03 Transposing columns and rows, and #####s 3m
04 Inserting sparklines, and how to define a range 4m
05 Customising Sparklines 6m
06 Practice Activity Number 8 - The Solution 2m

01 Doing calculations without formulas 2m
02 Utilising the SUM function 3m
03 Formula syntax - SUM function 5m
04 Utilising the COUNT function 5m
05 Utilising the AVERAGE and other averaging functions 5m
06 Utilising the MIN and MAX functions 2m
07 Creating named ranges 5m
08 Getting help with functions 3m
09 Practice Activity Number 9 - The Solution 3m

01 Moving between tables and ranges 4m
02 Adding and removing cells within tables 3m
03 Formulas in tables 7m
04 Defining titles 5m

01 Inserting total rows 6m
02 Adding and removing styles and Banding rows and columns 6m
03 Practice Activity Number 10 - The Solution 2m

01 Setting up a filter and Filtering records 7m
02 More advanced filtering options 13m
03 Using sort options 6m
04 Sorting data on multiple columns; changing sort order 5m
05 Removing duplicates 6m
06 Inserting subtotals 5m
07 Creating outlines; collapsing groups of data in outlines 9m
08 Utilising the SUBTOTAL function 8m
09 Practice Activity Number 11 - The Solution 5m

01 Utilising the IF function 15m
02 Utilising the SUMIF function 5m
03 Utilising the COUNTIF function 4m
04 Utilising the AVERAGEIF function 3m
05 Evaluate Formulas 7m
06 Nested IFs 8m
07 The CHOOSE function 4m
08 Practice Activity Number 12 - The Solution 3m

01 Creating charts and graphs 4m
02 Adding and removing additional data series 3m
03 Exploring the Column charts 4m
04 Line, bar and area charts 4m
05 Pie charts 3m
06 Other graph types 5m
07 Switching between rows and columns in source data 2m

01 Adding legends 6m
02 Positioning and Resizing charts and graphs, inc 5m
03 Modifying chart and graph parameters 8m
04 Applying chart layouts and styles 2m

01 Inserting text boxes and positioning objects 3m
02 Inserting SmartArt 4m
03 Inserting ClipArt and images 3m
04 Inserting Screenshots 2m
05 Adding borders to objects 4m
06 Inserting shapes 4m
07 Adding styles and effects to objects 3m
08 Changing workbook themes 3m
09 Modifying object size and properties, including adding alternate text 5m

01 Making corrections to an image 3m
02 Using picture colour tools 2m
03 Send to front and back, and transparent colour 4m
04 Changing artistic effects on an image 2m
05 Crop picture 4m

01 Utilising the CONCATENATE function 5m
02 Utilising the RIGHT, LEFT and MID functions 6m
03 Utilising the LEN function 3m
04 Utilising the UPPER and LOWER functions 3m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.