Speaking with Charts (Microsoft Excel 2013/2016) (8 hrs)

Course Code: SX-SWCE-02

This course provides participants with the basic concepts of charting. The participants will demonstrate the ability to create, format and use charts in Microsoft Excel.

  • Learn about the basic concepts of charting
  • Demonstrate ability to create, format, and use charts

Charting

  • Introduction
  • Philosophy
  • Psychology
  • Anatomy
  • Chart types

Creating charts in Excel

  • Creating charts with the chart wizard
  • Moving and resizing charts
  • Identifying chart objects
  • Changing the chart type
  • Changing the chart type and sub-type
  • Changing the plot direction
  • Removing / adding a legend
  • Moving the legend
  • Charting non-adjacent ranges
  • Changing the chart range
  • Changing the data source
  • Changing the chart location
  • Printing a chart
  • Creating charts

Formatting charts in Excel

  • Adding chart titles
  • Formatting chart objects
  • Changing the text orientation
  • Adding a data table
  • Creating an exploded pie chart
  • Adjusting the 3-D view
  • Deleting a chart
  • Formatting charts
  • Applying user-defined charts

Advanced charting in Excel

  • Adding and removing gridlines
  • Formatting gridlines
  • Formatting an axis
  • Changing the axis scaling
  • Formatting the data series
  • Adding data – different worksheets
  • Using a secondary axis
  • Changing data series chart types
  • Adding a trendline

Charts exploration

  • Pie chart
  • Bar / column charts
  • Pictogram charts
  • Histogram charts
  • Polygons charts
  • Line charts
  • XY – scatter charts
  • Radar charts
  • Bubble
  • Cartogram

Bar and column charts

  • Use bar and column charts effectively
  • Create stacked column
  • Create a 100% stacked bar chart
  • Variations of column and bar chart
  • Create pictogram charts

Line and area charts

  • Use line and area charts
  • Create line chart with markers
  • Summarise data into months
  • Use stacked line chart to determine total
  • Change data series order in area chart

Scatter and bubble charts

  • Create a simple scatter (XY) chart
  • Create a multiple XY chart
  • Create a bubble chart
  • Format the bubbles

Create interactive charts with list and PivotChart (optional topic)

  • Use Excel table for creating chart
  • Create a new table
  • Create a chart from a table
  • Get answers with PivotTables
  • Insert a PivotTable
  • Create a PivotTable layout
  • View the report differently
  • Rearrange the layout
  • Create a PivotChart report
  • Create a filtered PivotChart

Participants will benefit from the hands-on practical sessions during the course.

This course is suitable for individuals with general proficiency in Microsoft Excel and looking to create / use charts.

Prerequisite

Participants must have knowledge of MS Office Excel 2013/2016.

Duration : 1 day (8 hrs)
Time : 9:00am – 6:00pm

Course Fee : $320.00
Nett Fee Incl. 7% GST : $342.20

(A course in partnership with COMAT)

Key Benefits
  • Learn about the basic concepts of charting
  • Demonstrate ability to create, format, and use charts
Course Contents

Charting

  • Introduction
  • Philosophy
  • Psychology
  • Anatomy
  • Chart types

Creating charts in Excel

  • Creating charts with the chart wizard
  • Moving and resizing charts
  • Identifying chart objects
  • Changing the chart type
  • Changing the chart type and sub-type
  • Changing the plot direction
  • Removing / adding a legend
  • Moving the legend
  • Charting non-adjacent ranges
  • Changing the chart range
  • Changing the data source
  • Changing the chart location
  • Printing a chart
  • Creating charts

Formatting charts in Excel

  • Adding chart titles
  • Formatting chart objects
  • Changing the text orientation
  • Adding a data table
  • Creating an exploded pie chart
  • Adjusting the 3-D view
  • Deleting a chart
  • Formatting charts
  • Applying user-defined charts

Advanced charting in Excel

  • Adding and removing gridlines
  • Formatting gridlines
  • Formatting an axis
  • Changing the axis scaling
  • Formatting the data series
  • Adding data – different worksheets
  • Using a secondary axis
  • Changing data series chart types
  • Adding a trendline

Charts exploration

  • Pie chart
  • Bar / column charts
  • Pictogram charts
  • Histogram charts
  • Polygons charts
  • Line charts
  • XY – scatter charts
  • Radar charts
  • Bubble
  • Cartogram

Bar and column charts

  • Use bar and column charts effectively
  • Create stacked column
  • Create a 100% stacked bar chart
  • Variations of column and bar chart
  • Create pictogram charts

Line and area charts

  • Use line and area charts
  • Create line chart with markers
  • Summarise data into months
  • Use stacked line chart to determine total
  • Change data series order in area chart

Scatter and bubble charts

  • Create a simple scatter (XY) chart
  • Create a multiple XY chart
  • Create a bubble chart
  • Format the bubbles

Create interactive charts with list and PivotChart (optional topic)

  • Use Excel table for creating chart
  • Create a new table
  • Create a chart from a table
  • Get answers with PivotTables
  • Insert a PivotTable
  • Create a PivotTable layout
  • View the report differently
  • Rearrange the layout
  • Create a PivotChart report
  • Create a filtered PivotChart
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is suitable for individuals with general proficiency in Microsoft Excel and looking to create / use charts.

Prerequisite

Participants must have knowledge of MS Office Excel 2013/2016.

Course Details

Duration : 1 day (8 hrs)
Time : 9:00am – 6:00pm

Course Fee : $320.00
Nett Fee Incl. 7% GST : $342.20

(A course in partnership with COMAT)

Course Application

Details Registration
February 7, 2020 - February 7, 2020 (9:00 am - 6:00 pm) Closed
August 5, 2020 - August 5, 2020 (9:00 am - 6:00 pm) Closed
October 12, 2020 - October 12, 2020 (9:00 am - 6:00 pm) Register Now
December 15, 2020 - December 15, 2020 (9:00 am - 6:00 pm) Register Now