Expires in:
Expires in:
Expires in:
Self-paced course
Self-paced course
Excel MO-201 Exam Prep
Excel MO-201 Exam Prep
Rating 4.3
318 reviews
318 reviews
318 reviews
Course Description
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/365.
We’ll start by introducing the Microsoft MO-201 exam, reviewing the test structure and interface, and addressing the key topics and objective domains covered:
Analyzing data with formulas & basic macros
Managing & formatting data
Exploring data with charts & PivotTables
Customizing workbook options & settings
Unlike other test prep materials, this is a 100% project-based course, designed to put your skills to the test with practical demos and 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.
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.
If you’re ready to level-up your skills and become a certified Excel ROCKSTAR, this is the course for you.
Course Description
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/365.
We’ll start by introducing the Microsoft MO-201 exam, reviewing the test structure and interface, and addressing the key topics and objective domains covered:
Analyzing data with formulas & basic macros
Managing & formatting data
Exploring data with charts & PivotTables
Customizing workbook options & settings
Unlike other test prep materials, this is a 100% project-based course, designed to put your skills to the test with practical demos and 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.
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.
If you’re ready to level-up your skills and become a certified Excel ROCKSTAR, this is the course for you.
Course Content
21.0 video hours
Skills you'll learn in this course
Review every MO‑201 competency: formulas, charts & macros
Practice tasks in a timed, exam‑like simulator
Learn shortcuts & common pitfalls to avoid on test day
Earn the Excel Expert certification with confidence
Meet your instructors
Enrique Ruiz
Sr. Learning Experience Designer
Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.
Student reviews
This course covered the exam domains well. I found it useful as a recap of the topics covered in other Maven Analytics courses. I found the practice exam to be a useful experience, as I replicated a test environment and completed the practice test within the time limit. The solutions were useful as it showed me where I went slightly wrong on a couple of items.
Andrew Hubbard
This Excel MO-201 Exam prep is a fun course at the end of the total Excel path. Because there is so much to do with Excel I was positive surprised time after time while realizing that during the course. I loved the Practice test at the end and I think I'm ready for the real exam after reading through the brilliant PDF slide pack once again.
Marjolein Opsteegh
I already had many years of experience in Excel. That is not enough to prepare you for the MO-201 test. The course's focus areas are spot on. Do not just audit the course and then take the certification exam immediately. There are many tasks and you must be quick. Do practice using these features a lot so you are not flailing come test time.
David Whitney
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel MO-201 Exam Prep
Excel MO-201 Exam Prep
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
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/365.
We’ll start by introducing the Microsoft MO-201 exam, reviewing the test structure and interface, and addressing the key topics and objective domains covered:
Analyzing data with formulas & basic macros
Managing & formatting data
Exploring data with charts & PivotTables
Customizing workbook options & settings
Unlike other test prep materials, this is a 100% project-based course, designed to put your skills to the test with practical demos and 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.
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.
If you’re ready to level-up your skills and become a certified Excel ROCKSTAR, this is the course for you.
Course Description
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/365.
We’ll start by introducing the Microsoft MO-201 exam, reviewing the test structure and interface, and addressing the key topics and objective domains covered:
Analyzing data with formulas & basic macros
Managing & formatting data
Exploring data with charts & PivotTables
Customizing workbook options & settings
Unlike other test prep materials, this is a 100% project-based course, designed to put your skills to the test with practical demos and 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.
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.
If you’re ready to level-up your skills and become a certified Excel ROCKSTAR, this is the course for you.
Curriculum
1
Getting Started
1
Getting Started
1
Getting Started
2
About the MO-201 Exam
2
About the MO-201 Exam
2
About the MO-201 Exam
3
The Course Project
6 MIN
6 MIN
3
The Course Project
6 MIN
6 MIN
3
The Course Project
6 MIN
6 MIN
4
Advanced Formulas & Macros
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
4
Advanced Formulas & Macros
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
4
Advanced Formulas & Macros
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
5
Manage & Format Data
6 MIN
6 MIN
6 MIN
6 MIN
5
Manage & Format Data
6 MIN
6 MIN
6 MIN
6 MIN
5
Manage & Format Data
6 MIN
6 MIN
6 MIN
6 MIN
6
Advanced Charts & Tables
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6
Advanced Charts & Tables
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6
Advanced Charts & Tables
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
6 MIN
7
Workbook Options & Settings
6 MIN
6 MIN
6 MIN
6 MIN
7
Workbook Options & Settings
6 MIN
6 MIN
6 MIN
6 MIN
7
Workbook Options & Settings
6 MIN
6 MIN
6 MIN
6 MIN
8
Practice Test
8
Practice Test
8
Practice Test
9
Course Feedback & Next Steps
9
Course Feedback & Next Steps
9
Course Feedback & Next Steps
Meet your instructors
Enrique Ruiz
Sr. Learning Experience Designer
Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.
Student reviews
This course covered the exam domains well. I found it useful as a recap of the topics covered in other Maven Analytics courses. I found the practice exam to be a useful experience, as I replicated a test environment and completed the practice test within the time limit. The solutions were useful as it showed me where I went slightly wrong on a couple of items.
Andrew Hubbard
This Excel MO-201 Exam prep is a fun course at the end of the total Excel path. Because there is so much to do with Excel I was positive surprised time after time while realizing that during the course. I loved the Practice test at the end and I think I'm ready for the real exam after reading through the brilliant PDF slide pack once again.
Marjolein Opsteegh
I already had many years of experience in Excel. That is not enough to prepare you for the MO-201 test. The course's focus areas are spot on. Do not just audit the course and then take the certification exam immediately. There are many tasks and you must be quick. Do practice using these features a lot so you are not flailing come test time.
David Whitney
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel MO-201 Exam Prep
Excel MO-201 Exam Prep
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like
