Excel 2013 - Advanced

Request more details:

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.
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
PowerPivot :
• 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