BestSeller
Best Seller!
$27.49
$24.99
MO-200: Microsoft Excel (Excel and Excel 2019)

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

MO-200: Microsoft Excel (Excel and Excel 2019) Certification Video Training Course includes 146 Lectures which proven in-depth knowledge on all key concepts of the exam. Pass your exam easily and learn everything you need with our MO-200: Microsoft Excel (Excel and Excel 2019) Certification Training Video Course.

142 Students Enrolled
146 Lectures
11:08:00 hr
$27.49
$24.99

Curriculum for Microsoft Excel MO-200 Certification Video Training Course

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

The Complete Course from ExamCollection industry leading experts to help you prepare and provides the full 360 solution for self prep including MO-200: Microsoft Excel (Excel and Excel 2019) Certification Video Training Course, Practice Test Questions and Answers, Study Guide & Exam Dumps.

Level 1, Section 4 - Basic formulas

2. Order of operations

Now, it's very rare that you'll just have two numbers in a formula. You'll probably have more. So let's do another one. Another formula equals seven times eight plus six. Hang on, is it going to do seven times six, which is 56, and then add six to it, which is 62, or is it going to do eight plus six, which is 14 first, and then multiply by seven, which is 98? Well, let's see what it does. Right, 62. So it does seven times eight plus one, then first, and then does plus or minus six. So I'll just put this formula here as a description. There we go. So, what happens if we do it the other way around? So that equals six plus seven times eight. Will it now do the six plus seven first, which is 13, and multiply by 98, which is 104? What do you think it's going to do? Let's see if you're right. and the answer is 62. And again, this is the reason this is called the order of operations. And what this means is that, first of all, Excel reduces power. So if you give something to a computer's formula, it will start with powers. Now, another way of describing powers is exponential. So eight to the power of two is an exponential operation. Then it will do multiplication, then division, addition, and finally subtraction. But how are you going to remember all this? Oh, please excuse my dear Aunt Sally. So please excuse my dear Aunt Sally. You'll notice that the first letter of each of these represents a letter from Please excuse my day and Sally, exponential multiplication, division, addition, and subtraction. So what does the P stand for right at the beginning? Well, P stands for parentheses, also known as brackets. And there is an alternative way of remembering this, which has the B for brackets, and it's called odd mass. So we have division and multiplication and addition and subtraction. So it depends on how you've learned it. Please excuse my dad. Inform me or bod mass. So what are these brackets that we've just been talking about? Well, these allow you to tell the computer exactly what order you want a formula to be done in. So let's have a look at this formula. For instance, seven times eight plus six So what I could do is put brackets around the seven times eight. So I'm telling the computer to do seven times eight first and then add the six. So it's not changing the answer, but the actual expression may look a bit clearer now that you know it's going to do multiplication before addition. It hasn't fundamentally changed anything, but it has made something clear to ourselves. Now, what if I wanted to change that and say it equals seven times open bracket eight plus six? Will that change anything in the answer, or will it come back as 62 again? and the answer is yes. We are asking it to work out the expression that's in the brackets: first eight plus six, making 14, and then multiply 14 by seven, giving us the answer of 98. Now, we're not just limited to one set of brackets. We could say that equals seven times the number of brackets, four plus brackets, four plus brackets, six if you wanted to, a lot of unnecessary brackets, but it will allow us to do that. So it will take four plus six with the ten-added number 414 and multiply it by 798. Now, notice what happened when I was looking at and editing all of this. You can see that the brackets and parentheses have different colors. Some brackets are red and some are green, though that's a bit more difficult to see. The inmost brackets are purple. So what's happening? Well, the computer is colouring different inner brackets, so these two brackets become purple, and then the next two become red, so you can see more easily what's going on. So if I were to type in "equals one plus brackets," two plus brackets," three plus brackets," four," Notice what's happening down here in the results area. The brackets are being coloured different colors, and you can see when you're on the outermost one because the last bracket is a black color. It's just a helpful way the computer is helping me. All of these brackets, of course, are not actually needed because it's going to do all of the additions. It wouldn't make any difference in which order all of the additions are made, but it might be necessary if you're going to change one of these additions to a multiplication. So it could just be helpful for you to insert brackets or for the person that you're giving this spreadsheet to. To be 100% clear, what you've put in the formula is exactly what you mean. So please excuse my dear Aunt Sally.

