.png){kind=logo}
MSEXCEL-EXP.AD1
Microsoft Excel 2021 Expert
Prepare for MO-200 & MO-201 Microsoft certification exams. Learn advanced workbook skills.
- Practice in 28 Hands-On Labs — nothing to install
- 15 Interactive Lessons and 25 topics mapped to the official exam objectives
- 118 Practice Test Questions
Expert Self-paced · 1 year access
28 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
15Interactive Lessons
25Topics
28LiveLab
118Practice Test Questions
48Flashcards
48Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
Our Microsoft Excel 2021 Expert course is all you need to pass both the Microsoft certification exams MO-200 & MO-201. The comprehensive course structure covers 6 key topics that dive into the most-advanced features of the software.
You’ll learn how to work with multiple worksheets and workbooks, utilizing links, external references, and 3D references. Explore advanced techniques and powerful features to optimize your data analysis, reporting, and automation workflows.
By the end of the Microsoft Excel Expert training course, you’ll be skilled to tackle complex data analysis challenges, and create dynamic, interactive reports.
- Ability to manipulate and analyze data by consolidation, 3D cell referencing, and data validation
- Track formula dependencies and evaluate expressions to identify errors
- Work with dynamic arrays that automatically adjust in size as data changes
- Retrieve specific data from a range of cells with Lookup functions
- Analyzing large datasets with Power Pivot & perform calculations with array formulas
- Automate repetitive tasks with Macros to create automated data tables
- Find input value for a specific output & analyze different sets of input values
- Expertise with Sparklines and Data Maps for visual representation of data
- Ability to collaborate, secure and share workbooks
Target Career Roles
- Accountants Cost Estimator Data Journalist Retail Manager Project Manager Business Analyst Financial Analyst Information Clerk Administrative Assistant
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
15 Interactive Lessons · 25 topics01 About This Course 1 topics +
- Course Description
02 Working with Multiple Worksheets and Workbooks 3 topics · 4 LiveLab +
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
4 LiveLab in this lesson — see the labs panel →
03 Sharing and Protecting Workbooks 2 topics · 5 LiveLab +
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
5 LiveLab in this lesson — see the labs panel →
04 Automating Workbook Functionality 3 topics · 4 LiveLab +
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
4 LiveLab in this lesson — see the labs panel →
05 Using Lookup Functions, Dynamic Arrays, and Formula Auditing 4 topics · 12 LiveLab +
- Topic A: Use Lookup Functions
- Topic B: Use Dynamic Arrays and Dynamic Array Functions
- Topic C: Trace Cells
- Topic D: Watch and Evaluate Formulas
12 LiveLab in this lesson — see the labs panel →
06 Forecasting Data 4 topics · 2 LiveLab +
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
2 LiveLab in this lesson — see the labs panel →
07 Creating Sparklines and Mapping Data 2 topics · 1 LiveLab +
- Topic A: Create Sparklines
- Topic B: Map Data
1 LiveLab in this lesson — see the labs panel →
08 Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts +
09 Appendix B: Cube Functions +
10 Appendix C: Importing and Exporting Data 1 topics +
- Topic A: Import and Export Data
11 Appendix D: Internationalizing Workbooks 1 topics +
- Topic A: Internationalize Workbooks
12 Appendix E: Working with Power Pivot 1 topics +
- Topic A: Work with Power Pivot
13 Appendix F: Advanced Customization Options 1 topics +
- Topic A: Customize Advanced Options
14 Appendix G: Working with Forms and Controls 1 topics +
- Topic A: Work with Forms and Controls
15 Appendix H: Using Array Formulas 1 topics +
- Topic A: Use Array Formulas
Hands-On Labs Our edge
28 LiveLabs- Creating Links
- Creating External Links
- Creating a 3-D Formula
- Consolidating Data
- Fixing the Missing Alternative Text Error by Using the Accessibility Checker
- Exporting the Workbook in the PDF File Format
- Hiding the Worksheet
- Enabling Worksheet Protection
- Hiding the Formulas
- Enabling and Configuring the Settings for Data Validation
- Checking the Worksheet For Errors In Formulas
- Finding and Fixing Invalid Data Entries
- Saving the Workbook as a Macro-Enabled Workbook
- Using the HLOOKUP Function
- Using the INDEX Function
- Using the MATCH Function
- Using the FILTER Function
- Using the SEQUENCE Function
- Using the SORT Function
- Using the LET Function
- Using the XLOOKUP Function
- Using the TRANSPOSE Function
- Using the VLOOKUP Function
- Using the UNIQUE Function
- Using the XMATCH Function
- Creating a Two-Variable Data Table
- Creating a Forecast Sheet
- Creating Sparklines
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
What are the prerequisites for this Excel Expert course? +
It is recommended to have a very strong foundation in basic & intermediate- level Excel. You can pursue an intermediate-level excel course to build on your excel skills if you are new to this software.
How is this Expert Excel course different from an intermediate-level course? +
The focus and complexity of the curriculum differ significantly in both the levels. Intermediate-level focuses on consolidating basic skills and introduction of advanced techniques, whereas the expert-level covers highly specialized techniques and advanced features for complex data analysis, automation, and visualization.
How long does it take to complete this expert-level course? +
It is a self-paced online course that allows you to study from anywhere, anytime as per your convenience.
How does it help in passing two certification exams MO-200 & MO-201?+
The structured curriculum of this course has been especially designed keeping in mind the exam objectives of MO-200 & MO-201. It delivers the required knowledge and skills for passing both the Microsoft certification exams. There are hands-on Lab exercises and practice questions that simulate the real exam scenarios.
What are the career advantages of doing this course?+
Our advanced Excel Expert 2021 course trains you to analyze complex data and extract valuable insights. This in-demand skill boosts your career prospects and makes you eligible to apply for highly-sought after roles in finance, accounting, data analysis, project management, and more.
Learn Next-Level Excel Skills
Advanced Microsoft Excel 2021 training to boost your performance.
- 1 year of full access
- 28 LiveLab included
- Certificate of completion
No credit card required