Training Video Course

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

PDFs and exam guides are not so efficient, right? Prepare for your Microsoft examination with our training course. The MO-200 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft MO-200 test with flying colors.

Rating
4.47rating
Students
119
Duration
11:08:00 h
$16.49
$14.99

Curriculum for MO-200 Certification Video Course

Name of Video Time
Play Video: Curriculum
1. Curriculum
10:00
Name of Video Time
Play Video: Creating new blank workbooks
1. Creating new blank workbooks
3:00
Play Video: Entering data
2. Entering data
9:00
Play Video: An introduction to fonts and highlighting
3. An introduction to fonts and highlighting
6:00
Play Video: Saving and closing your workbook
4. Saving and closing your workbook
5:00
Play Video: Practice Activity Number 1 - The Solution
5. Practice Activity Number 1 - The Solution
3:00
Name of Video Time
Play Video: Creating new workbooks using templates
1. Creating new workbooks using templates
6:00
Play Video: Menus and toolbars
2. Menus and toolbars
7:00
Play Video: Managing multiple workbooks
3. Managing multiple workbooks
4:00
Play Video: Importing files and Opening non-native files directly in Excel
4. Importing files and Opening non-native files directly in Excel
10:00
Play Video: Adding worksheets to existing workbooks
5. Adding worksheets to existing workbooks
3:00
Play Video: Copying and moving worksheets, and changing spreadsheet order
6. Copying and moving worksheets, and changing spreadsheet order
6:00
Name of Video Time
Play Video: Saving workbooks in alternate file formats
1. Saving workbooks in alternate file formats
9:00
Play Video: Maintaining backward compatibility
2. Maintaining backward compatibility
5:00
Play Video: Saving files to remote locations
3. Saving files to remote locations
2:00
Name of Video Time
Play Video: Using basic operators
1. Using basic operators
6:00
Play Video: Order of operations
2. Order of operations
6:00
Play Video: How to enter numbers and dates in Excel
3. How to enter numbers and dates in Excel
4:00
Play Video: Referencing cell ranges in formulas
4. Referencing cell ranges in formulas
11:00
Play Video: Solution to the above exercise
5. Solution to the above exercise
2:00
Play Video: Practice Activity Number 2 - Solution
6. Practice Activity Number 2 - Solution
5:00
Name of Video Time
Play Video: Searching for data within a workbook
1. Searching for data within a workbook
5:00
Play Video: Hyperlinks
2. Hyperlinks
4:00
Play Video: Using Go To and Using Name Box
3. Using Go To and Using Name Box
5:00
Play Video: Hot Keys
4. Hot Keys
3:00
Name of Video Time
Play Video: Changing worksheet tab colour
1. Changing worksheet tab colour
3:00
Play Video: Inserting and deleting columns and rows
2. Inserting and deleting columns and rows
6:00
Play Video: Undo and Redo
3. Undo and Redo
4:00
Play Video: File Management tips
4. File Management tips
5:00
Play Video: Adjusting row height and column width
5. Adjusting row height and column width
4:00
Play Video: Hiding columns and rows
6. Hiding columns and rows
3:00
Play Video: Selecting multiple ranges
7. Selecting multiple ranges
3:00
Play Video: Practice Activity Number 3 - Solution
8. Practice Activity Number 3 - Solution
3:00
Name of Video Time
Play Video: Hiding worksheets
1. Hiding worksheets
3:00
Play Video: Customising the Quick Access toolbar
2. Customising the Quick Access toolbar
3:00
Play Video: Customising the Ribbon
3. Customising the Ribbon
5:00
Play Video: Assigning shortcut keys
4. Assigning shortcut keys
2:00
Play Video: Recording simple macros
5. Recording simple macros
5:00
Play Video: Managing macro security
6. Managing macro security
8:00
Play Video: Changing workbook views
7. Changing workbook views
3:00
Play Video: Using zoom
8. Using zoom
2:00
Play Video: Adding values to workbook properties
9. Adding values to workbook properties
3:00
Play Video: Displaying formulas
10. Displaying formulas
2:00
Play Video: Freezing panes
11. Freezing panes
4:00
Play Video: Splitting the window
12. Splitting the window
2:00
Play Video: Practice Activity Number 4 - The Solution
13. Practice Activity Number 4 - The Solution
3:00
Name of Video Time
Play Video: Printing individual worksheets
1. Printing individual worksheets
3:00
Play Video: Printing an entire workbook and printing a selection
2. Printing an entire workbook and printing a selection
2:00
Play Video: Setting a print area
3. Setting a print area
3:00
Play Video: Page setup, Part 1 (first two tabs)
4. Page setup, Part 1 (first two tabs)
4:00
Play Video: Page setup, Part 2 (Repeating headers and footers)
5. Page setup, Part 2 (Repeating headers and footers)
2:00
Play Video: Adding dynamic text to headers and footers
6. Adding dynamic text to headers and footers
3:00
Play Video: Inserting watermarks
7. Inserting watermarks
4:00
Play Video: Page setup, Part 3 (Headings etc.)
8. Page setup, Part 3 (Headings etc.)
5:00
Play Video: Configuring workbooks to print
9. Configuring workbooks to print
2:00
Play Video: Inspecting your workbook prior to distribution
10. Inspecting your workbook prior to distribution
4:00
Play Video: Practice Activity Number 5 - The Solution
11. Practice Activity Number 5 - The Solution
2:00
Name of Video Time
Play Video: Copying and pasting basics, and Utilising references (relative, mixed, absolute)
1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)
8:00
Play Video: Practice Activity - multiplication table
2. Practice Activity - multiplication table
2:00
Play Video: Answer - multiplication table
3. Answer - multiplication table
4:00
Name of Video Time
Play Video: Appending data to Excel worksheets
1. Appending data to Excel worksheets
3:00
Play Video: Setting data validation
2. Setting data validation
11:00
Play Video: Finding and replacing data
3. Finding and replacing data
7:00
Play Video: Copying and pasting data, including Paste Special
4. Copying and pasting data, including Paste Special
6:00
Play Video: Cutting and moving cell data
5. Cutting and moving cell data
4:00
Play Video: Using AutoFill tool, and Expanding data across columns
6. Using AutoFill tool, and Expanding data across columns
7:00
Play Video: Practice Activity Number 6 - The Solution
7. Practice Activity Number 6 - The Solution
3:00
Name of Video Time
Play Video: Modifying cell alignment and indentation
1. Modifying cell alignment and indentation
5:00
Play Video: Wrapping text within cells
2. Wrapping text within cells
4:00
Play Video: Merging cells and Shrink to Fit
3. Merging cells and Shrink to Fit
5:00
Play Video: Changing font and font styles
4. Changing font and font styles
5:00
Play Video: Applying highlighting
5. Applying highlighting
3:00
Play Video: Applying Number format
6. Applying Number format
10:00
Play Video: Applying borders
7. Applying borders
4:00
Play Video: Applying cell styles
8. Applying cell styles
2:00
Play Video: Using Format Painter
9. Using Format Painter
2:00
Play Video: Changing text to WordArt
10. Changing text to WordArt
1:00
Play Video: Practice Activity Number 7 - The Solution
11. Practice Activity Number 7 - The Solution
2:00
Name of Video Time
Play Video: Applying conditional formatting - highlighting
1. Applying conditional formatting - highlighting
11:00
Play Video: Applying conditional formatting - Bars, Scales and Sets
2. Applying conditional formatting - Bars, Scales and Sets
7:00
Play Video: Transposing columns and rows, and #####s
3. Transposing columns and rows, and #####s
3:00
Play Video: Inserting sparklines, and how to define a range
4. Inserting sparklines, and how to define a range
4:00
Play Video: Customising Sparklines
5. Customising Sparklines
6:00
Play Video: Practice Activity Number 8 - The Solution
6. Practice Activity Number 8 - The Solution
2:00
Name of Video Time
Play Video: Doing calculations without formulas
1. Doing calculations without formulas
2:00
Play Video: Utilising the SUM function
2. Utilising the SUM function
3:00
Play Video: Formula syntax - SUM function
3. Formula syntax - SUM function
5:00
Play Video: Utilising the COUNT function
4. Utilising the COUNT function
5:00
Play Video: Utilising the AVERAGE and other averaging functions
5. Utilising the AVERAGE and other averaging functions
5:00
Play Video: Utilising the MIN and MAX functions
6. Utilising the MIN and MAX functions
2:00
Play Video: Creating named ranges
7. Creating named ranges
5:00
Play Video: Getting help with functions
8. Getting help with functions
3:00
Play Video: Practice Activity Number 9 - The Solution
9. Practice Activity Number 9 - The Solution
3:00
Name of Video Time
Play Video: Moving between tables and ranges
1. Moving between tables and ranges
4:00
Play Video: Adding and removing cells within tables
2. Adding and removing cells within tables
3:00
Play Video: Formulas in tables
3. Formulas in tables
7:00
Play Video: Defining titles
4. Defining titles
5:00
Name of Video Time
Play Video: Inserting total rows
1. Inserting total rows
6:00
Play Video: Adding and removing styles and Banding rows and columns
2. Adding and removing styles and Banding rows and columns
6:00
Play Video: Practice Activity Number 10 - The Solution
3. Practice Activity Number 10 - The Solution
2:00
Name of Video Time
Play Video: Setting up a filter and Filtering records
1. Setting up a filter and Filtering records
7:00
Play Video: More advanced filtering options
2. More advanced filtering options
13:00
Play Video: Using sort options
3. Using sort options
6:00
Play Video: Sorting data on multiple columns; changing sort order
4. Sorting data on multiple columns; changing sort order
5:00
Play Video: Removing duplicates
5. Removing duplicates
6:00
Play Video: Inserting subtotals
6. Inserting subtotals
5:00
Play Video: Creating outlines; collapsing groups of data in outlines
7. Creating outlines; collapsing groups of data in outlines
9:00
Play Video: Utilising the SUBTOTAL function
8. Utilising the SUBTOTAL function
8:00
Play Video: Practice Activity Number 11 - The Solution
9. Practice Activity Number 11 - The Solution
5:00
Name of Video Time
Play Video: Utilising the IF function
1. Utilising the IF function
15:00
Play Video: Utilising the SUMIF function
2. Utilising the SUMIF function
5:00
Play Video: Utilising the COUNTIF function
3. Utilising the COUNTIF function
4:00
Play Video: Utilising the AVERAGEIF function
4. Utilising the AVERAGEIF function
3:00
Play Video: Evaluate Formulas
5. Evaluate Formulas
7:00
Play Video: Nested IFs
6. Nested IFs
8:00
Play Video: The CHOOSE function
7. The CHOOSE function
4:00
Play Video: Practice Activity Number 12 - The Solution
8. Practice Activity Number 12 - The Solution
3:00
Name of Video Time
Play Video: Creating charts and graphs
1. Creating charts and graphs
4:00
Play Video: Adding and removing additional data series
2. Adding and removing additional data series
3:00
Play Video: Exploring the Column charts
3. Exploring the Column charts
4:00
Play Video: Line, bar and area charts
4. Line, bar and area charts
4:00
Play Video: Pie charts
5. Pie charts
3:00
Play Video: Other graph types
6. Other graph types
5:00
Play Video: Switching between rows and columns in source data
7. Switching between rows and columns in source data
2:00
Name of Video Time
Play Video: Adding legends
1. Adding legends
6:00
Play Video: Positioning and Resizing charts and graphs, inc. moving charts into chart sheets
2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets
5:00
Play Video: Modifying chart and graph parameters
3. Modifying chart and graph parameters
8:00
Play Video: Applying chart layouts and styles
4. Applying chart layouts and styles
2:00
Name of Video Time
Play Video: Inserting text boxes and positioning objects
1. Inserting text boxes and positioning objects
3:00
Play Video: Inserting SmartArt
2. Inserting SmartArt
4:00
Play Video: Inserting ClipArt and images
3. Inserting ClipArt and images
3:00
Play Video: Inserting Screenshots
4. Inserting Screenshots
2:00
Play Video: Adding borders to objects
5. Adding borders to objects
4:00
Play Video: Inserting shapes
6. Inserting shapes
4:00
Play Video: Adding styles and effects to objects
7. Adding styles and effects to objects
3:00
Play Video: Changing workbook themes
8. Changing workbook themes
3:00
Play Video: Modifying object size and properties, including adding alternate text
9. Modifying object size and properties, including adding alternate text
5:00
Name of Video Time
Play Video: Making corrections to an image
1. Making corrections to an image
3:00
Play Video: Using picture colour tools
2. Using picture colour tools
2:00
Play Video: Send to front and back, and transparent colour
3. Send to front and back, and transparent colour
4:00
Play Video: Changing artistic effects on an image
4. Changing artistic effects on an image
2:00
Play Video: Crop picture
5. Crop picture
4:00
Name of Video Time
Play Video: Utilising the CONCATENATE function
1. Utilising the CONCATENATE function
5:00
Play Video: Utilising the RIGHT, LEFT and MID functions
2. Utilising the RIGHT, LEFT and MID functions
6:00
Play Video: Utilising the LEN function
3. Utilising the LEN function
3:00
Play Video: Utilising the UPPER and LOWER functions
4. Utilising the UPPER and LOWER functions
3:00