3. How to enter numbers and dates in Excel

Now, a quick word about how to enter numbers and how to enter dates. Now, we saw earlier that eight is the power of a half. Now, it could be that you're using a locale that doesn't use the full stop as a decimal point. So for you, it might be "equal eight kara," not "comma five." and you can see which locale you're in. If you go to the Start menu and go to the Control Panel and I click on View by Lodge Icons, I can go down to the Region section and you can see that I'm set up for English in the United States. So my short date is "month followed by date, followed by year," for instance. And if I click on Additional Settings down here, you can see that the decimal symbol is a full stop. Now, I can change that if I so wish, but really the key point of this is how to enter data. It's entirely based on how your computer is set up. For example, we have the Digit Grouping System symbol being a comma over here in this American locale. So if I type in the number one, comma two, three, and four, that's perfectly acceptable. And the computer will interpret that on my system as 1234. You can see that it doesn't have the comma in the formula bar, but it has been retained in the formatting of the results. If I were in France and typed one comma, two, three, and four, it would assume that I meant one and decimal places. In France, a number just under one and a quarter means 1234, whereas one dot two, three, and four mean 1234. So this is an instant reason why I prefer to type numbers without the commas and without the thousand separators. So I could type 1234. I could type one comma, two, three, and four. The underlying number is still the same in my American system. Now, for dates, you have to enter them as per your locale. So suppose I want to the 1 February 2020. Well, in America, I'll type "two commas, zero, one, 2020." If I were in England, then I'd type one domain comment with slashes—one slash, two slashes. Alternatively, I could use hyphens: one hyphen February or Fed.Hyphen 1020. If I was in Japan, I'd be typing 2020. Basically, whatever way you do it is acceptable as long as it correlates with the region that your computer thinks you're in. And also, while I'm on the subject of putting things in formulas, you can also type in a percentage time. So you could say five equals 5% multiplied by 400. That's perfectly acceptable as well. So that will calculate at 0.05, multiply by 400, and that's 20. So the percentage sign is just shorthand for "divide by 100."

4. Referencing cell ranges in formulas

