Create a Chart
Overall Chart Design
Chart Styles and Layout
Chart Shape Design
Chart Text Design and Chart Labels
Chart Axes
Chart Gridlines
Adding More Data
Selecting the Correct Chart & Data
Select a chart element by using the mouse
Select a chart element from a list of chart elements
Changing the Chart Type
Changing the cells to be plotted
Changing fonts and formats
Understanding Series
Creating a sparkline
Tables
Add data to a Table
Total the data in an Excel table
Summarising data with PivotTables
Creating and formatting a Pivot Table
Using calculated fields and items
Creating PivotCharts
Modifying the Pivot Chart
Distribution