Microsoft Excel (2019) Certification Exam

If you clicked on this video you're probably wondering how am I ever going to pass the Excel 2019 or MO 200 exam when there's just no information out there about this exam?

CHECK OUT THE NEW UPDATED VERSION HERE:

Well I'm going to share with you this practice exam with 6 projects that will show you tasks that are similar to ones you might run into on your Excel exam so that you can be well prepared. We're going to look at chart elements, new Excel functions, and tons of other skills you need to learn for your exam.

TIME STAMPS:
PROJECT 1
1:07 Navigate to a range and delete range
1:42 Format numbers to no decimal places
2:25 Remove table row
3:11 Average Function
3:45 Concat (join) Function
5:19 Remove table functionality
5:50 Freeze rows
PROJECT 2
6:59 Copy a formula
7:25 Remove conditional formatting
7:52 Format a table so every other row is shaded (Banded rows)
8:34 Sort multiple columns
10:20 Max Function
10:56 Remove duplicates
PROJECT 3
11:52 Print Titles (repeat titles on multiple pages)
12:56 Filter data
13:45 IF Function
16:13 Multiple two values
17:00 Create a chart in Excel
18:27 Add an alt description
19:19 Insert Sparklines
PROJECT 4
20:08 Left align text
20:24 Left Function
21:21 Conditional Formatting (Three Traffic Lights)
22:17 Apply a table style
22:53 Change chart color (Monochromatic Palette)
23:18 Add a data table to a chart
PROJECT 5
23:54 Import data from a text file
25:16 Move a chart to its own chart sheet
26:08 Add chart element: Add axis titles to a chart
26:57 Remove elements in a chart-Chart legend
PROJECT 6
27:54 Copy and paste formatting
28:48 Table name
30:01 Use named ranges in a formula
31:18 CountBlank Function

[jeffskeys]

Passed with a 975 thanks to you Mike. Did your udemy and watch your video. I recommend anyone to get Mike’s udemy because it’s almost 100% to the actual exam and will teach you every model they are looking for. Also Mike is a great teacher and explains the process to you well.

[analyze.and.optimize]

Absolutely insane results. I failed my first Certiport exam a few weeks ago. I took a GMetrix exam this morning and failed it. Then I watched your video two times through today and just scored a 957 on my exam. I am a senior and if I failed this test, which I probably would have if I hadn't stumbled across your video, I would not have been able to graduate on time. You saved my life. Thank you so much, Mike.

[sweetteas]

I PASSED WITH A 914. Thank you so much Mike. For those who think they won't have a similar outcome like me, my first attempt, I got a 600. After studying and watching Mike's videos I brought that up to a 914. Im probably just like you and I know you can do it. Believe it!

[kyleherndon]

Just finished taking and passing my MOS Exam. Didn’t study and watched this video once and had all that I needed to succeed. Mike is an awesome teacher of Microsoft office. Thank

[tizianamartinho]

After I failed my exam on first attempt, I decided to watch your video and practice..I took it again today and I passed with 950✅ thank you so much! I had like 21min left 🙌🏾

[Blackkeysfan]

I was terrified to take that exam because I did so poorly on my gemetrix tests. Your videos helped me so much and I just passed with a 978! I’m beyond thankful! You did an excellent job!

Took my UNT Excel Certification Exam and scored a 875/1000 from just an hour of studying this video! Thanks a ton Mike.

[Itsthebrownkid]

People from Canada that I love:
1. Mike’s Office
2. The Weeknd

I made an 828 on my excel certification test, I owe it all to you. Thank you for the tutorial!

[MatsGamed]

DUDE BIG THANKS TO YOU I MISSED 20 HOURS OF EXCEL CLASSES WATCHED THIS ONE VIDEO 900/1000 GOOD I LOVE YOU

[Weed-Bat]

I have my certification this friday, definitively watching this atleast 4 times, thanks man

[FedericoKog]

Thank you so much man! Got a 935 on the Certification, don't stop on helping people, you are making a big change by also teaching better than our actual teachers.

[kaniyahm]

Thank you so much man. I failed the first time I took the exam with a 580. I studied on all sorts of platforms and still failed. However. I only watched your video a few times and passed with a 985 on my second try. You're a total lifesaver🙏🏽

[jennaryan]

I got a 957 after watching your video right before my exam! I scored a 745 on my first one only two weeks ago. Thank you so much, your video was so helpful!

[ShakespearesAriel]

This practice exam was 100% on point. I just took the certification exam and it was nearly identical. Thanks Mike!

[waifung]

Big thanks to you ! Got a pass with 935/1000
All I did for preparation were,
only watched this video twice and jotted some notes .

[hidam]

I just passed my MOS exam today. I got 962.Thankyou so much.

[hongboliu]

After watching the video, I finished my Exam with 900 points, thank you Mike! You are amazing!

[desireegonzalez]

This was a fantastic guide. I watched twice from start to finish as the majority of the content I have never been exposed to. Your video depicted the examples very well. I took my Word exam 07/28 passing with a mere 700 and I learned from that experience not to spend too much time on anything or you will run out of time. Yesterday I scored an 978 on this exam which I didn't think I was capable of. I am grateful that someone with your skill has invested in this content for the good of others. This experience gave me the ambition to take my 3rd exam (Outlook) tomorrow. Thank you!

[NYAJOEE]

I passed with a 721 on my second attempt for my business department at UNT, thank you Mike!!

[yankeeplayer]

Thank you so much I was able to score a 925 studying this video for the past 4 days! I feel I understand Excel so much more now thanks to you.