Advanced Excel 2013

Advanced Excel 2013

Course 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

Learning Outcomes: 
Understand how to outline and group data
Know how to use "solver"
Know how to create and use pivot table
Understand macros
Know how to use Power Pivot
Course Assessment: 

Practical and theory

Course Requirements: 

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

Name of Trainer: 
Sure Skills
Course Venue: 
Training rooms
Sure Skills
14 Fitzwilliam street
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
Start Date: 
21st September 2017
Course Days and Times: 
Thursday 9.00 am to 5.00 pm
Subsidised Fee for Network Member Company (€): 
This course is available to employees only.

Register Your Interest

This course is available to employed persons only.

If you are unemployed we have lots more courses that you may be interested in.

Find a course.

This form expresses your interest in this training course.

This question is used to help prevent automated spam submissions.

Any Questions? Contact us


Enterprise Led Learning and Training Networks

5th Floor, Q House, 76 Furze Road, Sandyford, Dublin 18, Ireland.

+353 1 2079630