Self-paced course
Self-paced course
Excel MO-201 Exam Prep
Excel MO-201 Exam Prep
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
14 course hours
6 assignments & solutions
4 quizzes
Who should take this course
Excel users seeking to become a Microsoft Certified Expert
Aspiring data professionals seeking to earn industry-recognized credentials
Anyone looking to build deep and well-rounded Excel skills
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.
Featured review
"I am now a certified Microsoft Excel Expert and this course was critical to making that happen. Enrique did a great job of walking through all of the skills measured on the exam, and using those skills to work through the course project was hugely beneficial. Thank you!"
Alexander M.
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
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
I am now a certified Microsoft Excel Expert and this course was critical to making that happen. Enrique did a great job of walking through all of the skills measured on the exam, and using those skills to work through the course project was hugely beneficial. Thank you!
Alexander M.
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
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
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
