77-727-77-728
Microsoft Office Excel 2016 Expert (77-727-77-728)
Prepare for the Excel Certification Exam with 100+ video tutorials and 50+ Live Lab exercises.
- Practice in 50 Laboratorios prácticos — nothing to install
- 10 Lecciones interactivas y 44 topics mapped to the official exam objectives
- 75 Preguntas del examen de práctica
Intermediate A tu propio ritmo · 1 año de acceso 4.7/5 (17 Revisar)
50 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
10Lecciones interactivas
44Topics
50Laboratorio en vivo
75Preguntas del examen de práctica
104Vídeos
56Tarjetas didácticas
56Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
Upgrade your excel skills with this Microsoft Excel 2016 Expert certification preparatory course. Gain a deep understanding of Excel's advanced features to manage complex data analysis and reporting tasks using Microsoft Excel 2016. This training course covers the Excel expert exam objectives focusing on how to create and optimize worksheets and workbooks, manage data cells and ranges, create tables, perform operations with formulas and functions, create charts and objects, and create advanced charts and tables. By the end of this Expert 77-727 & 77-728 certification exam training course you’ll learn how to apply advanced data analysis techniques to extract meaningful insights and create professional reports.
- Ability to create, configure, review and manage multiple worksheets within a workbook
- Apply custom data formats for data consistency and accuracy
- Highlight data values or conditions with conditional formatting
- Data validation to prevent errors and maintain integrity
- Complex formulas for logical, mathematical, statistical, and financial functions
- Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH) to retrieve data
- Date and time functions for calculations and formatting
- Summarize and analyze large datasets with PivotTables and PivotCharts
- Identify trends, patterns, and outliers with data analysis tools
- Create and customize different chart types to visualize data
- Insert and customize shapes, text boxes, and objects within the worksheets
- Filter and sort data within tables
- Define named ranges and simplify formula creation to automate tasks
Target Career Roles
- Editor
- Analista de datos
- Administrador de sistemas de Microsoft
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
10 Lecciones interactivas · 44 topics01 Introduction 3 topics +
- Course Overview
- About 77-727 and 77-728 Exams
- Prerequisites
02 Creating and Formatting Worksheets 5 topics · 21 Laboratorio en vivo +
- Creating Worksheets and Workbooks
- Navigating in Worksheets and Workbooks
- Formatting Worksheets and Workbooks
- Customizing Options and Views for Worksheets and Workbooks
- Summary
21 Laboratorio en vivo in this lesson — see the labs panel →
03 Configuring and Managing Workbooks 4 topics · 4 Laboratorio en vivo +
- Configuring Worksheets and Workbooks for Distribution
- Managing Workbooks
- Managing Workbook Review
- Summary
4 Laboratorio en vivo in this lesson — see the labs panel →
04 Applying Custom Data Formats and Layouts 5 topics · 1 Laboratorio en vivo +
- Applying Custom Data Formats and Validation
- Applying Advanced Conditional Formatting and Filtering
- Creating and Modifying Custom Workbook Elements
- Preparing a Workbook for Internationalization
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
05 Managing Data Cells and Ranges 4 topics · 5 Laboratorio en vivo +
- Inserting Data in Cells and Ranges
- Formatting Cells and Ranges
- Summarizing and Organizing Data
- Summary
5 Laboratorio en vivo in this lesson — see the labs panel →
06 Creating Tables 4 topics · 3 Laboratorio en vivo +
- Creating and Managing Tables
- Managing Table Styles and Options
- Filtering and Sorting Tables
- Summary
3 Laboratorio en vivo in this lesson — see the labs panel →
07 Performing Operations with Formulas and Functions 4 topics · 2 Laboratorio en vivo +
- Summarizing Data by Using Functions
- Performing Conditional Operations by Using Functions
- Formatting and Modifying Text by Using Functions
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
08 Creating Advanced Formulas 7 topics · 7 Laboratorio en vivo +
- Applying Functions in Formulas
- Looking up Data Using Functions
- Applying Advanced Date and Time Functions
- Performing Data Analysis and Business Intelligence
- Troubleshooting Formulas
- Defining Named Ranges and Objects
- Summary
7 Laboratorio en vivo in this lesson — see the labs panel →
09 Creating Charts and Objects 4 topics · 6 Laboratorio en vivo +
- Creating Charts and Objects
- Formatting Charts
- Inserting and Formatting Objects
- Summary
6 Laboratorio en vivo in this lesson — see the labs panel →
10 Creating Advanced Charts and Tables 4 topics · 1 Laboratorio en vivo +
- Creating Advanced Charts
- Creating and Managing PivotTables
- Creating and Managing PivotCharts
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
50 Laboratorio en vivos- Creating a New Workbook
- Inserting a Column
- Creating a Workbook from a Template
- Printing a Workbook
- Importing Data from a File
- Copying and Pasting Contents
- Exploring the Format Task Pane
- Auto-Hiding the Ribbon
- Entering the Date and Time
- Adding Worksheets to Workbooks
- Understanding Cell References
- Changing the Workbook View
- Setting and Saving the Print Area
- Changing the Width of the Column to Automatically Fit the Contents
- Changing the Row Height to Fit Contents
- Adding Commands to a New Group
- Modifying a Worksheet
- Adding New Commands to the Quick Access Toolbar
- Hiding a Column
- Formatting Numbers
- Hiding or Unhiding the Content
- Arranging Excel Windows
- Protecting a Worksheet
- Freezing the Top Row
- Protecting a Workbook's Structure
- Changing Date Format
- Entering Text and Values
- Using Relative, Absolute, and Mixed References
- Changing the Text Color
- Using the Middle Align and Center Command
- Formatting a Heading
- Deleting and Editing the Cell Content
- Converting a Table to a Cell Range
- Changing the Table Style
- Using the UPPER Function
- Using the PROPER Function
- Using the INDEX Function
- Using the MATCH Function
- Using the DATE Function
- Using the WORKDAY Function
- Using the TODAY Function
- Creating a Data Table
- Creating Names for Cell Ranges
- Removing Gridlines and Headings
- Changing the Chart Title
- Inserting and Configuring a Shape
- Inserting SmartArt
- Inserting WordArt
- Inserting and Modifying an Image
- Creating a PivotTable Automatically
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Detalles del examen
Microsoft Office Excel 2016 Expert (77-727-77-728) Detalles
Para obtener la certificación de Microsoft Excel, debe aprobar los exámenes de certificación 77-727 y 77-728. Los objetivos del examen 77-727 incluyen la creación y administración de hojas de cálculo y libros de...
Questions
40-60
(por examen)
Duration
50 minutos
(por examen)
Passing Score
The passing score varies from exam to exam and is provided on the score report.
(puntuación escalada)
Exam Fee
USD 100
(por examen)
Delivered by
Certiport
(presencial u online)
Question Format
The exam consists of performance based questions and is...
opción única/múltiple, basado en el desempeño
Exámenes de práctica
75 Preguntas de práctica
(alineado con los objetivos oficiales del examen)
Certificación
77-727-77-728
Microsoft credencial
¿Listo para presentar el examen?
Agrega tu 77-727-77-728 bono de examen oficial a tu pedido.
Bono oficial · Entrega rápida · Paquete de repetición disponible
El bono de examen se vende por separado y no está incluido en el curso estándar.
04 / Preguntas frecuentes
Preguntas antes de empezar
What is the difference between exams 77-727 and 77-728? +
Both are separate Microsoft Office Specialist (MOS) exams conducted to validate your Excel 2016 skills. Exam 77-727 is the prerequisite for Exam 77-728 so you’ll need to pass both for this certification. While Exam 77-727 tests your basic Excel skills, Exam 77-728 demonstrates advanced Excel capabilities.
Who should take this course? +
This course is especially beneficial for those from the finance, accounting, marketing, or data science backgrounds who need to work with large datasets for performing in-depth analysis.
What is the format of the MOS Expert certification exams (77-727 and 77-728)? +
This exam has a performance based format with different types of questions including multiple-choice, multiple select, fill-in-the-blank, drag and drop, and matching.
Is this advanced Excel 2016 course worth it? +
Yes, it is definitely worth your time and investment if you want to learn advanced Excel skills and techniques to improve your productivity and efficiency in data analysis and reporting.
What is the duration for the exams 77-727 and 77-728? +
Exam 77-727 has a limit of 90 minutes whereas exam 77-728 has a time limit of 110 minutes.
What is the exam fee for MOS Excel 2016 Expert certification?+
The exam fee is $100.
¿Cuáles son los requisitos previos para este examen?+
No existen requisitos técnicos previos para este examen de certificación.
¿Cuál es la cuota de inscripción al examen?+
USD 100
¿Dónde puedo hacer el examen?+
¿Cuál es el formato del examen?+
El examen consta de preguntas basadas en el desempeño y se realiza en un entorno real o simulado. MOS 2013 presenta al candidato un proyecto en el que debe desarrollar tareas y pasos que se complementan entre sí.
¿Cuántas preguntas se hacen en el examen?+
El examen consta de entre 40 y 60 preguntas.
¿Cuál es la duración del examen?+
50 minutos
¿Cuál es la puntuación mínima para aprobar?+
La puntuación mínima para aprobar varía de un examen a otro y se indica en el informe de calificaciones.
¿Cuál es la política de repetición del examen?+
Política de repetición del examen de Microsoft Office Specialist (MOS)
- Si un candidato no obtiene la calificación mínima para aprobar un examen la primera vez, deberá esperar 24 horas antes de volver a presentarse.
- Si un candidato no obtiene una calificación aprobatoria la segunda vez, deberá esperar 2 días (48 horas) antes de volver a realizar el examen por tercera vez.
- Se impondrá un período de espera de dos días entre cada repetición del examen.
- No existe un límite anual en el número de intentos para realizar el mismo examen.
- Si un candidato obtiene una calificación aprobatoria en un examen de Office, puede volver a presentarse.
¿Cuál es la validez de la certificación?+
Para toda la vida
¿Dónde puedo encontrar más información sobre este examen?+
Learn Next Level Excel Skills
To perform data analysis, reporting, and business intelligence.
- 1 año de acceso completo
- 50 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito