Welcome, Guest

Excel 2016 - Expert - Advanced Charting and Data Analysis

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.