Excel Charts - Online Training

Charts - Thermometer Chart, 2-axis Chart, Exploded Pie Charts, Trendline, 80:20, Tips-n-tricks
4.2 (58 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,126 students enrolled
$25
Take This Course
  • Lectures 10
  • Contents Video: 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • MS Excel 2007/2010

What am I going to get from this course?

  • Chart Elements & Settings
  • Tricks and Shortcuts
  • Thermometer, 2-axis, Exploded Pie, 80:20 Stacked %, Trendline

What is the target audience?

  • Professionals and College Students
  • Trainers
  • Business Managers
  • Sales Professionals

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: INTRODUCTION
Introduction
Preview
01:37
Section 2: CHARTS SETTINGS
08:13

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

_______________________________________________________________

05:44

Axis Value Settings and formatting tricks

Section 3: SPECIAL CHARTS
06:07

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)

06:57

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)

07:21

Applications:

Components of a Category (%):

 Headcount

 Source of Funds

 Sales Origination

Key Steps:

 Format Data Series – Rotation and Pie-explosion

Section 4: TIPS AND TRICKS
06:41

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

05:54

Applications:

Relation (80:20 comparison):

 Sales and Profit

 Input and Output

Key Steps:

 Switch Row/Column

 Lines -> Series Lines

Section 5: CONCLUDING SUMMARY
08:33

_______________________________________________________________

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

_______________________________________________________________

Section 6: BONUS EXCEL TRICK (Pivot Table)
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/

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rishabh Pugalia, 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.

Ready to start learning?
Take This Course