Excel 2010 Charting Tips

Master Creating and Formatting Charts & Graphs in Excel 2010
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

Become a chart ninja in Excel 2007 or Excel 2010. This course starts with the basics: How to create & customize a chart in Excel 2010. It will teach you how to get Excel to remember you customizations for next time.

The course then moves on to chart tricks - things that you won't find in the interface, but that come in handy for creating interesting effects.

Learn about the built-in chart types that few have mastered: Radar, Stock, and Scatter charts.

See Data visualization tools such as Sparklines and SmartArt Business Diagrams.

Finally, learn chart ninja tricks to create Waterfalls, Cluster Stack, and Arbitrary Gridlines.

Course Objectives

  • Create a perfect chart in one keystroke
  • Understand Excel 2010 Charting Basics
  • Learn Chart Tricks in Excel
  • Learn when to use Stock, Radar, and Scatter charts
  • Learn other visualizations such as Sparklines and SmartArt diagrams
  • Advanced topics such as Waterfall, Cluster Stack, and Conditional Formatting in a Chart

Who Is This For?

  • Anyone using Excel 2010 or Excel 2007
  • Market Analysts
  • Sales Administration
  • Scientists
  • Financial Analysts

Course Outline

Chapter 1: Creating a Chart in Excel 2010

  • Lesson 1
    Intro
    00:40
  • Lesson 2
    Charting Basics
    13:01

Chapter 2: Chart Tricks

  • Lesson 3
    Chart Tricks
    11:42

Chapter 3: Visualizations Without Charts

  • Lesson 4
    Beyond Charts
    08:47

Chapter 4: Creating Unusual Charts

  • Lesson 5
    Creating Unusual Charts
    11:42
  • Lesson 6
    Waterfall Charts
    03:49
  • Lesson 7
    Cluster Stack Charts
    02:55
  • Lesson 8
    Conditional Formatting in a…
    01:50
  • Lesson 9
    Arbitrary Gridline in a Chart
    02:22
  • Lesson 10
    WrapUp
    01:12

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)