Microsoft Excel MO-200 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft Excel MO-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Microsoft MO-200 Premium Bundle
$29.98
$24.54

MO-200 Premium Bundle

  • Training Course: 146 Video Lectures
  • Study Guide: 179 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

MO-200 Premium Bundle

Microsoft MO-200 Premium Bundle
  • Training Course: 146 Video Lectures
  • Study Guide: 179 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$29.98
$24.54

Microsoft MO-200 Training Course

Want verified and proven knowledge for Microsoft Excel (Excel and Excel 2019)? Believe it's easy when you have ExamSnap's Microsoft Excel (Excel and Excel 2019) certification video training course by your side which along with our Microsoft MO-200 Exam Dumps & Practice Test questions provide a complete solution to pass your exam Read More.

Level 2, Section 2 - Format worksheets and workbooks

1. Changing worksheet tab colour

Hello, and welcome to level two, session two. I'm using a particular workbook, which is included in the resources for this video. It's the same workbook that we used in the previous session, but I'm including it as a resource just in case you skipped all the way to this particular video. Right, I've got three worksheet tabs down here, and I can change the default colour to something a bit more interesting by clicking and going to tab colour and then selecting the colour I want. So I could have a blue colour here and a green colour here, and that sort of thing.

And I'm not just limited to these 48 standard colors. I think there are more like 70 colours there. But you can click on more colors, and you get the colour wheel. Now, this colour wheel is a two-part dialogue box. You have a more extensive range of standard colours here, which start off white and go to different colours in every direction. Or you can click on Custom, and thisallows you to pick virtually any color. It's limited to around 16 million colors, but quite frankly, your eye can't see that many colours, so it's virtually any color. And you can hover over a colour to see what it would look like. And you can change the intensity. Or you can use the red, green, and blue bars to go from zero to 255.

