Mastering Charts & Graphs in Excel
Mastering Charts & Graphs in Excel MICROSOFT OFFICE PRO Microsoft Office Application Training Selangor, Malaysia, Kuala Lumpur (KL), Shah Alam Training, Workshop | Iconic Training Solutions Sdn Bhd

MASTERING CHARTS & GRAPHS IN EXCEL

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.

Prerequisites

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

Introduction

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.


*only support gif, jpeg, jpg, png, pdf
Switch To Desktop Version