Excel 2013 - Advanced

Request more details:

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.
Prerequisites:
Experienced MS Excel users who have completed an intermediate course or have a similar level of knowledge.
COURSE OBJECTIVES:
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