So if I add a bit more red, you can see the colour develop gradually. Now it's changing more, getting more pink. So whichever the way you want towork with is fine by me. So you can pick a standard color or you can pick a variation of colours that are here. But this leads to the question: why would you want to colour your spreadsheets? What's the point of that? Well, different people all have different ideas. Here's my idea of working: I use a huge number of spreadsheets in my workbooks, some of them in one particular workbook. I may have 100 or 200 spreadsheets, and it's easy to get confused as to where you are. So I have a particular colour for the original data.

So any of my spreadsheets that have original data have a greenish color. And then maybe I will have a report. Well, I have my report pages, just generally without color. But there may be section headings in Section 1, Section 2, and Section 3. So I put these as a blue color, and so Ican navigate through all of these tabs and go, oh, there'sa section two, and it's probably called section two, but it'sprobably quite useful if it's in a blue color. So that's how my eye is instantly drawn to it. And I might have another colour for charts, let's say graphs. So I could go, "Oh, this is a chart that contains a pie chart, or this one contains data." This is a divider, however useful. You use these colors. It is actually quite useful in a big spreadsheet to have a constant system. So whatever works for you So this is how to add colours to tabs, and perhaps more importantly, why?

2. Inserting and deleting columns and rows

Now I've got an existing spreadsheet here, and I might want to say I want to insert a new row or I need to insert a new column. Maybe I want something in between file extensions and attributes. No problem. What I need to do is go to Insert Cells. So on the home page, I can go to Cells Insert. And here you can see that I can insert a single cell.

