Mastering Charts & Graphs in Excel

Previous 4 / 8 Next

Mastering Charts & Graphs in Excel MICROSOFT OFFICE PRO Microsoft Office Application Training


Course Duration: 2 Days

Who Should Attend?

Those who wish to Excel their knowledge in creating charts in a different type. And to explore this course in-depth.


  • Knowledge in Windows
  • Microsoft Excel
  • Microsoft Word
  • Microsoft PowerPoint


Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully and quickly ... so you drive your message home, and get the decisions and actions you're looking for!

Course Objectives

Upon completion of this program, participants should be able to:
  • Create stunning data visualizations instantly with Excel 2013's new Recommended Charts
  • Use charts to instantly reveal trends, differences, and relationships
  • Quickly generate combo charts that once required complex, frustrating procedures
  • Create Waterfall & Thermometer Charts

Course Syllabus

Module 1: Creating Charts in Microsoft Excel

  • Creating 3-D Charts
  • Creating Staked Column Chart
  • Formatting Chart Plot Area & Chart Area
  • Save as a Template
  • Set as a Default Chart

Module 2: Charts that Show Differences

  • Showing Positive and Negative Chart
  • Creating Waterfall Chart

Module 3: Creating Chart that Show Relationships

  • Creating a Scatter Chart
  • Showing Scatter Chart Labels in Excel
  • Joining the Points in a Scatter Chart with Lines
  • Adding a Third Dimensions with a Bubble Chart
  • Using Paired Bar to Show Relationship

Module 4: Advanced Chart Techniques

  • Mixing Two Chart Types on a Single Chart
  • Creating a Thermometer Chart
  • Creating a Benchmark Chart




Please leave your enquiry here, we will reply as soon as possible.
Company Name  
Product Interested  
Contact No.*  
*only support gif, jpeg, jpg, png, pdf

Switch to Mobile Version
available in
Subscribe Newsletter