Microsoft Office Excel 2016 (with Expert Exam)
(LO-77-727-77-728-v2)
This course includes
Lessons
TestPrep
Lab
Microsoft Office Excel 2016 (with Expert Exam)
Prepare for the Microsoft Office Specialist Excel 2016 exam with the Microsoft Office Excel 2016 (with Expert Exam) course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. Interactive chapters comprehensively cover Microsoft Excel 77-727 and Microsoft Excel Expert 77-728 exam objectives and provide the knowledge and skills required to work with functions, lists, analyzing data, visualizing data with charts and using PivotTables and PivotCharts.
The Microsoft Office Specialist 2016 exam validates a candidate's understanding of the Excel environment and their ability to deliver tasks without any help. The 77-727 and 77-728 exams help the candidates in demonstrate Excel 2016 basic features by making and editing workbooks with multiple sheets, and using graphic elements to represent data visually.
Lessons
-
38+ Lessons
-
155+ Quizzes
-
157+ Flashcards
-
157+ Glossary of terms
Test Preps
-
45+ Pre Assessment Questions
-
50+ Post Assessment Questions
Lab
-
49+ Performance lab
-
49+ Video tutorials
-
29+ Minutes
- TOPIC A: Navigate the Excel User Interface
- TOPIC B: Use Excel Commands
- TOPIC C: Create and Save a Basic Workbook
- TOPIC D: Enter Cell Data
- TOPIC E: Use Excel Help
- Summary
- TOPIC A: Create Worksheet Formulas
- TOPIC B: Insert Functions
- TOPIC C: Reuse Formulas and Functions
- Summary
- TOPIC A: Insert, Delete, and Adjust Cells, Columns, and Rows
- TOPIC B: Search for and Replace Data
- TOPIC C: Use Proofing and Research Tools
- Summary
- TOPIC A: Apply Text Formats
- TOPIC B: Apply Number Formats
- TOPIC C: Align Cell Contents
- TOPIC D: Apply Styles and Themes
- TOPIC E: Apply Basic Conditional Formatting
- TOPIC F: Create and Use Templates
- Summary
- TOPIC A: Preview and Print a Workbook
- TOPIC B: Set Up the Page Layout
- TOPIC C: Configure Headers and Footers
- Summary
- TOPIC A: Manage Worksheets
- TOPIC B: Manage Workbook and Worksheet Views
- TOPIC C: Manage Workbook Properties
- Summary
- TOPIC A: Add Borders and Colors to Worksheets
- TOPIC A: Customize General Options and the Excel UI
- Mastery Builder 1-1: Creating and Saving a Workbook Activity
- Mastery Builder 2-1: Creating and Reusing Formulas and Functions
- Mastery Builder 3-1: Modifying a Worksheet
- Mastery Builder 4-1: Formatting a Worksheet
- Mastery Builder 5-1: Printing Workbooks
- Mastery Builder 6-1: Managing Workbooks
- TOPIC A: Work with Ranges
- TOPIC B: Use Specialized Functions
- TOPIC C: Work with Logical Functions
- TOPIC D: Work with Date & Time Functions
- TOPIC E: Work with Text Functions
- Summary
- TOPIC A: Sort Data
- TOPIC B: Filter Data
- TOPIC C: Query Data with Database Functions
- TOPIC D: Outline and Subtotal Data
- Summary
- TOPIC A: Create and Modify Tables
- TOPIC B: Apply Intermediate Conditional Formatting
- TOPIC C: Apply Advanced Conditional Formatting
- Summary
- TOPIC A: Create Charts
- TOPIC B: Modify and Format Charts
- TOPIC C: Use Advanced Chart Features
- Summary
- 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
- Summary
- TOPIC A: Insert Graphical Objects
- TOPIC B: Modify Graphical Objects
- TOPIC C: Work with SmartArt
- TOPIC A: Use Array Formulas
- Mastery Builder 1-1: Working with Functions
- Mastery Builder 2-1: Working with Lists
- Mastery Builder 3-1: Analyzing Data
- Mastery Builder 4-1: Visualizing Data with Charts
- Mastery Builder 5-1: Using PivotTables and PivotCharts
- TOPIC A: Use Links and External References
- TOPIC B: Use 3-D References
- TOPIC C: Consolidate Data
- Summary
- TOPIC A: Use Lookup Functions
- TOPIC B: Trace Cells
- TOPIC C: Watch and Evaluate Formulas
- Summary
- TOPIC A: Collaborate on a Workbook
- TOPIC B: Protect Worksheets and Workbooks
- Summary
- TOPIC A: Apply Data Validation
- TOPIC B: Search for Invalid Data and Formulas with Errors
- TOPIC C: Work with Macros
- Summary
- TOPIC A: Create Sparklines
- TOPIC B: Map Data
- Summary
- TOPIC A: Determine Potential Outcomes Using Data Tables
- TOPIC B: Determine Potential Outcomes Using Scenarios
- TOPIC C: Use the Goal Seek Feature
- TOPIC D: Forecasting Data Trends
- Summary
- TOPIC A: Import and Export Data
- TOPIC A: Internationalize Workbooks
- TOPIC A: Work with Power Pivot
- TOPIC A: Customize Advanced Options
- TOPIC A: Work with Forms and Controls
- Mastery Builder 1-1: Working with Multiple Worksheets and Workbooks
- Mastery Builder 2-1: Using Lookup Functions and Formula Auditing
- Mastery Builder 3-1: Sharing and Protecting Workbooks
- Mastery Builder 4-1: Automating Workbook Functionality
- Mastery Builder 5-1: Creating Sparklines and Mapping Data
- Mastery Builder 6-1: Forecasting Data
Hands on Activities (Labs)
- Exploring the backstage view
- Adding and replacing the data in an excel sheet
- Saving a workbook
- Copying and pasting the text
- Opening the Excel help
- Creating worksheet formulas
- Using the SUM function
- Using the Average function
- Using the Autofill function
- Finding and Replacing the text
- Checking spelling and grammar
- Changing the worksheet font color
- Changing the number format
- Wrapping text
- Formatting a cell range as a table
- Applying a theme to a table
- Applying conditional formatting
- Saving the workbook as an Excel Template file
- Printing an area
- Setting page margin
- Configuring page setup for printing
- Adding a header and footer
- Adding color to the worksheet tabs
- Freezing the top row
- Creating a custom workbook property
- Calculating the years of service values
- Using the SUMIF function
- Changing date format
- Using the Concatenate function
- Filtering data
- Sorting data and using the Subtotal feature
- Deleting duplicate rows and sorting the table
- Formatting values that are above or below average
- Using logical functions
- Inserting a chart and changing the chart style
- Changing the chart color
- Customizing a chart
- Creating a combo chart
- Creating a PivotTable and PivotChart and inserting slicers to filter the PivotTable
- Consolidating the quantity of products data
- Using the VLOOKUP function
- Adding a watch to several cells
- Adding comments
- Protecting a workbook
- Adding data validation
- Creating Sparklines
- Creating a scenario that preserves the original values
- Copying the original data using the Goal Seek feature
- Creating a forecast sheet from monthly sales data
| How many questions are asked in the exam? | The exam contains 40-60 questions. |
|---|---|
| What is the duration of the exam? | 90 minutes |
| What is the passing score? | 70% (on a scale of 0-1000) |
| Which certification covers this exam? | |
| What are the career opportunities after passing this exam? |
|
×
