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.