Microsoft Excel Advance 2016

Module 1 - Getting the Most from Your Data

Lesson 1.1 - Exploring Scenarios

·          What is a Scenario?

·          Creating a Scenario

·          Saving Multiple Scenarios

·          Creating a Scenario Summary Report

Lesson 1.2 - Using Data Analysis Tools

·          Using a One or Two Input Data Table

·          Using Goal Seek

Lesson 1.3 - Using Solver

·          Enabling Data Analysis Tools

·          Understanding Solver

·          Generating Reports and Scenarios with Solver

·          Changing Solver Values

·          Managing Solver Constraints

·          Choosing a Solving Method

·          Using Solver as a Goal Seek Tool

Lesson 1.4 - Excel and Hyperlinks

·          What is a Hyperlink?

·          Inserting Hyperlinks

·          Editing Hyperlinks

·          Formatting Hyperlinks

·          Using Hyperlinks in Excel

Module 2 - Pivoting Data

Lesson 2.1 - Getting Started with PivotTables

·          What is a PivotTable?

·          Creating a PivotTable

·          Using the PivotTable Tools Tabs

·          Adding and Removing Data with the Field List

·          Changing the Field List Layout

·          Pivoting Data

Lesson 2.2 - Working with PivotTable Data

·          Expanding and Collapsing Data

·          Filtering Data

·          Sorting Data

·          Grouping Data

·          Refreshing Data

·          Editing the Data Source

Lesson 2.3 - Formatting a PivotTable

·          Modifying Fields and Labels

·          Modifying Values

·          Using the Layout Group on the Design Tab

·          Applying a Style to a PivotTable

·          Changing PivotTable Style Options

·          Manually Formatting a PivotTable

·          Using the PivotTable Options Dialog

Lesson 2.4 - Advanced PivotTable Tasks

·          Creating a Slicer

·          Using the Slicer Tools Tab

Module 3 - Advanced Excel Tasks

Lesson 3.1 - Using the VLOOKUP Function

·          Understanding VLOOKUP and HLOOKUP

·          Using VLOOKUP to Find Data

·          How to Find an Exact Match with VLOOKUP

·          Finding an Approximate Match with VLOOKUP

·          Using VLOOKUP as an Array Formula

Lesson 3.2 - Linking, Consolidating, and
                     Combining Data

·          Linking Workbooks

·          Consolidating Workbooks

·          Combining Worksheets