Go Class

This course includes:

  • 8.5 hours on-demand video
  • 4 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV

Excel Exam MO-201: Microsoft Excel Expert (2019/Office 365)

Maven Analytics via Udemy

(102 Reviews)

Overview

EXCEL EXAM MO-201: MICROSOFT EXCEL EXPERT


This course is specifically designed to help you ace the MO-201 Excel Expert Exam and earn your official Microsoft Expert Certification for Excel 2019 or Office 365. With hands-on projects, full-length practice tests, and free downloadable study guides, this is the ONLY course you'll need to prepare for the MO-201 Excel exam, guaranteed!


We'll start by introducing Microsoft's MO-201 Excel Expert Exam, reviewing the test structure and interface, and addressing the key topics and objective domains you'll need to master, including:


  • Analyzing data with formulas & macros

    • Logical operators, date/time functions, financial functions, lookups, basic macros, formula auditing tools, etc.


  • Managing & formatting data

    • Custom formats, data validation, removing duplicates, autofill & flash fill, conditional formatting, etc.


  • Exploring data with charts & PivotTables

    • Statistical charts, tree maps & sunbursts, geospatial maps, PivotTables & PivotCharts, etc.


  • Customizing workbook options & settings

    • Linking Excel workbooks, protection & encryption, comments, calculation modes, language tools, etc.


Unlike other test prep materials, this is a hands-on and 100% project-based course, designed to put your skills to the test with practical demos and unique business intelligence case studies. You'll work with real data from Airbnb, and use Excel's full arsenal of tools to analyze property details, rental rates, mortgage projections, and everything in between.


Trust us, test prep has NEVER been this much fun!


By the end of the course, you'll be able to apply advanced formulas and functions, design custom visuals and formats, explore data with PivotTables, automate manual tasks with macros, collaborate with other users, and much more. We've even included several custom-built practice tests, designed to replicate the actual Excel MO-201 exam structure and prepare you for the real deal.


So why get certified as a Microsoft Excel Expert?

  1. Build powerful and practical skills to launch or accelerate your career

  2. Strengthen your resume and market yourself to potential employers

  3. Earn a highly coveted and prestigious credential, certified by Microsoft

If you're ready to level-up your skills, increase your earning potential, and become a certified Excel ROCKSTAR, this is the course for you.


Join today and get immediate, lifetime access to the following:

  • 8+ hours of high-quality video

  • Downloadable MO-201 test prep guide

  • Excel project files & solutions

  • Quizzes & practice tests

  • Expert-support and Q&A forum

  • 30-day money-back guarantee


Happy learning!

-Enrique (Certified Excel Expert & Instructor, Maven Analytics)


__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!


See why Maven Analytics courses are among the TOP-RATED the BEST-SELLING analytics courses on Udemy:


"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.


"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.


"Excellent from start to finish. I picked up a bunch of techniques that will be useful in the workplace, from new chart templates to some very cool advanced visualizations. I loved all of it!" Robert C.


"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.

Who this course is for:

  • Excel users seeking to pass the MO-201 Exam and become a Microsoft Certified Expert
  • Aspiring data professionals seeking to earn valuable, industry-recognized credentials
  • Anyone looking to build a deep and well-rounded Excel skill set
  • Students looking for a fun, interactive, and project-based approach to test prep

Course Content

9 sections - 98 lectures - 08:33:53 total length

People Also Search

Students Also Bought

Excel Exam MO-201: Microsoft Excel Expert (2019/Office 365)

Excel Exam MO-201: Microsoft Excel Expert (2019/Office 365)

Ace the Excel MO-201 Exam and earn your Microsoft Expert Certification, with full practice tests + study guides

AWS DynamoDb, S3, SNS, SQS ,Beanstalk with Java

AWS DynamoDb, S3, SNS, SQS ,Beanstalk with Java

Integrate AWS -DynamoDb, S3, SNS, SQS ,Beanstalk, CodePipeLine with Spring Boot and Java.

Google Cloud Professional Cloud Developer || Practice Tests

Google Cloud Professional Cloud Developer || Practice Tests

Google Cloud Professional Cloud Developer Practice Tests || Detail Explanation & Ref links || All objectives covered

Google Cloud Professional Network Engineer || Practice Tests

Google Cloud Professional Network Engineer || Practice Tests

Google Cloud Professional Network Engineer || Practice Tests || Detail Explanation || All objectives covered

Instructor

Maven Analytics

  • 4 Instructor Rating
  • 132291 Reviews
  • 412358 Students

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience.

Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand.