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
€225.00
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 macrosExcelExcel 2013Microsoft ExcelMIcrosoft Excel 2013MS Excel