Excel 2013 Advanced

Course details

The Advanced Excel 2013 training course covers the key topics required by users of this application, including the brand new features of this version, with lots of in-depth explanations, step by step instructions, key questions and group and individual activities.

Objectives

This course is designed to help you to extend your knowledge into some of the more specialised and advanced capabilities of Excel. You will learn how to outline and group data, work with Scenarios and Solver, work with the Analysis ToolPak, use PivotTable features, PowerPivot, and develop macros.

Content

Outlining and Grouping Data

• Outlining Data
• Showing and Hiding Outline Details
• Grouping Data
• Creating Subtotals
• Removing Outlining and Grouping

Working with Scenarios

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

Using Solver

• Setting up the Worksheet
• Running Solver
• Generating Reports and Scenarios with Solver
• Modifying Constraints
• Setting Solver Options

Analysing Data

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

Advanced PivotTable Features

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

Using PowerPivot

• Enabling PowerPivot
• Importing Access Data
• Importing Excel Data
• Creating a PivotTable with PowerPivot Data

Using Macros

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

Prerequisites

It is also recommended that proposed delegates have attended a Microsoft Excel 2013 Intermediate course or have equivalent knowledge.

Who should attend?

This course is designed for Microsoft Excel users who wish to develop their skills so they can use the advanced techniques to manipulate Excel data.