Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Charting Techniques with MS Excel

( Duration: 2 Days )

In Charting Techniques with MS Excel training course, you would be equipped with a practical understanding of advanced data plotting and charting techniques. The course examines the various formatting and trending methods, and explores ways to maximize data display with charts. You will learn to create formula-based charts, establish target values, and display meaningful charts.

This Charting Techniques with MS Excel workshop is designed for experienced Microsoft Excel users who have a vested interest and need to plot meaningful charts at the industrial, corporate, and project level site.

COURSE AGENDA

1

Getting Started with Charts

2

Managing Data Source

3

Working with Chart layout and Style

  • Select Chart layout& Apply Chart Style
  • Format Chart labels - Chart Title, Axis Title, Legend, Data Labels, Data Table
  • Format Horizontal & Vertical Grindlines
  • Manage Axis Option
4

Combination of Charts

  • Changing Chart Type
  • Adding a Secondary Axis
  • Saving Chart Templates
  • Creating Sparklines
5

Working with Analysis tools Working

  • Working with Trendlines
  • Adding Predefined lines & bars
6

Go beyond the Basic Charts

  • Pictographs
  • Pie of Pie
  • Histogram
  • Cumulative Frequency Graph

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X