Excel Charts - Online Training
4.3 (88 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,159 students enrolled

Excel Charts - Online Training

Charts - Thermometer Chart, 2-axis Chart, Exploded Pie Charts, Trendline, 80:20, Tips-n-tricks
4.3 (88 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,159 students enrolled
Created by Rishabh Pugalia
Last updated 4/2014
English
English [Auto-generated]
Current price: $15.99 Original price: $24.99 Discount: 36% off
19 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Chart Elements & Settings
  • Tricks and Shortcuts
  • Thermometer, 2-axis, Exploded Pie, 80:20 Stacked %, Trendline
Requirements
  • MS Excel 2007/2010
Description

CA. Rishabh Pugalia (Founder, Excel Next) presents a crisp Online Training Program on Excel Charts.

The program covers popular charts like Thermometer Charts, Exploded Pie Charts, 2-axis Charts, 80:20 Stacked Column Charts, Trendline in addition to intricate settings and shortcuts.

The accompanying eHandBook will help you recollect the steps to make these Special Charts and it also enumerates the key application areas. In other words, when to use which chart.

His training program on Advanced Excel can be accessed from this UDEMY link - Click Here.

Who this course is for:
  • Professionals and College Students
  • Trainers
  • Business Managers
  • Sales Professionals
Course content
Expand all 10 lectures 01:03:54
+ CHARTS SETTINGS
2 lectures 13:57

Please download the supplementary materials as displayed on the Window to the right. It contains Excel file for practice and PDF handbook for reference.

This Video explains the elements of the Charts - Chart Area, Plot Area, Axis Values, Gridlines, Legends etc. in addition to some of the important settings and shortcut keys.

_______________________________________________________________

Advanced Excel for Professionals - https://www.udemy.com/excelnext_excel/?couponCode=XL66

_______________________________________________________________

Preview 08:13

Axis Value Settings and formatting tricks

Preview 05:44
+ SPECIAL CHARTS
3 lectures 20:25

Applications:

Comparing 2 parameters of similar scale:

 2011 vs. 2012 sales

 Budget vs. Actual

 Me vs. My Competitor

Key Steps:

 Series Overlap

 Fill -> No Fill

 Border Color (Solid Line) & Border Styles (Width)

Thermometer Charts
06:07

Applications:

Comparing 2 parameters of different scale:

 GDP ($) vs. Growth or Inflation (%)

 Sales Amount ($) vs. Profit Margins (%)

Key Steps:

 Plot Series on

 Change Series Chart Type (Line with Markers)

Multi-axis chart
06:57

Applications:

Components of a Category (%):

 Headcount

 Source of Funds

 Sales Origination

Key Steps:

 Format Data Series – Rotation and Pie-explosion

Exploded Pie charts
07:21
+ TIPS AND TRICKS
2 lectures 12:35

Applications:

Trend:

 Profit

 Sales

 Clients’ / Subscribers’ acquisition (e.g. Telecom)

Key Steps:

 Chart Tools -> Layout -> Trend line -> Two-period Moving Average

 Format Axis -> Axis Labels -> High

 Format Labels -> Numbers (e.g. no. of decimals – 0, 1, 2)

 CALLOUTS Shapes

Trendline
06:41

Applications:

Relation (80:20 comparison):

 Sales and Profit

 Input and Output

Key Steps:

 Switch Row/Column

 Lines -> Series Lines

Stacked 100% Column (80:20) + PPT Integration
05:54
+ CONCLUDING SUMMARY
1 lecture 08:33

_______________________________________________________________

Advanced Excel for Professionals - https://www.udemy.com/excelnext_excel/?couponCode=XL66

_______________________________________________________________

Summary
08:33
+ BONUS EXCEL TRICK (Pivot Table)
1 lecture 06:47

This trick will allow you to replicate a report format for 100s of items in a category. E.g. Sales report customer-wise in individual worksheets.

Join our "Advanced Excel for Professionals" program for numerous tricks like this.

https://www.udemy.com/excelnext_excel/

Pivot Table Trick
06:47