So far, so good. We've worked out how to use all of these basic operators, but this is technically anything that a calculator can do. So what's so special about Excel? Well, let's just rename this sheet so I can come back to it later and know that it's the operator sheet. And I'll open up a new sheet, and I'm going to call this cells. So that just happens to be the name of the spreadsheet. So I'm going to put in a number here. Now I want this number doubled. So a double number equals four times two, or eight. So far, so good. Except when I changed my original number in that cell from four to six, my answer doesn't change; it still equals four times two. And the problem lies in that I have hardcoded this four-digit number that's in the formula. Now, quite often I try to avoid hardcoding any figures simply because I want to change them later. And it might make it easier if I could actually see the figures on screen rather than having to hunt for them in formulas. So instead of referring to a particular number four, I want it to refer to this particular four that is in a different cell. So I can't just say, "Well, give me this cell right here." I've actually got to give it a name. And the name that Excel has come up with is give each column a letter ABCD" and give each row a number, 1234." And so what you have in a particular cell is a particular column letter and then a raw number. And it's always that way. Column number first, column letter first, and then row number. Now, if you're used to geometry, then you know it's the other way around. You put in the X axis first and then the Y axis. Whereas in Excel we do completely the way around. We put in the column first and then the row. So this cell is cell D three. And you can also see it's D-3 because it says so here in the name box. When I click on the cell, it says D three.So I want to change my formula to equal four times two. This four should be changed to a reference to D three. So what I'm going to do is just type in "D three." Now notice what happens instantly. The cell D three becomes blue. It's got blue cursor square around it. And also notice that in the formula box, formula barD 3 is now in blue as well. Those two relating to each other. So when I press Enter, will the three remain blue? No. But what's happened now is that the cell is accessing what's in cells D 2 to D 3, doubling it, and giving me that answer in cell D 4. Well, it looks the same. But now I can change what is in cell D three.So I'll change that to six, and I can move to a different cell, a completely different cell. As a result, the formula becomes twelve six times two. Now, I didn't have to do anything. I didn't have to click Refresh. I didn't have to go into the formula and press Enter again. It's all automatic. Now, if I want to change this formula again, I can click inside the formula bar and notice what happens. Nothing yet. But click inside the formula bar, and cell D3 becomes blue again. Now suppose I have another number over here. So I've just typed in the number ten into what cell? E three. Now suppose I don't want my formula anymore to referto D three, I want to refer to e three. Well, I could go into the formula and just changethe number, the reference from D three to e three. So now, you can see the blue has changed location. But there is another way. If I go into the formula bar, you can see this box around D 3. Well, I can drag the top part. Don't drag the actual squares, but drag the line to a different cell and notice what happens in the formula bar; the reference changes. So press Enter, and the blue disappears. But we have the new formula, "Equals e three times two." Let's change that back, click inside, and drag the cell reference. Technically, this means that D-3, the highlighted cell, is a predecessor, a precedent of D-4. In other words, D four relies on D three. Therefore d three is a precedent of D four. And D four is dependent on D three. So we have precedence and dependence. Now, I can say "add one to this number." So I want set D three, set D four, and I want to add one. So I'm going to type in the equal sign. And now I'm going to click on 04:00 a.m. I'm going to finish editing the formula. No, because as soon as I type in the equal sign, the computer switches to formula mode. And when I'm still editing a formula and click on another cell, it's going to bring back a reference to that cell. So I've just typed in equals. I've clicked on D four, and now theformula equal is now equals D four. So now I want to add on to it. Get the answer 13. So I've got a formula that is dependent on another formula, which is dependent on a value. We can make this more complicated by adding both numbers together. So I want to add D four and D five. So equals D four plus D five. Notice. Now D five is in red. And if I edit in the formula bar, you can seethat D five, the reference in the formula, is also red. So this is how the computer is attempting to assist you by indicating that you are saying "D-5." I'll show you where D-five is on the screen. Follow the same color. So with all of this, we can use the same operators that we had: subtraction, multiplication, division, and exponential. That's the power of adding brackets. So what I'd like you to do is a little exercise. So I'm going to add a new cell, a new sheet. I'm going to call it exercise. So I want you to type in the number three. So I'm just going to do it for you there. And then I want you using formulasin the same way that we've done. That refers to cells. Where possible, I want you to double the number. As a result, three times two equals six. I want you to add four. So that makes ten. Subtract two; that will make eight. And then in just one formula, add four, then multiply by six. And then subtract the first three digits that you see on the screen. So the answer you should be getting is 69. So we're getting three, then six, then ten, then eight, then eight. Add four to twelve. Multiplying by six is 72. And then subtract the first number to make 69. But I want you to do this using formulas that refer to other cells. So I'm going to save this right now. So save the file as "browse." going to add a new folder. Level one, session four. Level one, session four. And I'm going to add this as a resource to this video. So if you go into your videos, you can see the exercise that I've just paused in the video. If I click on the little icon in the top left, I will have a little reference like this music list that has this particular sheet, this particular workbook, and you can open it up and do this exercise. Now, if you've got any questions about this exercise, please let me know. Please send me a message and I'll get back to you. So if you want to send me a message, you can do so by clicking Browse Q&A and typing in your message there. And if you are so inclined, could you please review this course? So go back to the dashboard and put your review up here. Five stars, four and a half stars if you think it's great. Five stars. If you don't think it's great, let me know why. Because I would like the next course to be even better for you. So please download this workbook. Please try all of these formalities, and good luck. I'll see you in the next video.

5. Solution to the above exercise

So how did you do? So let's have a look at some of the answers. Now, your answers might be different. As long as they're getting the same results for the same reason, they'll be fine. So doubling the number equals d two times two; adding four equals d three. Three plus four, from which two are subtracted, equals four minus two. Now adding four and then multiplying by six, I'm hopingyou didn't put equals d five plus four multiplied bysix, because that won't give you the answer that Isaid it was 72 instead, that will give you 32. And the reason for that comes down to odd numbers. Oh, please excuse my dear Van Sally, it's doing the multiplication first before the addition. So, if this is how you did it, please pause the video and consider how you can get it. So it adds four first and then multiplies by six. And hopefully you came up with the answer of putting brackets or parentheses around "five plus four." So we have equal open brackets and five plus four closed brackets. Do that first and then multiply by six. The answer is 72, and then subtract the first number. So that equals d six minus d two. So the first number that we had was the number three, and that gives me 69. So now, apart from these hardcoded figures like times two and plus four, everything is dependent on d two.So if I change two, then the answer will change. So I hope you enjoyed that. I hope you found it useful. And now let's go on to a new practise activity.