If I highlight a column by clicking on the letter name of the column, then I can insert a column. And if I highlight a row, I can insert a row. So here we go. Click on a column to insert it, click on a cell to insert sheet rows, and rows and columns are inserted. Now everything gets pushed down. So row eleven becomes row twelve. Row twelve becomes row 13 and so forth. So we're inserting, but it's not in the insert menu because it's so common that the designers have put it in the home menu. Now if you wanted to delete the columns, then you've got this delete drop down box so I can delete rows. So raw 12 becomes 1113 becomes 12, and anything that was in the raw gets removed. And similarly, I can delete a column. So column F becomes column e, column G becomes column H, and so forth. The fact that data can change what's written means that it's very dangerous to talk to somebody about it. Did you see that thing on row 14? Because by then, if it's two weeks later, row 14 might no longer be in row 14.

So I generally use an ID column, so I can say ID number 21. And then it doesn't matter whether it happens to be on row nine or row ten. Now suppose I wanted to highlight three columns. So, say I wanted three columns between D and E. Well, I highlighted "e" and I'm still clicking the mouse button, if not unclicking it yet. And I scroll across so that three columns are highlighted. And now I release the mouse button, and now I can go to insert, which is part of the home. So home insert, insert sheet columns, and I can do the same thing with rows: highlight three rows, go to insert sheet rows, and it's the same for deleting. I can highlight the columns and go to "delete." Now there is another way of inserting and deleting cells, and that is by clicking where you are. So I've just highlighted e, f, and g. I'm going to click right, and I've got delete. Now it's not telling me that these are deleting columns. You've just got to work that out for yourself. So if I click "delete," it will delete the three columns. And similarly for the raws, I can right-click and click delete, and that deletes those three rows. So the multiple ways of being able to insert or delete individual rows—whichever works for you—are the ones that you should use.

