Excel Charts - Online Training
4.8 (67 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,132 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Charts - Online Training to your Wishlist.

Add to Wishlist

Excel Charts - Online Training

Charts - Thermometer Chart, 2-axis Chart, Exploded Pie Charts, Trendline, 80:20, Tips-n-tricks
4.8 (67 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,132 students enrolled
Created by Rishabh Pugalia
Last updated 4/2014
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Chart Elements & Settings
  • Tricks and Shortcuts
  • Thermometer, 2-axis, Exploded Pie, 80:20 Stacked %, Trendline
View Curriculum
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 is the target audience?
  • Professionals and College Students
  • Trainers
  • Business Managers
  • Sales Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 10 Lectures Collapse All 10 Lectures 01:03:54
+
INTRODUCTION
1 Lecture 01:37
+
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
About the Instructor
Rishabh Pugalia
4.5 Average rating
427 Reviews
8,687 Students
27 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.