Excel 2019 - Expert - Advanced Charting and Data Analysis

About the course

The Excel 2019 - Expert - Advanced Charting and Data Analysis course covers topics included in the MOS Expert exam 77-728. This includes using Advanced Chart features, PivotTables 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
  • Working with 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

  • Trendlines;
  • Understanding Trendlines
  • Formatting Trendlines;
  • Removing Trendlines;
  • Forecasting Trendlines;
  • Other Trend Methods;
  • Adding Sparklines;
  • Removing Sparklines

Dual Axes and Chart Templates

  • Adding Additional Axes;
  • Changing Marker Colours;
  • Saving a Chart Template;
  • Applying a Chart Template;
  • Apply to Existing Charts.

PivotTables, PivotCharts and Slicers

PivotTables

  • Creating PivotTables;
  • PivotTable Fields List;
  • Hide/Show the Field List;
  • Grouping PivotTable Data;
  • Arranging PivotTables;
  • Adding Calculated Fields;
  • Removing Calculated Fields;
  • Use GETPIVOTDATA.

Working with PivotTables

  • Update PivotTable Data;
  • Displaying PivotTable Records;
  • Showing Report Filter Pages;
  • Customising Fields;
  • Hiding Field Headers;
  • PivotTable Report Options;
  • Formatting PivotTables.

PivotCharts

  • Creating PivotCharts;
  • Filtering PivotCharts;
  • Removing Filters;
  • Switching Axes;
  • Using Quick Layout;
  • Applying Chart Styles;
  • Formatting PivotChart Objects;
  • Changing the Chart Type;
  • Drilling Down.

Slicers

  • What are Slicers';
  • Adding Slicers;
  • Slicer Options;
  • Filtering Slicers;
  • Clearing Filters;
  • Selecting Multiple Slicers
  • Sharing Slicers;
  • Connecting Slicers.

Data Analysis Tools

Data Analysis Tools

  • Naming Variable Cells;
  • Naming the Result Cell;
  • Creating Scenarios;
  • Adding Scenarios;
  • Scenario Manager Options;
  • Create Summary Reports;
  • Using Data Tables;
  • Using Goal Seek.