Now, you can also insert or delete sheets, but that can be done easily enough by clicking on the plus button at the bottom, left or right, and then clicking and going to delete or insert. Now you can be a bit more flexible, and you can insert additional cells without inserting additional rows or columns. So suppose I want to insert a new cell here in B-5. Well, if I go to insert cells, it tells me, OK, you want to insert a cell, but what do you want me to do? Do you want me to insert a cell in B 5 in B 6 and move all of the other cells down? So B six becomes B seven, and B seven becomes B eight. Do you want me to shift all of the cells across so B-6 becomes C-6, C-6 becomes D-6, and so forth? Or do you want me to insert an entire row or an entire column? And again, you can get this using the right-click context menu. So there is a bit of a danger in inserting an individual cell because, remember, I said I like to look at individual IDs. So ID 18 is this piece, Ras Los Aliba. If I were to insert a new cell and shift the initial cells down, the existing cells would also shift down, and ID 18 would no longer be rasalobe libra; it would now be ID 19. So use with caution. If you are adding data to an existing spreadsheet, you may be better off inserting a row or inserting a column instead of just inserting individual cells.

3. Undo and Redo

Now, if you delete raws that have existing data or columns that have existing data, you can't just insert a new raw and expect a date to come back. It's gone. However, you can use the undo function (undo or CTRL and Z), which is the closest letter on my keyboard to the control key is the undo.It's my fault; I've made a mistake. Help me. And you'll also see it up here as well. It's so common. This is the quick access toolbar, which we'll get to later. And it's such a common feature that Microsoft wants you to be able to see it all the time. So clicking on "do my insertion of a row," then clicking "do again," undoes my deletion of a row. So we've got our data pack.