6. Practice Activity Number 2 – Solution

So how did you do? So let's see how I handled this. First of all, create a new workbook using an invoice template. So I'm going to go to "File New" and I'm just going to look for the word "invoice"—it doesn't really matter—and press Enter. It doesn't really matter what particular invoice I'm going to use. I will click on that and create. Now attached to these instructions is aresource called the Music List text file. So I need to open that up in Excel. So, file open, and here's my previously downloaded MusicList text file. and it's asking what sort of file this is. Well, hopefully you can see from the preview that it is not fixed width because the second column is not lining up correctly. So it's delimited and it's tab delimited. So there we go. So click next. Click. Finish. Display both of these on the screen at the same time. There are lots of different ways you can do that. I've gone through a few ways. So here is one way. I'm just going to drag the sides so I can see both on the screen at the same time while seeing all of my instructions. Add a new spreadsheet to the musicalist workbook. So I'm just going to give it a bit more space. And I want a new spreadsheet, and I've got a new tab. So just click on this plus sign to move this newssheet tab to before the music list spreadsheet tab. So I'll just drag it. Alternatively, I could have gone to the right and clicked on move or copy, which would have moved it ahead of the Music list. In this blank spreadsheet, enter the following values in cells A one, B one, and C one. So you have to actually identify whatis aone b one and C one. So that's 410 and 30. I'm using Tab to go in between them, but you could use the arrow keys as well. In selling a two into a formula that returns the value, which is a one to the power of two, As a result, one Cadillac equals shift six two. In B two, enter a formula which returnsa value which is double the value ofcell B one equals B one times two. In cell C 2, enter a formula that subtracts two from the value in cell C 1 and then divides by two. The answer should be 14. So hopefully you worked out that what you have to do is use brackets because you're doing c minus two and then dividing by two. So equals open brackets c one minustwo, closed brackets divided by two. in cell d one.Enter the date the 1 January 2019as a date rather than text. So I didn't want you to type 1 January 2019 literally, but rather all one slash or one slash 2019, unless you're in Japan, in which case 2019 one one. Save the workbook in binary form as my second practise activity. So I'll save the file as I navigate to a suitable folder. So in level one, session four, I need to save it as a binary-form workbook XLSB, and I'm going to call it my second practise activity. And click Save, and you can see the name right at the top. So how did you do? This is the culmination of this level. So hopefully you are confident with the skills that you have learned so far, and if so, I'll see you in level two. If not, then the great thing about this video course is that you can go back to previous videos and go, so what did Philip actually mean in that bit? And perhaps a second opinion, yougo, oh, that's what he means. So that's the great thing about this video call service. So to go to a different video, just click on the little icon on the top left and click on whatever video you want to go to, and it plays. So either way, thank you very much for joining me, and I'll see you in the next video.

Read More

Comments
* The most recent comment are at the top

Add Comments

Feel Free to Post Your Comments About EamCollection's Microsoft Excel MO-200 Certification Video Training Course which Include Microsoft MO-200 Exam Dumps, Practice Test Questions & Answers.

Similar Microsoft Video Courses

