MSEXCEL-INT.AD1
Microsoft Excel 2021 Intermediate
Online Training course to help you pass Microsoft Office Specialist certification exams, MO-200 & MO-201.
- Practice in 30 Laboratorios prácticos — nothing to install
- 9 Lecciones interactivas y 23 topics mapped to the official exam objectives
- 145 Preguntas del examen de práctica
Intermediate A tu propio ritmo · 1 año de acceso
30 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
9Lecciones interactivas
23Topics
30Laboratorio en vivo
145Preguntas del examen de práctica
39Tarjetas didácticas
39Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
Elevate your spreadsheet skills with our Microsoft Excel 2021 - Mastering Intermediate Skills training course. The comprehensive course curriculum allows you to explore the full potential of Excel spreadsheets to accelerate your workflow with essential Excel keyboard shortcuts and other tools. You’ll be learning complex functionalities like logic, date and time, text, and specialized functions. You” ll be exploring advanced techniques to organize and analyze data for extracting valuable insights using Microsoft Excel 2021.
- Expertise in using advanced functions like logical, date and time, text, and specialized functions.
- Sort and extract information from a given set of data
- Knowledge of database functions, data outlining, and subtotalling
- Skilled in using PivotTables, and PivotCharts alongside timelines and slicers
- Create various chart types and customize their appearance with advanced chart formatting techniques
- Familiarity with SmartArt graphics to create professional-looking diagrams and illustrations
- Knowledge of keyboard shortcuts for enhanced productivity
- Ability to apply conditional formatting to highlight specific data patterns and trends
Course Highlights
-
9 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
30 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
145 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
9 Lecciones interactivas · 23 topics01 About This Course 1 topics +
- Course Description
02 Working with Functions 5 topics · 12 Laboratorio en vivo +
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
12 Laboratorio en vivo in this lesson — see the labs panel →
03 Working with Lists 4 topics · 3 Laboratorio en vivo +
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 Laboratorio en vivo in this lesson — see the labs panel →
04 Analyzing Data 3 topics · 3 Laboratorio en vivo +
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
3 Laboratorio en vivo in this lesson — see the labs panel →
05 Visualizing Data with Charts 3 topics · 6 Laboratorio en vivo +
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
6 Laboratorio en vivo in this lesson — see the labs panel →
06 Using PivotTables and PivotCharts 4 topics · 6 Laboratorio en vivo +
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
6 Laboratorio en vivo in this lesson — see the labs panel →
07 Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts +
08 Appendix B: Financial Functions +
09 Appendix C: Working with Graphical Objects 3 topics +
- Topic A: Insert Graphical Objects
- Topic B: Modify Graphical Objects
- Topic C: Work with SmartArt
Laboratorios prácticos Our edge
30 Laboratorio en vivos- Creating Named Ranges
- Editing Range Names
- Using an Existing Range in a Function
- Using the Formula AutoComplete Method to Enter Range Names
- Using the TODAY Function
- Calculating the Years of Service for Each Employee
- Adding the Arguments for the IF Portion of the Nested Function
- Calculating the 1 Percent Goal Bonus for Employees
- Using the NETWORKDAYS Function
- Extracting the Building Code from the Combined Field
- Extracting the Floor Code from the Combined Field
- Concatenating the Names in a Single Field
- Filtering the Data for all Employees
- Creating a Custom Filter
- Using Database Functions
- Converting the Data into a Table
- Applying a Quick Style to a Table
- Adding New Entries to a Table
- Creating a Clustered Column Chart
- Changing the Labels of the Line Chart
- Changing the Chart Type
- Creating the Combo Chart
- Adding the Trendline
- Saving a Chart as a Template
- Adding Fields to the PivotTable
- Building the PivotTable Report
- Sorting the Values
- Modifying the Formatting of the PivotTable Report
- Modifying the PivotTable Report
- Inserting a Timeline
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
What are the prerequisites for taking the Microsoft Excel 2021 Intermediate course?+
You need to have a strong foundation of basic Excel skills to pursue this course. Good understanding of the core fundamentals will help you understand the advanced topics better.
What is the difference between an intermediate and an advanced Excel course?+
Intermediate-level focuses on foundational knowledge covering topics like advanced formulas & functions, data-analysis tools, conditional formatting, and so on. Advanced-level, on the other hand, delves into more technical and sophisticated techniques like VBA, PowerPivot, PowerBI, and more. To summarize, Intermediate Excel provides tools to manage and analyze data while advanced Excel empowers you to automate processes.
How long does it take to complete the Microsoft Excel 2021 Intermediate course?+
It’s a self-paced course that can be completed at your own pace from anywhere, anytime.
Does this course require the installation of Microsoft Excel 2021?+
No, this course comes with hands-on Labs that allow you to practice your learning in a virtual environment. You don’t need to get any expensive software licenses.
How can I demonstrate my Excel skills to employers after completing this course?+
Students can easily demonstrate their skills to potential employers by following these steps:
- Create a mock dataset to showcase your practical assignment
- Demonstrate the process with detailed explanation through live video recording
- Highlight your problem-solving ability with creative solutions to project-related challenges
- Last but not the least, create a portfolio on platforms like GitHub, GitLab, or personal websites to showcase your Excel projects
How does this course help in preparing for two Microsoft certifications?+
This course can help you prepare for two certifications including MO-200 & MO-201. The curriculum has been especially designed in sync with the exam objectives for these 2 exams. It covers many essential topics, such as advanced formulas, data analysis, and data visualization. The hands-on Lab exercises will help you develop the hands-on skills needed to pass these exams.
Learn Advanced Excel Skills
Analyze complex datasets, create insightful visualizations, and automate tasks.
- 1 año de acceso completo
- 30 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito