Description

Type

Course
Level

Intermediate
Methodology

Online

Duration

Flexible
Start date

Different dates available

In this Excel 2016 for PC – Charting online training series, you’ll learn how to harness Microsoft® Excel® 2016’s charting capabilities so you can effectively compare data and communicate your information.

Facilities

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

MS Excel
PC training
PC
Excel
Conditional Formatting
Pivot tables
Excel Functions
Advanced Formulas
Tables & Formatting
Advanced Charting
Pivot Reporting
VBA & Macros
Excel Productivity
Excel protection

Teachers and trainers (1)

Name Name

Teacher

Course programme

A. Getting Started

What you’ll learn
Overview of Charts
Identify elements of a chart
Select chart data in adjacent cells
Select chart data in nonadjacent cells
Charting using the chart group buttons
Quick analysis tool

B. Chart Tabs and Ribbons

View a sample chart
Create column and bar charts
Create line charts
Create pie and doughnut charts
Create scatter and bubble charts
Create area charts
Create radar charts
Create surface charts
Create stock charts
Create a chart template
Create a combo chart
Create a trendline for a chart

C. Format Your Chart

Add titles and labels
Change the chart type
Format the chart area
Add a border and/or patterns to the plot area
Format the axis properties
Set format options for titles and labels
Set the placement and font for the legend
Change the data series
Change the data series pattern or marker
Change the shape of a 3D data marker
Change the plot order
Resize and reposition
Show or hide the data table
Change the gap and overlap values
Change the elevation and rotation
Pulling out slices
Use a graphic or picture

D. Present Your Chart

Place a chart on a separate chart sheet
Print a chart sheet
Print embedded charts
Insert a static copy of a chart
Insert a linked copy of a chart
Save your chart as a Web page

E. Work with Sparklines

Create sparklines
Group and ungroup sparklines
Edit the sparkline data
Change the sparkline type
Show sparkline data points
Format the sparkline
Change axis settings
Change hiddine and empty cell settings
Clear sparklines

F.New Chart Types

Creating a histogram chart and pareto lines
Creating a waterfall chart
Creating box and whisker plots
Creating tree maps and sunburst maps

Additional information

LENGTH

1 hr 42 min

See related categories

Contact us

Excel 2016 for PC - Charting

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

Excel 2016 for PC - Charting

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.