Administering a SQL Database Infrastructure
113
4.4
9 hrs
70-764 - Administering a SQL Database Infrastructure
Administering Microsoft Azure SQL Solutions
129
5.0
14 hrs
$24.99
DP-300 - Administering Microsoft Azure SQL Solutions
Administering Microsoft System Center Configuration Manager and Cloud Services Integration
132
4.5
4 hrs
70-703 - Administering Microsoft System Center Configuration Manager and Cloud Services Integration
Administering Windows Server 2012
451
4.5
8 hrs
70-411 - Administering Windows Server 2012
Administering Windows Server Hybrid Core Infrastructure
119
5.0
18 hrs
$24.99
AZ-800 - Administering Windows Server Hybrid Core Infrastructure
Analyzing and Visualizing Data with Microsoft Excel
135
4.6
5 hrs
70-779 - Analyzing and Visualizing Data with Microsoft Excel
Analyzing and Visualizing Data with Microsoft Power BI
102
4.3
11 hrs
70-778 - Analyzing and Visualizing Data with Microsoft Power BI
Analyzing Data with Microsoft Power BI
137
5.0
1 hr
$24.99
DA-100 - Analyzing Data with Microsoft Power BI
Architecting Microsoft Azure Solutions
129
4.5
1 hr
70-535 - Architecting Microsoft Azure Solutions
Architecting Microsoft Azure Solutions (70-534)
516
4.6
1 hr
70-534 - Architecting Microsoft Azure Solutions (70-534)
Cloud Fundamentals
124
4.6
1 hr
98-369 - Cloud Fundamentals
Configuring Advanced Windows Server 2012 Services
198
4.6
8 hrs
70-412 - Configuring Advanced Windows Server 2012 Services
Configuring and Operating Microsoft Azure Virtual Desktop
102
5.0
6 hrs
$24.99
AZ-140 - Configuring and Operating Microsoft Azure Virtual Desktop
Configuring Windows Devices
285
4.6
16 hrs
70-697 - Configuring Windows Devices
Configuring Windows Server Hybrid Advanced Services
136
5.0
19 hrs
$24.99
AZ-801 - Configuring Windows Server Hybrid Advanced Services
Core Solutions of Microsoft Exchange Server 2013
102
4.6
1 hr
70-341 - Core Solutions of Microsoft Exchange Server 2013
Core Solutions of Microsoft SharePoint Server 2013
97
4.5
1 hr
70-331 - Core Solutions of Microsoft SharePoint Server 2013
Data Engineering on Microsoft Azure
115
5.0
10 hrs
$24.99
DP-203 - Data Engineering on Microsoft Azure
Database Fundamentals
94
4.5
3 hrs
$24.99
98-364 - Database Fundamentals
Deploying Microsoft 365 Teamwork
126
4.6
1 hr
MS-300 - Deploying Microsoft 365 Teamwork
Deploying SharePoint Server Hybrid
93
4.5
1 hr
MS-301 - Deploying SharePoint Server Hybrid
Designing an Azure Data Solution
87
4.5
5 hrs
DP-201 - Designing an Azure Data Solution
Designing and Deploying Microsoft Exchange Server 2016
144
4.4
2 hrs
70-345 - Designing and Deploying Microsoft Exchange Server 2016
Designing and Implementing a Data Science Solution on Azure
132
4.6
9 hrs
$24.99
DP-100 - Designing and Implementing a Data Science Solution on Azure
Designing and Implementing a Microsoft Azure AI Solution
113
5.0
5 hrs
$24.99
AI-102 - Designing and Implementing a Microsoft Azure AI Solution
Designing and Implementing an Azure AI Solution
125
4.5
2 hrs
AI-100 - Designing and Implementing an Azure AI Solution
Designing and Implementing Cloud Data Platform Solutions
104
4.5
1 hr
70-473 - Designing and Implementing Cloud Data Platform Solutions
Designing and Implementing Microsoft Azure Networking Solutions
87
5.0
5 hrs
$24.99
AZ-700 - Designing and Implementing Microsoft Azure Networking Solutions
Designing and Implementing Microsoft DevOps Solutions
135
4.5
2 hrs
$24.99
AZ-400 - Designing and Implementing Microsoft DevOps Solutions
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
131
4.5
4 hrs
70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Designing Database Solutions for Microsoft SQL Server 2012
130
4.5
6 hrs
70-465 - Designing Database Solutions for Microsoft SQL Server 2012
Designing Microsoft Azure Infrastructure Solutions
94
5.0
8 hrs
$24.99
AZ-305 - Designing Microsoft Azure Infrastructure Solutions
Developing Microsoft Azure Solutions
367
4.6
1 hr
70-532 - Developing Microsoft Azure Solutions
Developing Microsoft SharePoint Server 2013 Core Solutions
100
4.5
1 hr
70-488 - Developing Microsoft SharePoint Server 2013 Core Solutions
Developing Microsoft SQL Server 2012/2014 Databases
128
4.6
4 hrs
70-464 - Developing Microsoft SQL Server 2012/2014 Databases
Developing Solutions for Microsoft Azure
130
4.5
1 hr
AZ-203 - Developing Solutions for Microsoft Azure
Developing Solutions for Microsoft Azure
98
4.6
14 hrs
$24.99
AZ-204 - Developing Solutions for Microsoft Azure
Developing SQL Data Models
100
4.5
7 hrs
70-768 - Developing SQL Data Models
Developing SQL Databases
141
4.5
8 hrs
70-762 - Developing SQL Databases
Enabling Office 365 Services
484
4.5
1 hr
70-347 - Enabling Office 365 Services
Endpoint Administrator
138
5.0
13 hrs
$24.99
MD-102 - Endpoint Administrator
Excel 2013
126
4.6
11 hrs
$24.99
77-420 - Excel 2013
Excel 2016: Core Data Analysis, Manipulation, and Presentation
90
4.5
6 hrs
$24.99
77-727 - Excel 2016: Core Data Analysis, Manipulation, and Presentation
Identity with Windows Server 2016
98
4.5
20 hrs
70-742 - Identity with Windows Server 2016
Implementing a Hybrid and Secure Messaging Platform
112
4.5
4 hrs
MS-201 - Implementing a Hybrid and Secure Messaging Platform
Implementing a SQL Data Warehouse
140
4.3
6 hrs
70-767 - Implementing a SQL Data Warehouse
Implementing an Azure Data Solution
137
4.5
5 hrs
DP-200 - Implementing an Azure Data Solution
Implementing Data Models and Reports with Microsoft SQL Server 2012
124
4.5
5 hrs
70-466 - Implementing Data Models and Reports with Microsoft SQL Server 2012
Implementing Microsoft Azure Infrastructure Solutions
296
4.5
1 hr
70-533 - Implementing Microsoft Azure Infrastructure Solutions
Installation, Storage, and Compute with Windows Server 2016
439
4.5
8 hrs
70-740 - Installation, Storage, and Compute with Windows Server 2016
Installing and Configuring Windows Server 2012
315
4.4
10 hrs
70-410 - Installing and Configuring Windows Server 2012
Introduction to Programming Using Python
101
4.6
7 hrs
$24.99
98-381 - Introduction to Programming Using Python
Managing Microsoft SharePoint Server 2016
123
4.5
1 hr
70-339 - Managing Microsoft SharePoint Server 2016
Managing Microsoft Teams
135
4.5
9 hrs
$24.99
MS-700 - Managing Microsoft Teams
Managing Modern Desktops
141
4.5
7 hrs
$24.99
MD-101 - Managing Modern Desktops
Managing Office 365 Identities and Requirements
112
4.6
1 hr
70-346 - Managing Office 365 Identities and Requirements
Managing Projects with Microsoft Project 2013
85
4.6
1 hr
74-343 - Managing Projects with Microsoft Project 2013
MCSA Administering Microsoft SQL Server 2012/2014 Databases
477
4.6
11 hrs
70-462 - MCSA Administering Microsoft SQL Server 2012/2014 Databases
MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
100
4.5
6 hrs
70-463 - MCSA Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
MCSA Networking with Windows Server 2016
142
4.6
5 hrs
70-741 - MCSA Networking with Windows Server 2016
MCSA Querying Microsoft SQL Server 2012/2014
546
4.5
12 hrs
70-461 - MCSA Querying Microsoft SQL Server 2012/2014
MCSD Developing ASP.NET MVC Web Applications
131
4.6
18 hrs
70-486 - MCSD Developing ASP.NET MVC Web Applications
MCSD Developing Windows Azure and Web Services
102
4.6
13 hrs
70-487 - MCSD Developing Windows Azure and Web Services
MCSD Programming in C#
370
4.5
8 hrs
70-483 - MCSD Programming in C#
MCSD Programming in HTML5 with JavaScript and CSS3
156
4.6
7 hrs
70-480 - MCSD Programming in HTML5 with JavaScript and CSS3
MCSE Designing and Implementing a Server Infrastructure
683
4.5
9 hrs
70-413 - MCSE Designing and Implementing a Server Infrastructure
MCSE Implementing an Advanced Server Infrastructure
220
4.4
8 hrs
70-414 - MCSE Implementing an Advanced Server Infrastructure
Microsoft 365 Administrator
134
5.0
5 hrs
$24.99
MS-102 - Microsoft 365 Administrator
Microsoft 365 Fundamentals
86
4.5
2 hrs
$24.99
MS-900 - Microsoft 365 Fundamentals
Microsoft 365 Identity and Services
94
4.5
3 hrs
$24.99
MS-100 - Microsoft 365 Identity and Services
Microsoft 365 Messaging
132
4.4
11 hrs
$24.99
MS-203 - Microsoft 365 Messaging
Microsoft 365 Mobility and Security
135
4.5
5 hrs
$24.99
MS-101 - Microsoft 365 Mobility and Security
Microsoft 365 Security Administration
117
4.5
7 hrs
$24.99
MS-500 - Microsoft 365 Security Administration
Microsoft Access Expert Exam
141
5.0
8 hrs
$24.99
MO-500 - Microsoft Access Expert Exam
Microsoft Azure Administrator
134
4.5
10 hrs
$24.99
AZ-104 - Microsoft Azure Administrator
Microsoft Azure Administrator
121
4.6
7 hrs
AZ-103 - Microsoft Azure Administrator
Microsoft Azure AI Fundamentals
126
5.0
5 hrs
$24.99
AI-900 - Microsoft Azure AI Fundamentals
Microsoft Azure Architect Design
115
4.5
9 hrs
AZ-301 - Microsoft Azure Architect Design
Microsoft Azure Architect Design
100
4.5
12 hrs
$24.99
AZ-304 - Microsoft Azure Architect Design
Microsoft Azure Architect Technologies
114
4.6
10 hrs
$24.99
AZ-303 - Microsoft Azure Architect Technologies
Microsoft Azure Architect Technologies
113
4.6
9 hrs
AZ-300 - Microsoft Azure Architect Technologies
Microsoft Azure Data Fundamentals
118
4.4
2 hrs
$24.99
DP-900 - Microsoft Azure Data Fundamentals
Microsoft Azure Fundamentals
121
4.7
3 hrs
$24.99
AZ-900 - Microsoft Azure Fundamentals
Microsoft Azure Security Technologies
112
4.5
7 hrs
$24.99
AZ-500 - Microsoft Azure Security Technologies
Microsoft Cybersecurity Architect
122
5.0
12 hrs
$24.99
SC-100 - Microsoft Cybersecurity Architect
Microsoft Dynamics 365 Business Central Functional Consultant
105
5.0
1 hr
$24.99
MB-800 - Microsoft Dynamics 365 Business Central Functional Consultant
Microsoft Dynamics 365 customer engagement Online Deployment
126
4.6
1 hr
MB2-715 - Microsoft Dynamics 365 customer engagement Online Deployment
Microsoft Dynamics 365 Customer Service Functional Consultant
116
4.5
2 hrs
$24.99
MB-230 - Microsoft Dynamics 365 Customer Service Functional Consultant
Microsoft Dynamics 365 Customization and Configuration
111
4.5
12 hrs
MB2-716 - Microsoft Dynamics 365 Customization and Configuration
Microsoft Dynamics 365 Finance Functional Consultant
95
5.0
8 hrs
$24.99
MB-310 - Microsoft Dynamics 365 Finance Functional Consultant
Microsoft Dynamics 365 for Field Service
98
4.5
1 hr
$24.99
MB-240 - Microsoft Dynamics 365 for Field Service
Microsoft Dynamics 365 for Sales
145
5.0
9 hrs
$24.99
MB-210 - Microsoft Dynamics 365 for Sales
Microsoft Dynamics 365 for Sales
86
4.6
1 hr
MB2-717 - Microsoft Dynamics 365 for Sales
Microsoft Dynamics 365 Fundamentals
143
5.0
3 hrs
MB-901 - Microsoft Dynamics 365 Fundamentals
Microsoft Dynamics 365: Core Finance and Operations
94
5.0
3 hrs
$24.99
MB-300 - Microsoft Dynamics 365: Core Finance and Operations
Microsoft Dynamics CRM 2016 Customization and Configuration
117
4.5
3 hrs
$24.99
MB2-712 - Microsoft Dynamics CRM 2016 Customization and Configuration
Microsoft Dynamics CRM 2016 Sales
125
4.4
1 hr
MB2-713 - Microsoft Dynamics CRM 2016 Sales
Microsoft Excel Expert (Excel and Excel 2019)
107
5.0
8 hrs
$24.99
MO-201 - Microsoft Excel Expert (Excel and Excel 2019)
Microsoft Identity and Access Administrator
128
5.0
3 hrs
$24.99
SC-300 - Microsoft Identity and Access Administrator
Microsoft Information Protection Administrator
142
5.0
6 hrs
$24.99
SC-400 - Microsoft Information Protection Administrator
Microsoft Power BI Data Analyst
104
5.0
3 hrs
$24.99
PL-300 - Microsoft Power BI Data Analyst
Microsoft Power Platform + Dynamics 365 Core
135
5.0
10 hrs
MB-200 - Microsoft Power Platform + Dynamics 365 Core
Microsoft Power Platform App Maker
103
5.0
15 hrs
$24.99
PL-100 - Microsoft Power Platform App Maker
Microsoft Power Platform Developer
119
5.0
11 hrs
$24.99
PL-400 - Microsoft Power Platform Developer
Microsoft Power Platform Functional Consultant
124
5.0
7 hrs
$24.99
PL-200 - Microsoft Power Platform Functional Consultant
Microsoft Power Platform Fundamentals
135
5.0
6 hrs
$24.99
PL-900 - Microsoft Power Platform Fundamentals
Microsoft Security Operations Analyst
126
5.0
12 hrs
$24.99
SC-200 - Microsoft Security Operations Analyst
Microsoft Security, Compliance, and Identity Fundamentals
137
5.0
7 hrs
$24.99
SC-900 - Microsoft Security, Compliance, and Identity Fundamentals
Microsoft Word (Word and Word 2019)
111
5.0
5 hrs
$24.99
MO-100 - Microsoft Word (Word and Word 2019)
Networking Fundamentals
122
4.5
4 hrs
$24.99
98-366 - Networking Fundamentals
Perform Cloud Data Science with Azure Machine Learning
100
4.5
1 hr
70-774 - Perform Cloud Data Science with Azure Machine Learning
Planning and Administering Microsoft Azure for SAP Workloads
97
5.0
5 hrs
$24.99
AZ-120 - Planning and Administering Microsoft Azure for SAP Workloads
Planning and Configuring a Messaging Platform
135
4.5
4 hrs
MS-200 - Planning and Configuring a Messaging Platform
Provisioning SQL Databases
141
4.6
8 hrs
70-765 - Provisioning SQL Databases
Querying Data with Transact-SQL
120
4.6
6 hrs
70-761 - Querying Data with Transact-SQL
Securing Windows Server 2016
90
4.5
13 hrs
70-744 - Securing Windows Server 2016
Security Fundamentals
110
4.6
6 hrs
$24.99
98-367 - Security Fundamentals
SharePoint 2010
97
4.4
2 hrs
$24.99
77-886 - SharePoint 2010
Software Development Fundamentals
112
4.5
5 hrs
$24.99
98-361 - Software Development Fundamentals
Technology Literacy for Educators
143
5.0
1 hr
$24.99
62-193 - Technology Literacy for Educators
Upgrading Your Skills to MCSA Windows Server 2012
124
4.5
5 hrs
70-417 - Upgrading Your Skills to MCSA Windows Server 2012
Upgrading Your Skills to MCSA: Windows Server 2016
140
4.5
2 hrs
70-743 - Upgrading Your Skills to MCSA: Windows Server 2016
Windows 10
97
4.5
6 hrs
$24.99
MD-100 - Windows 10
Windows Operating System Fundamentals
144
4.4
3 hrs
$24.99
98-349 - Windows Operating System Fundamentals
Windows Server Administration Fundamentals
124
4.6
6 hrs
$24.99
98-365 - Windows Server Administration Fundamentals
Cloud Fundamentals
Cloud Fundamentals
124
4.6
1 hr
Excel 2013
$24.99
Excel 2013
126
4.6
11 hrs
Windows 10
$24.99
Windows 10
97
4.5
6 hrs

Only Registered Members Can Download VCE Files or View Training Courses

Please fill out your email address below in order to Download VCE files or 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
  • VCE Files Simulate Real Exam Environment
  • Instant Download After Registration.
Please provide a correct e-mail address
A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Log into your ExamCollection Account

Please Log In to download VCE file or view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

Only registered Examcollection.com members can download vce files or view training courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

SPECIAL OFFER: GET 10% OFF

ExamCollection Premium

ExamCollection Premium Files

Pass your Exam with ExamCollection's PREMIUM files!

  • ExamCollection Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
Enter Your Email Address to Receive Your 10% Off 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

SPECIAL OFFER: GET 10% OFF

Use Discount Code:

MIN10OFF

A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@examcollection.com and follow the directions.

Next

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.