Microsoft Excel Charts Training: 1 Day

Excel Chart Training Course Microsoft® Excel Chart Training
By TED Integrated
Microsoft® Excel Series:

Microsoft® Excel 2016 Charting Tricks

“More than the basics of Excel Charts...”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Microsoft® Excel 2016 Charting Tricks
Training Category:
Information Technology
Target Audience:
This training is for end users seeking proficiency in the use of Microsoft Excel Chart at an Advanced Level.
Duration:
1 Day
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Presentation Handouts
  • Computer Lab Work
  • Lecture
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This course explains more than the basics of Excel Charts. You will learn how to create different types of charts, select charts for different categories of data in Microsoft® Excel 2016. Deal with missing data and enhance your chart. Create interactive charts and at the end give your chart a professional look.

Course Objectives ›

At the end of the course, participants should be able to understand and perform the following:

  • Review of the Basics
  • Chart Series
  • Charts in Pivot Table
  • Sparklines
  • Pie Charts
  • Interactive Charts
  • Auto Shapes and Graphic in Charts
  • 2016 New Charts

Course Outline ›

DAY 1

Lesson 1: Review of the Basics

  • Basics of Charts
  • Recommended Charts
  • Chart Elements
  • Chart Styles
  • Chart Filters
  • Flexible data labels

Lesson 2: Chart Series

  • Combo charts
  • Quick Analysis charts
  • Plot Blank cells
  • Vary colors by Points
  • Series Enhancements
  • Series Lines
  • Drop Lines
  • High Low Lines

Lesson 3: Charts in Pivot Table

  • Creating a Pivot Table
  • Pivot Charts with Slicers
  • Pivot Charts with Time Line (only 2016 version)
  • Connecting Slicers and Time Line to Chart

Lesson 4: Sparkline's

  • Line Sparkline
  • Customizing Sparkline
  • Column Sparkline
  • Win/Loss Sparkline

Lesson 5: Pie Charts

  • 2 D Pie Chart
  • 3d Pie Chart
  • Formatting and Labeling the Pie Chart
  • Pie of Pie
  • Bar of Pie
  • Manage the distribution and display of data points

Lesson 6: Interactive Charts

  • Named Formulas
  • Offset Function
  • Charts with Scroll Bar
  • Adding the Scroll Bar
  • Plotting the Last n Data Points in a Chart Series
  • Add Spin Button

Lesson 7: Auto Shapes and Graphic in Charts

  • Using Graphics in a Chart Series

Lesson 8: 2016 New Charts

  • Waterfall
  • Histogram
  • Pareto
  • Treemap
  • Sunburst

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,