Search Our Content Library

Microsoft Excel

Excel 2016 Advanced (2016)

Schedule a Demo

Learning Path Courses:

Using Advanced IF Statements

Using Advanced IF Statements
(Approximate Duration: 9 minutes)

Welcome to the Using Advanced IF Statements part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Summarize Data with the SUMIF, AVERAGEIF and COUNTIF statements

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Using Advanced Lookup Functions

Using Advanced Lookup Functions
(Approximate Duration: 21 minutes)

Welcome to the Using Advanced Lookup Functions part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Use VLOOKUP and HLOOKUP with TRUE
Use the INDEX and MATCH functions
Combine INDEX and MATCH
Compare Two Lists with VLOOKUP and ISNA

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Using Complex Logical and Text Functions

Using Complex Logical and Text Functions
(Approximate Duration: 11 minutes)

Welcome to the Using Complex Logical and Text Functions part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Create Nested IF Function
Use the IFERROR Function
Use the LEN and TRIM Functions
Use the SUBSTITUTE Function

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Formula Auditing

Formula Auditing
(Approximate Duration: 8 minutes)

Welcome to the Formula Auditing part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Show Formulas
Trace Precedents and Dependents
Add a Watch Window
Do Error Checking

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
What-If Analysis Tools

What-If Analysis Tools
(Approximate Duration: 8 minutes)

Welcome to the What-If Analysis Tools part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Use the Scenario Manager
Use Goal Seek
Analyze with Data Tables

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Worksheet and Workbook Protection

Worksheet and Workbook Protection
(Approximate Duration: 11 minutes)

Welcome to the Worksheet and Workbook Protection part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Understand Protection
Encrypt Files with Passwords
Allow Specific Worksheet Changes
Add Protection to Selected Cells

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Advanced Use of PivotTables and PowerPivot

Advanced Use of PivotTables and PowerPivot
(Approximate Duration: 15 minutes)

Welcome to the Advanced Use of PivotTables and PowerPivot part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Use the PivotTable and PowerPivot Wizard
Add a Calculated Field or Item
Apply Conditional Formatting to a PivotTable
Create Filter Pages for a PivotTable

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Automating with Macros

Automating with Macros
(Approximate Duration: 19 minutes)

Welcome to the Automating with Macros part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Understand Macros
Display the Developer Tab
Basic Macro Formatting
Create and Run Macros
Assign Macros to a Button
View and Edit VBA Code

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Working with Form Controls

Working with Form Controls
(Approximate Duration: 6 minutes)

Welcome to the Working with Form Controls part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Create Form Control
Add Spin Buttons and Check Boxes
Add a Combo Box

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Ensuring Data Integrity

Ensuring Data Integrity
(Approximate Duration: 14 minutes)

Welcome to the Ensuring Data Integrity part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Restrict Data Entry types
Compose Input Messages and Error Alerts
Find Invalid Data
Edit and Delete Data Validation Rules

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Collaborating in Excel

Collaborating in Excel
(Approximate Duration: 16 minutes)

Welcome to the Collaborating in Excel part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Work with Comments
Print Comments and Errors
Share a Workbook
Track Changes
Work with Versions

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.
Importing and Exporting Data to a Text File

Importing and Exporting Data to a Text File
(Approximate Duration: 4 minutes)

Welcome to the Importing and Exporting Data to a Text File part of the Microsoft Office, Excel 2016 Advanced Learning Path

Course Objectives
The material presented in this course will help you:
Import a Text File
Export Data to a Text File

Course Prerequisites
Excel 2016 Intermediate
Excel 2016 Beginner

Tips:
Turn off your phone, close your email, text and social media apps.
Plug headphones or ear buds to your computer.
Go Full Screen when watching videos.