MSEXCEL-EXP.AD1
Microsoft Excel 2021 Expert
Prepare for MO-200 & MO-201 Microsoft certification exams. Learn advanced workbook skills.
- Practice in 28 Laboratorios prácticos — nothing to install
- 15 Lecciones interactivas y 25 topics mapped to the official exam objectives
- 118 Preguntas del examen de práctica
Expert A tu propio ritmo · 1 año de acceso
28 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
15Lecciones interactivas
25Topics
28Laboratorio en vivo
118Preguntas del examen de práctica
48Tarjetas didácticas
48Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
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
- Contadores Estimador de costos Periodista de datos Gerente minorista Gerente de proyectos Analista de negocios Analista financiero Empleado de información Asistente administrativo
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
15 Lecciones interactivas · 25 topics01 About This Course 1 topics +
- Course Description
02 Working with Multiple Worksheets and Workbooks 3 topics · 4 Laboratorio en vivo +
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
4 Laboratorio en vivo in this lesson — see the labs panel →
03 Sharing and Protecting Workbooks 2 topics · 5 Laboratorio en vivo +
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
5 Laboratorio en vivo in this lesson — see the labs panel →
04 Automating Workbook Functionality 3 topics · 4 Laboratorio en vivo +
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
4 Laboratorio en vivo in this lesson — see the labs panel →
05 Using Lookup Functions, Dynamic Arrays, and Formula Auditing 4 topics · 12 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
06 Forecasting Data 4 topics · 2 Laboratorio en vivo +
- 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 Laboratorio en vivo in this lesson — see the labs panel →
07 Creating Sparklines and Mapping Data 2 topics · 1 Laboratorio en vivo +
- Topic A: Create Sparklines
- Topic B: Map Data
1 Laboratorio en vivo 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
Laboratorios prácticos Our edge
28 Laboratorio en vivos- 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
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
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 año de acceso completo
- 28 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito