Excel 2013 - Advanced

Course Description

This course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by applying advanced analysis techniques to What-If analysis and Scenario planning. You will learn how to use the advanced features in PivotTables and Power Pivots for analysis of large data sets.
1 days


Experienced MS Excel users who have completed an intermediate course or have a similar level of knowledge.


Having completed the training the attendees will be able to:
• Use the new features in MS Excel 2013
• Use a PivotTable, PivotCharts & PowerPivot to analyse large data sets
• Create what if analysis and scenarios to create Best case, Worst Case of Most Likely projections
• Use advanced functions
• Create a simple dashboard

Analysing Data using PivotTables

• Changing the layout and format of the PivotTable
• Calculations and analysis in Pivot Tables
• Using Slicers to filter the PivotTable data
• Creating a MS Excel Dashboard using Slicers
• Creating and formatting a PivotChart


• Introduction to Power Pivot
• Using the Power Pivot for Business Analysis and reporting
• Creating Vertical and horizontal slicers

What If Analysis

• The Analysis ToolPak
• Creating scenarios to investigate best case and worst case
• Using Goal seek to prepare forecasts or get the desired results
• Data Input Tables to calculate multiple results
• Countifs, Sumifs, iferror

Advanced Excel Tasks

• Creating Drop-down Lists to control data entry
• Editing & Filtering lists
• Protecting Worksheets

Advanced Charting

• Customising charts
• Changing layouts

Introduction to Dashboards

• Creating a simple dashboard
• Customising the screen
• Displaying KPI’s

Introduction to Macros

• Creating click and point macros

ExcelExcel 2013Microsoft ExcelMIcrosoft Excel 2013MS Excel