So it's very handy, and, oh my goodness, I've just done something wrong. And similarly, this is the undo button. What this? Does it recover what you have done? So, let's take an example. I'm going to type the phrase "hello." My name is Fred. So hello My name is Fred. Oh dear. I want to insert a new column and put in the word "name." Okay, so I'll insert it in the column, and I'll put in the word name. If I undo this, I will get rid of my typing in the word "name." So there goes my insertion. If I undo again, I will have uninsured the additional row. Now, if I want to say that the undo was a mistake and I want to redo it, I will click the redo button. So now I've reinserted the column, and now I've reinserted the name, the word name. So undo is getting rid of the last action you've done, and redo is getting rid of the undo that you've just done. Now there is a dropdown next to "undo" and a dropdown next to "redo. This shows me a list of actions that I have taken, and I can undo not just the latest action but the latest two actions or the latest three actions. And you'll see at the bottom that it says to undo 32 actions at the moment.

So it really keeps a good memory. So if I undo the last five actions, it will undo my typing of "Fred is my" and inserting a column. So I just get the word "hello." Now I can redo this, and here are these five actions that I can redo. So I'm just going to undo one particular action. So I've got hello. My name is Fred. And what I've done is take the word "name" and just undo it. Now I can undo it and put the nameword back at the moment I have undone it. So it's. Hello. My name is Fred. Now, suppose I were to put a period at the end, a full stop. I can't anymore redo my action. So I can no longer get the computer to put in the word "name." So as soon as you have done something new, the redo list clears. So there's no way I'm going to be able to go back and get the computer to put in a name, because as soon as I undo an action, that's the action it thinks you want me to undo when I click redo. So in other words, if you want to undo something that you've just undone, you need to do it immediately. If you start doing something else in Excel, the undo list gets wiped. So undone is my hope. I've just done something wrong, and it's controlled and said, and there's also a redo that is controlled, which is why the letter just before said undo.

4. File Management tips

So Now, for this reason—that the redo gets wiped—it's for me a good idea to keep backups. Now, you may remember a little while ago that I suggested that when you save an item, a spreadsheet, or a workbook, you save it with today's date. So, if today's date is January 1, 2020, then I would put 20 or 1 or 1, or if it's January 2020, the second 20 or 1 or 2 year month date, and then I would keep on editing. But suppose I made a mistake later on and wanted to go back to this version. Well, if I kept saving all the way through the day, I couldn't go back to an earlier version during this particular day. In fact, there is a way, but I'll show you that a little bit later.

So what do I do? I work it out, okay. When is the time that it would cause me the most amount of annoyance to have to redo my work? And I reckon it's around 2 hours. So after about 2 hours, I'm going to file savers, and it's still the same day, still January 2, 2020. But now I'm going to put two after it, and then I'm going to work for another couple of hours, and then I'm going to save it as three. Why do I do this? Why do I create all of these different-named spreadsheets? The reason is what happens if I accidentally save it at 09:00 in the morning, and accidentally at 10:00, I delete this row, and I then save two at 11:00 and three at 01:00.

