14 Comments

  • Marina says:

    Thank you so much for such a useful information!! I’d like to get certificate in Excel. Can you recommend one that might be helpful in starting Data Analyst career? I am seasonal IT professional but have very little experience in Excel. Would like to try my chances as DA.
    Thanks a lot!

  • Anas says:

    Hello Ann, I want to be a public health practitioner and as practitioner in public health, I need to do analysis. In addition to the public health degrees, I need to know well in excel, for public health analysis which excel certification exam is recommended? Thanks

  • Deepak says:

    Hi Ann,
    This is Deepak from India. The information you explained is quite useful. I was looking for the exam structure but found nowhere but fortunately I came across your post and got to know about it.
    Though you have covered everything but I still come up with a question. Does the test include objective excel questions like MCQ?

    Looking forward to hearing back from you.😊
    Thanks!

    • Ann K. Emery says:

      Hi Deepak! Thanks for connecting. I think there might’ve been a couple multiple choice questions? But maybe not… I feel like it was mostly instructions: “Go do this thing” or “Go do this thing,” and you had to know which tabs, sheets, and buttons to click.

  • Angie says:

    Hey! Thanks for the useful information. Is there a set of online classes or any program to prepare for the exam?

  • Gaurav Gupta says:

    Hi Ann,
    Your article was detailed enough to give an idea about the exam, which was not available anywhere else. Thank you for that. However, I had few queries regarding the exam –
    1. Is there any limitation on the number of mouse clicks during the duration of the exam?
    2. Do we have to know all the shortcut keys by heart?
    3. Is the official Microsoft publication on MOS 200 and MOS 201 sufficient for clearing the exam?
    Thanks in advance.

    • Ann K. Emery says:

      Good questions!

      1. I don’t think there’s a limitation on the number of mouse clicks. I haven’t read that anywhere. If you find out differently, let me know!

      2. Shortcut keys are optional. They’re shortcuts, after all. There are dozens of Excel shortcuts, but in real life, I only use the same ~5 over and over.

      3. I think so?

      Check out Certiport’s website though — they’re in the middle of a website revision and they’re adding lots of new info about the exams. And the exams are changing/being updated!

      Best of luck on your exam. You can always re-take it if you don’t pass the first time.

      Ann

  • Rajesh gyawali says:

    Hi ann,

    I want to know that if any technical error happens in exam like lost wifi networks then exam will dismiss or what? And if i fail in exam then to attend another exam should i paid full amount 100 dollor?

    • Ann K. Emery says:

      Hi Rajesh,

      Not sure about technical errors like lost wifi. I think you’d ask Certiport about that.

      When you first pay for the exam, they give you the option to take it once (around $100 when I registered) or to take it again (around $130, I believe). I’ve been using Excel for years and didn’t anticipate failing / needing to re-take it, so I didn’t pay extra for the “just in case I fail” reassurance.

      Best of luck on your exam!
      Ann

  • Shayan says:

    I was trying so hard to pass these exams but I was not able to clear it but thanks to you for sharing this article I will share this with my fellows

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    How to Pass the Excel Certification Exam

    Updated on: Apr 6th, 2021
    Data Analysis
    ,
    A screenshot of Ann K. Emery's Excel certification exam certificate

    Want to pass the Excel certification exam?

    Maybe you want proof that you can rock Excel for your resume? For your LinkedIn profile?

    Do you want a confidence boost that, yes, you know Excel?

    Do you want your boss to feel confidence that, yes, you know Excel?

    Back in January, I’d just gotten home from my third hospital stay. Pneumonia while pregnant. 0 of 5 stars. Do not recommend.

    My lungs were still on fire… but my brain was fired up and ready to go. I’d been laying in bed for weeks, and I was itching to get back to regular life.

    On a whim, I registered for the Excel certification exam. I’d always been curious to see whether I could pass.

    Spoiler alert: I passed!

    In this blog post, I’ll share behind-the-scenes tips for registering for and pacing the MOS-200 exam.

    How to Pass the Excel Certification Exam

    Here are 10 steps for passing the Excel certification exam.

    1. Choose the Exam You Want to Take

    Head over to Microsoft’s website.

    There are DOZENS of Microsoft exams available. Some focus on Word, Excel, PowerPoint, etc.

    Levels

    There are also different levels of exams. For example, some cover intermediate skills while others are labeled as “expert.”

    I took MO-200, which is described as an intermediate-level exam.

    Next, I might take the expert-level Excel exam. But, it covers formulas that I’ve never needed to use in real-life, so might not be relevant enough to be worth my time? I might also try the PowerPoint and Word exams later this year (?).

    Certifications

    You can also take several exams that add up to a certification. For example, if you pass the MO-100 (Word), MO-200 (Excel), MO-300 (PowerPoint) and MO-400 (Outlook), then you’ll be a certified Microsoft Office Specialist. I have zero use for Outlook skills so I doubt that I’ll bother with this particular certification.

    2. See Which Skills are Covered

    You can see which skills are covered. We’ll discuss these skills more in a moment.

    3. Choose a Test Site

    Choose a test site at https://www.certiport.com/locator.

    I looked for test sites around Orlando, and when I contacted them, they said all the exams were now online (due to COVID).

    4. Schedule the Exam

    Schedule the exam for a particular day and time with an administrator from that test center.

    Heads up: The online registration process kept glitching, so I had to call the test site over the phone.

    5. Receive a Confirmation Email

    Next, you’ll receive a confirmation email from the test center with your login link.

    I registered over the phone and didn’t receive any confirmation emails at all, which was really stressful.

    I had to follow-up with the test center twice and finally received an email confirmation at 5pm the day before my exam…

    6. Create a Username and Password through Certiport

    Before the exam, you’ll have to create a username and password at Certiport.com.

    I was pleasantly surprised to learn that I still had a username and password from a decade ago, when I worked as a certification instructor.

    I highly recommend setting up your username and password several days ahead of time in case you run into Certiport glitches.  

    7. Purchase an Exam Voucher from Certiport

    My MO-200 test was USD $100 as of January 2021.

    You’ll also have the option to pay $120 in case you need to re-take the exam, and you can also purchase test manuals.

    I didn’t purchase the $120 package to re-take the exam. Go big or go home is one of my life mottos. I know myself. If I have a safety net (the option to re-take the exam), I won’t give it my all the first time around. But, if paying $20 more for the option to re-take the exam gives you peace of mind, then go for it.

    You receive two emails from Certiport:

    1. A receipt showing that you paid $100.
    2. A 16-digital voucher number. It took about 30 minutes to receive the second email with the voucher number, and I had to contact customer service to receive it. I *highly* recommend purchasing the voucher the day before in case there’s a delay.

    8. Log In at Your Scheduled Exam Time

    Log in at the correct day/time. Or, better yet, log in 10-20 minutes early.

    My login link was in the confirmation email from the test center that I finally received the day beforehand.

    A “proctor” from Pearson can see your screen. She helped me log in and start the exam.

    There was also a “chat” feature available—through a “notepad,” actually—where she could help me log in.

    9. Take the Exam

    You’ll see two windows on your screen: a fictional Excel dataset at the top, with the instructions for the particular task underneath.

    Time Limit: 50 Minutes

    You’re given 50 minutes to complete the exam. I finished in 30 minutes, and spent literally half that time scribbling down notes about the registration process for this blog post.

    You can probably finish even faster than me. I don’t anticipate that you’ll feel pressed for time.

    Finish the 6 Projects

    My test had 6 “projects.”

    Each project is a fictional workbook with ~5 sheets. You’re given brief instructions for each fictional scenario, e.g., “You work for the ABC Company. You’re getting information ready for a meeting.”

    Each of the ~5 sheets contains something different: an Excel Table, a chart, etc.

    The data tables are relatively small, maybe 5 columns and 20 rows. You won’t see any intimidating datasets with thousands upon thousands of entries, phew!

    Some of the columns were already filled in with data or formulas. Other columns were blank and you had to create new formulas to fill them in.

    The topics are extremely generic and straightforward. You don’t need experience working with any of these topic areas, so don’t let the terminology intimidate you! For example, you might see questions about banking, but you don’t need to know anything at all about banking in order to understand the questions.

    Finish the Tasks within Each Project

    Each of the “projects” had ~7 tasks. Think of the tasks as exam questions. There were approximately 50 tasks, or questions, in total.

    Skills Covered

    Here are some blog posts about the skills that are covered on the exam:

    Skills I haven’t blogged about, but are covered extensively in my online courses:

    • Charts. On the exam, you’ll be asked to create and edit any and all aspects of charts.
    • Tables
    • Printing
    • Conditional Formatting

    Skills not covered on my exam:

    Come Back to Tasks You Skipped

    As you’re working through each task, you have three options:

    1. Mark the task as complete.
    2. Mark for review. What an excellent feature!!! This way, you don’t have to spend too much time on any particular question. You can come back and review these tasks later, time permitting. I needed to review 3 of the ~50 tasks.
    3. Leave a note for the test company (e.g., If you notice any errors in the exam). I didn’t leave any notes.

    10. Receive Your Results

    You can see your results immediately! I honestly expected to have to wait a while, and I was pleasantly surprised to receive instant results. So cool.

    You need 700/1000 to pass. I scored 892/1000.

    The scores are broken down by topic. I honestly have no idea which questions I missed; I assumed I got everything 100% correct as I was taking the exam. Apparently I don’t know much about tables, ha!

    You can also login to Certiport.com and download a PDF’d certificate. The PDF is available within minutes of completing the exam.

    Screenshot showing Excel exam test results.
    More about Ann K. Emery
    Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

    14 Comments

  • Marina says:

    Thank you so much for such a useful information!! I’d like to get certificate in Excel. Can you recommend one that might be helpful in starting Data Analyst career? I am seasonal IT professional but have very little experience in Excel. Would like to try my chances as DA.
    Thanks a lot!

  • Anas says:

    Hello Ann, I want to be a public health practitioner and as practitioner in public health, I need to do analysis. In addition to the public health degrees, I need to know well in excel, for public health analysis which excel certification exam is recommended? Thanks

  • Deepak says:

    Hi Ann,
    This is Deepak from India. The information you explained is quite useful. I was looking for the exam structure but found nowhere but fortunately I came across your post and got to know about it.
    Though you have covered everything but I still come up with a question. Does the test include objective excel questions like MCQ?

    Looking forward to hearing back from you.😊
    Thanks!

    • Ann K. Emery says:

      Hi Deepak! Thanks for connecting. I think there might’ve been a couple multiple choice questions? But maybe not… I feel like it was mostly instructions: “Go do this thing” or “Go do this thing,” and you had to know which tabs, sheets, and buttons to click.

  • Angie says:

    Hey! Thanks for the useful information. Is there a set of online classes or any program to prepare for the exam?

  • Gaurav Gupta says:

    Hi Ann,
    Your article was detailed enough to give an idea about the exam, which was not available anywhere else. Thank you for that. However, I had few queries regarding the exam –
    1. Is there any limitation on the number of mouse clicks during the duration of the exam?
    2. Do we have to know all the shortcut keys by heart?
    3. Is the official Microsoft publication on MOS 200 and MOS 201 sufficient for clearing the exam?
    Thanks in advance.

    • Ann K. Emery says:

      Good questions!

      1. I don’t think there’s a limitation on the number of mouse clicks. I haven’t read that anywhere. If you find out differently, let me know!

      2. Shortcut keys are optional. They’re shortcuts, after all. There are dozens of Excel shortcuts, but in real life, I only use the same ~5 over and over.

      3. I think so?

      Check out Certiport’s website though — they’re in the middle of a website revision and they’re adding lots of new info about the exams. And the exams are changing/being updated!

      Best of luck on your exam. You can always re-take it if you don’t pass the first time.

      Ann

  • Rajesh gyawali says:

    Hi ann,

    I want to know that if any technical error happens in exam like lost wifi networks then exam will dismiss or what? And if i fail in exam then to attend another exam should i paid full amount 100 dollor?

    • Ann K. Emery says:

      Hi Rajesh,

      Not sure about technical errors like lost wifi. I think you’d ask Certiport about that.

      When you first pay for the exam, they give you the option to take it once (around $100 when I registered) or to take it again (around $130, I believe). I’ve been using Excel for years and didn’t anticipate failing / needing to re-take it, so I didn’t pay extra for the “just in case I fail” reassurance.

      Best of luck on your exam!
      Ann

  • Shayan says:

    I was trying so hard to pass these exams but I was not able to clear it but thanks to you for sharing this article I will share this with my fellows

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    You Might Like

    Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

    Enroll

    How to Make Dumbbell Dot Plots in Excel

    These non-native charts require some advanced Excel maneuvers. You’ll learn how to assign each dot an x-y coordinate… and then add a scatter plot (!).

    More »

    Need some time-savers in Excel? Feel like all the formulas are taking forever? Learn how to clean, analyze, and tabulate your dataset.

    Enroll

    Subscribe

    Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.