For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Excel 2021 - Expert - Advanced Charting and Data Analysis

About the course

The Excel 2021 Expert - Advanced Charting and Data Analysis course covers topics included in the MOS Expert exam. 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.