And then I suddenly realized, "Oh my goodness, at 10:00 I deleted this row; I need to get it back." Well, then I would open up the original from January 20, which still has this raw file that I accidentally deleted. I'm very big in terms of keeping multiple versions of spreadsheets so that as you develop them over time, you can go backwards to almost undo a problem that occurred because, for instance, the spreadsheet got corrupted and you can't open it. And this happens with some of my larger spreadsheets from time to time; it just refuses to load. And you think, "Ah, I lost all of this work." But if you saved it and put in today's date and put in 2, 3, 4, you'll only have lost about 2 hours. And every time I save it, I think, "Oh my goodness," what would happen if I lost the work I just put in? I just incremented the number. So sometimes I go up to 1112, and that's fine because spreadsheets are really small, so you can keep multiple backups without your hard drive becoming full. Now, what I also do then is create an "old" folder because obviously there are now a lot of spreadsheets.

And so I noticed incidentally that it is now in alphabetical order and it's in date order because that's the way the Japanese system works; the dates become the right order if I were to save it with tomorrow's date, the 3 January, which would come at the bottom of the list. If I were to save it for next month's date. So 2020, or two or one, would still come at the bottom of the list if I were to save you with next year's date. So whether it's 2021 or 101, it's still at the bottom of the list. So what I do is drag older versions into the old folder, and then I'm just left with one version in my folder, but I can always go back to earlier versions if I remember which ones I saw. So I can go back in time, but it's not cluttering up my main folder. So file management is important. When you start inserting and deleting columns, you might accidentally delete something important and want to go back in time. So make sure that if the worst happens, you are able to rectify your mistakes. So the first thing you should use is the undo button. But if you've got good file management, you'll be able to go back in time and retrieve something from several hours ago.

Prepared by Top Experts, the top IT Trainers ensure that when it comes to your IT exam prep and you can count on ExamSnap Microsoft Excel (Excel and Excel 2019) certification video training course that goes in line with the corresponding Microsoft MO-200 exam dumps, study guide, and practice test questions & answers.

Comments (0)

Add Comment

Please post your comments about MO-200 Exams. Don't share your email address asking for MO-200 braindumps or MO-200 exam pdf files.

Add Comment

Purchase Individually

MO-200  Training Course
MO-200
Training Course
146 Lectures
$16.49 $14.99
MO-200  Study Guide
MO-200
Study Guide
179 Pages
$16.49 $14.99

Microsoft Training Courses

