uCertify

Microsoft Excel 2021 Expert

Prepare for MO-200 & MO-201 Microsoft certification exams. Learn advanced workbook skills.

(MSEXCEL-EXP.AD1) / ISBN : 978-1-64459-432-2
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

About This Course

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.

Skills You’ll Get

  • 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

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

About This Course

  • Course Description
2

Working with Multiple Worksheets and Workbooks

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
3

Sharing and Protecting Workbooks

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
4

Automating Workbook Functionality

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
5

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • Topic A: Use Lookup Functions
  • Topic B: Use Dynamic Arrays and Dynamic Array Functions
  • Topic C: Trace Cells
  • Topic D: Watch and Evaluate Formulas
6

Forecasting Data

  • 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
7

Creating Sparklines and Mapping Data

  • Topic A: Create Sparklines
  • Topic B: Map Data
A

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

B

Appendix B: Cube Functions

C

Appendix C: Importing and Exporting Data

  • Topic A: Import and Export Data
D

Appendix D: Internationalizing Workbooks

  • Topic A: Internationalize Workbooks
E

Appendix E: Working with Power Pivot

  • Topic A: Work with Power Pivot
F

Appendix F: Advanced Customization Options

  • Topic A: Customize Advanced Options
G

Appendix G: Working with Forms and Controls

  • Topic A: Work with Forms and Controls
H

Appendix H: Using Array Formulas

  • Topic A: Use Array Formulas

1

Working with Multiple Worksheets and Workbooks

  • Creating Links
  • Creating External Links
  • Creating a 3-D Formula
  • Consolidating Data
2

Sharing and Protecting Workbooks

  • 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
3

Automating Workbook Functionality

  • 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
4

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • 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
5

Forecasting Data

  • Creating a Two-Variable Data Table
  • Creating a Forecast Sheet
6

Creating Sparklines and Mapping Data

  • Creating Sparklines

Any questions?
Check out the FAQs

Take a peek into the most commonly asked questions about our Microsoft Excel Expert 2021 course.

Contact Us Now

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.

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.

It is a self-paced online course that allows you to study from anywhere, anytime as per your convenience.

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.

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.

Related Courses

All Course