Microsoft Office Excel 2016 Expert (77-727-77-728)
Get certified for the Microsoft Excel certification exams with the Microsoft Office Excel 2016 Expert (77-727-77-728) course and lab. The lab provides a hands-on learning experience in a safe, online environment. The Microsoft Excel training course covers the Excel expert exam objectives and teaches you how to create and manage 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.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
25+ Pre Assessment Questions |
25+ Post Assessment Questions |
Features
50+ LiveLab |
100+ Video tutorials |
03:27+ Hours
128+ Videos |
05:48+ Hours
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
Introduction
- Course Overview
- About 77-727 and 77-728 Exams
- Prerequisites
Lessons 2:
Creating and Formatting Worksheets
- Creating Worksheets and Workbooks
- Navigating in Worksheets and Workbooks
- Formatting Worksheets and Workbooks
- Customizing Options and Views for Worksheets and Workbooks
- Summary
Lessons 3:
Configuring and Managing Workbooks
- Configuring Worksheets and Workbooks for Distribution
- Managing Workbooks
- Managing Workbook Review
- Summary
Lessons 4:
Applying Custom Data Formats and Layouts
- Applying Custom Data Formats and Validation
- Applying Advanced Conditional Formatting and Filtering
- Creating and Modifying Custom Workbook Elements
- Preparing a Workbook for Internationalization
- Summary
Lessons 5:
Managing Data Cells and Ranges
- Inserting Data in Cells and Ranges
- Formatting Cells and Ranges
- Summarizing and Organizing Data
- Summary
Lessons 6:
Creating Tables
- Creating and Managing Tables
- Managing Table Styles and Options
- Filtering and Sorting Tables
- Summary
Lessons 7:
Performing Operations with Formulas and Functions
- Summarizing Data by Using Functions
- Performing Conditional Operations by Using Functions
- Formatting and Modifying Text by Using Functions
- Summary
Lessons 8:
Creating Advanced Formulas
- 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
Lessons 9:
Creating Charts and Objects
- Creating Charts and Objects
- Formatting Charts
- Inserting and Formatting Objects
- Summary
Lessons 10:
Creating Advanced Charts and Tables
- Creating Advanced Charts
- Creating and Managing PivotTables
- Creating and Managing PivotCharts
- Summary