A graph is worth a thousand numbers; when dealing with numbers, a visual representation is often easier to remember. Do you process numbers in Excel regularly and do you want to create useful charts effortlessly? Be sure to register for our ‘Excel: Using Charts’ training.
After this training, you’ll know:
- Which charts to use to illustrate your data
- How to create charts and how to format them using different options
- How to create your own chart templates, which saves you a lot of time
- How to export charts and insert them in a Word or PowerPoint file
Everyone who regularly makes charts to enhance, visualise or report numbers.
Basic Excel knowledge is required.
Part 1 Creating charts
- Keyboard shortcuts
- Components of a chart: gridlines, legends, plot area, chart area, series, etc.
Part 2 Formatting
- Options on the contextual tabs in the ribbon
- Chart formatting control to add parts to the chart quickly
- Formatting the components of a chart (e.g. add and position data labels, create floating charts)
- Charts with a second Y axis
- Adjust the scale of a chart
Part 3 Chart types
- Recommended charts
- Column (2D, 3D)
- Bar (2D, 3D)
- Line (2D, 3D)
- Pie chart (2D, 3D)
- Area (2D, 3D)
- Box & Whisker
- Built-in combined charts
- Combinations of different types
Part 4 Miscellaneous
- Error bars
- Add other objects to a chart
- Export a chart to or create a chart in other Office packages
- Special chart (sparklines)
Part 5 Creating chart templates