About the course

The Excel 2016 - Expert - Advanced Charting and Data Analysis course covers topics included in the MOS Expert exam 77-728. This includes using Advanced Chart features, PivotTables, Cube Functions and PivotCharts. You will also learn how to create Scenarios, Data Tables and use Goal Seek.

Modules

There are 7 modules in this course

• Trendlines and Sparklines
• Dual Axes and Chart Templates
• PivotTables
• Cubes and PivotTables
• PivotCharts
• Slicers
• Data Analysis Tools

Course features

• Simulation training replicates the software you are learning providing a realistic learning experience.
• Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
• Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
• Assess your skills at any time by undertaking the Course Test.
• Lessons can be completed within 30 minutes so training can be undertaken in 'bite' size pieces.
• Bookmarking allows you to learn in multiple training sessions.
• Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
• Designed for people who require initial and refresher training activities.
• Available on-line 24 hours a day.
• Version for Mobile Devices.
• Review course content with eBooks

Youll learn how to:

Advanced Chart Features - Trendlines and Sparklines

• Understand Trendlines;
• Add a Trendline to a Data Series;
• Format Trendlines;
• Remove Trendlines;
• Use Trendline Forecasting;
• Identify Other Trend Methods;
• Add Sparklines;
• Remove Sparklines.

Dual Axes and Chart Templates

• Add a Second Chart Axis;
• Change Marker Colours;
• Save Chart Templates;
• Apply Chart Templates
• Apply Templates to Existing Charts

PivotTables, PivotCharts and Slicers - PivotTables

• Create PivotTables;
• Set the Layout for PivotTables;
• Group PivotTable Data;
• Arrange PivotTables;
• Add Calculated Fields;
• Remove Calculated Fields;
• Use GETPIVOTDATA.

Cubes and PivotTables

• Use Cube Functions;
• Update PivotTable Data;
• Display PivotTable Records;
• Show Report Filter Pages;
• Customise Fields;
• Hide Field Headers;
• Use PivotTable Report Options;
• Format PivotTables.

PivotCharts

• Create PivotCharts;
• Apply Filters to PivotCharts;
• Remove Filters;
• Switch PivotChart Axes;
• Use Quick Layout;
• Apply Chart Styles;
• Format PivotChart Objects;
• Change the Chart Type.

Slicers

• Understand Slicers;
• Add Slicers;
• Set Slicer Options;
• Apply Filters on Slicers;
• Clear Filters;
• Share Slicers;
• Connect Slicers.

Data Analysis Tools - Data Analysis Tools

• Name Variable Cells;
• Create Scenarios;
• Select Scenario Variables;
• Delete Scenarios;
• Edit Scenarios;
• Create Summary Reports;
• Use Data Tables;
• Use Goal Seek.