Microsoft Excel 2013 - Level 3 / Advanced

Working with Scenarios

• Creating Scenarios
• Loading Scenarios
• Merging Scenarios
• Editing Scenarios
• Creating a Scenario Summary Report
• Deleting Scenarios

Using Goal Seek, Solver and VLookup

• Setting up the Worksheet
• Using Goal Seek
• Running Solver
• Generating Reports and Scenarios with Solver
• Modifying Constraints
• Setting Solver Options
• Use VLookup

Analyzing Data

• Enabling the Analysis ToolPak
• Using Data Analysis Tools
• Using Data Tables

Managing Data

• Consolidating Information
• Removing Duplicates
• Configuring Data Validation
• Transposing Data
• Converting Text to Columns

Working with Slicers

• Inserting and Using a Slicer
• Renaming the Slicer
• Changing Slicer Settings
• Formatting a Slicer
• Clearing the Slicer

Introduction to PivotTable (covered more in-depth in Excel 2013 PivotTable)

• Creating a Basic PivotTable
• Creating a Basic PivotChart
• Using the PivotTable Fields Pane
• Adding Calculated Fields
• Sorting Pivoted Data
• Filtering Pivoted Data

Using the Inquire Add-In

• Installing Inquire
• Generating a Workbook Analysis Report
• Viewing Workbook and Worksheet Relationships
• Viewing Cell Relationships
• Comparing Two Workbooks

Tracking Changes

• Tracking Changes
• Reviewing Changes
• Setting Options for Tracking Changes
• Stopping Tracking Changes

Using Macros

• Recording a Macro
• Writing a Macro using the Visual Basic Editor
• Editing a Macro
• Running a Macro

Working with Scenarios

• Creating Scenarios
• Loading Scenarios
• Merging Scenarios
• Editing Scenarios
• Creating a Scenario Summary Report
• Deleting Scenarios

Using Goal Seek, Solver and VLookup

• Setting up the Worksheet
• Using Goal Seek
• Running Solver
• Generating Reports and Scenarios with Solver
• Modifying Constraints
• Setting Solver Options
• Use VLookup

Analyzing Data

• Enabling the Analysis ToolPak
• Using Data Analysis Tools
• Using Data Tables

Managing Data

• Consolidating Information
• Removing Duplicates
• Configuring Data Validation
• Transposing Data
• Converting Text to Columns

Working with Slicers

• Inserting and Using a Slicer
• Renaming the Slicer
• Changing Slicer Settings
• Formatting a Slicer
• Clearing the Slicer

Introduction to PivotTable (covered more in-depth in Excel 2013 PivotTable)

• Creating a Basic PivotTable
• Creating a Basic PivotChart
• Using the PivotTable Fields Pane
• Adding Calculated Fields
• Sorting Pivoted Data
• Filtering Pivoted Data

Using the Inquire Add-In

• Installing Inquire
• Generating a Workbook Analysis Report
• Viewing Workbook and Worksheet Relationships
• Viewing Cell Relationships
• Comparing Two Workbooks

Tracking Changes

• Tracking Changes
• Reviewing Changes
• Setting Options for Tracking Changes
• Stopping Tracking Changes

Using Macros

• Recording a Macro
• Writing a Macro using the Visual Basic Editor
• Editing a Macro
• Running a Macro