Seat time: 3 hours
About the course:
This 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:
- Trendlines and Sparklines
- Dual Axes and Chart Templates
- PivotTables
- Working with PivotTables
- PivotCharts
- Slicers
- Data Analysis Tools
You'll learn:
Trendlines and Sparklines
- Trendlines
- Understanding Trendline
- 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
- 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 Slicer
- Connecting Slicers
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