Course Duration – 1 day
Course Subjects
Excel Charting Concepts
Understanding chart terminology
– Identifying chart elements (such as like plot area, chart area, gridlines, and legends)
– Selecting the right chart type
– Understanding the Ribbon and the Design, Layout, and Format tabs
Creating Basic Charts Quickly
– Selecting data to display as a chart
– Creating charts instantly with shortcuts
– Creating presentation-ready charts with just a few adjustments
– Creating graphic-in-cell charts with Sparklines
Fine-Tuning Charts with Design Tab Choices
– Switching rows and columns for a different view of the data
– Setting a default chart type and creating a template
– Dealing with empty and hidden cells
– Choosing a chart style from 48 colourful variations
– Changing the location of a chart
– Moving and resizing a chart
Layout Tab Options
Inserting Pictures, Shapes, and Text Boxes
– Using pictures as chart elements
– Adding shapes and arrows
– Adding floating text and text boxes
Adding Titles, Labels, and Legends
– Adding and editing chart titles
– Adding horizontal and vertical titles
– Linking titles to content
– Showing different scales
– Specifying the position of tick marks and axis labels
– Changing the numeric format on labels
– Adding, editing, and removing legends
– Adding and editing data labels
– Showing the source of a chart’s data
Using Axes and Gridlines
– Modifying axis scaling
– Working with gridlines
Using the Analysis Tools
– Analyzing existing and future data with trendlines
– Adding drop lines
– Adding high-low lines and up-down bars
– Adding error bars
Format Options
Adding Shapes and WordArt Styles
– Selecting shape fill and outline
– Adding shape effects
– Applying WordArt styles
Using Other Formatting Tools
– Formatting lines and borders
– Filling an area with a colour gradient
– Specifying line style and weight
– Working with chart text
– Changing the rotation of chart text
Adjusting Specific Chart Types
– Column, line and pie charts
– Area, stock, and XY charts
– Doughnut, bubble, and radar charts
– Creating a Waterfall chart
Changing a Chart’s Data Source
-Pasting new data into a chart
-Creating charts from multiple data sources
-Adding new data using a table
Printing and Sharing Charts
– Printing charts
– Copying and linking charts with Word and PowerPoint