Technology Literacy for Educators Training Course
62-193
Technology Literacy for Educators
$14.99
Windows Operating System Fundamentals Training Course
98-349
Windows Operating System Fundamentals
$14.99
Designing and Implementing a Microsoft Azure AI Solution Training Course
AI-102
Designing and Implementing a Microsoft Azure AI Solution
$14.99
Microsoft Azure AI Fundamentals Training Course
AI-900
Microsoft Azure AI Fundamentals
$14.99
Microsoft Azure Administrator Training Course
AZ-104
Microsoft Azure Administrator
$14.99
Planning and Administering Microsoft Azure for SAP Workloads Training Course
AZ-120
Planning and Administering Microsoft Azure for SAP Workloads
$14.99
Configuring and Operating Microsoft Azure Virtual Desktop Training Course
AZ-140
Configuring and Operating Microsoft Azure Virtual Desktop
$14.99
Developing Solutions for Microsoft Azure Training Course
AZ-204
Developing Solutions for Microsoft Azure
$14.99
Microsoft Azure Architect Technologies Training Course
AZ-303
Microsoft Azure Architect Technologies
$14.99
Designing Microsoft Azure Infrastructure Solutions Training Course
AZ-305
Designing Microsoft Azure Infrastructure Solutions
$14.99
Designing and Implementing Microsoft DevOps Solutions Training Course
AZ-400
Designing and Implementing Microsoft DevOps Solutions
$14.99
Microsoft Azure Security Technologies Training Course
AZ-500
Microsoft Azure Security Technologies
$14.99
Designing and Implementing Microsoft Azure Networking Solutions Training Course
AZ-700
Designing and Implementing Microsoft Azure Networking Solutions
$14.99
Administering Windows Server Hybrid Core Infrastructure Training Course
AZ-800
Administering Windows Server Hybrid Core Infrastructure
$14.99
Configuring Windows Server Hybrid Advanced Services Training Course
AZ-801
Configuring Windows Server Hybrid Advanced Services
$14.99
Microsoft Azure Fundamentals Training Course
AZ-900
Microsoft Azure Fundamentals
$14.99
Designing and Implementing a Data Science Solution on Azure Training Course
DP-100
Designing and Implementing a Data Science Solution on Azure
$14.99
Data Engineering on Microsoft Azure Training Course
DP-203
Data Engineering on Microsoft Azure
$14.99
Administering Microsoft Azure SQL Solutions Training Course
DP-300
Administering Microsoft Azure SQL Solutions
$14.99
Microsoft Azure Data Fundamentals Training Course
DP-900
Microsoft Azure Data Fundamentals
$14.99
Microsoft Dynamics 365 for Sales Training Course
MB-210
Microsoft Dynamics 365 for Sales
$14.99
Microsoft Dynamics 365 Customer Service Functional Consultant Training Course
MB-230
Microsoft Dynamics 365 Customer Service Functional Consultant
$14.99
Microsoft Dynamics 365 for Field Service Training Course
MB-240
Microsoft Dynamics 365 for Field Service
$14.99
Microsoft Dynamics 365 Finance Functional Consultant Training Course
MB-310
Microsoft Dynamics 365 Finance Functional Consultant
$14.99
Microsoft Dynamics 365 Business Central Functional Consultant Training Course
MB-800
Microsoft Dynamics 365 Business Central Functional Consultant
$14.99
Endpoint Administrator Training Course
MD-102
Endpoint Administrator
$14.99
Microsoft Word (Word and Word 2019) Training Course
MO-100
Microsoft Word (Word and Word 2019)
$14.99
Microsoft Excel (Excel and Excel 2019) Training Course
MO-200
Microsoft Excel (Excel and Excel 2019)
$14.99
Microsoft Excel Expert (Excel and Excel 2019) Training Course
MO-201
Microsoft Excel Expert (Excel and Excel 2019)
$14.99
Microsoft 365 Administrator Training Course
MS-102
Microsoft 365 Administrator
$14.99
Microsoft 365 Messaging Training Course
MS-203
Microsoft 365 Messaging
$14.99
Managing Microsoft Teams Training Course
MS-700
Managing Microsoft Teams
$14.99
Microsoft 365 Fundamentals Training Course
MS-900
Microsoft 365 Fundamentals
$14.99
Microsoft Power Platform App Maker Training Course
PL-100
Microsoft Power Platform App Maker
$14.99
Microsoft Power Platform Functional Consultant Training Course
PL-200
Microsoft Power Platform Functional Consultant
$14.99
Microsoft Power BI Data Analyst Training Course
PL-300
Microsoft Power BI Data Analyst
$14.99
Microsoft Power Platform Developer Training Course
PL-400
Microsoft Power Platform Developer
$14.99
Microsoft Power Platform Fundamentals Training Course
PL-900
Microsoft Power Platform Fundamentals
$14.99
Microsoft Cybersecurity Architect Training Course
SC-100
Microsoft Cybersecurity Architect
$14.99
Microsoft Security Operations Analyst Training Course
SC-200
Microsoft Security Operations Analyst
$14.99
Microsoft Identity and Access Administrator Training Course
SC-300
Microsoft Identity and Access Administrator
$14.99
Microsoft Information Protection Administrator Training Course
SC-400
Microsoft Information Protection Administrator
$14.99
Microsoft Security, Compliance, and Identity Fundamentals Training Course
SC-900
Microsoft Security, Compliance, and Identity Fundamentals
$14.99

Microsoft Certifications

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training 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

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

UP

LIMITED OFFER: GET 30% Discount

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 30% Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.