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.