My Shopping Cart
There are no items in your shopping cart.

Mastering Excel Charts and Graphs (IME740G)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Tue, July 29, 2014
Event Description
See the sneak peek before you buy!

Master the Secrets of Creating Excellent Excel Charts in Just 60 Minutes

When you are explaining data, charts say so much more than the plain text, but MS-Excel′s default charts are quite dull and lifeless. You can add the spice, functionality and pizzazz to any of the graph or diagram so your numerical data tells the much-desired story — when you start to learn the secrets to creating some great Excel charts!

Join Excel guru Dennis Taylor in this audio and video learning session where you will be able to learn the productive techniques for turning any data into attention-grabbing results.

Session highlights

  • The art to select source data for a chart from the non-adjacent ranges or from multiple sheets
  • Learning the speediest ways to create a chart – with one keystroke shortcut to create a chart on the same sheet as the source data, and another keystroke shortcut to create a chart on the separate sheet.
  • Learning which of the chart types are the best for the data being depicted and how to change such types quickly
  • Learning to insert trendlines and adjust gridlines as well as axes
  • Learning how to annotate those charts with the data labels, arrows, and boxes
  • Set up the dynamic charts (those that grow daily, weekly, or monthly) with MS-Excel′s Table feature
  • Create the in-cell charts with some new (in Excel 2010) feature Sparklines
  • Creation of a chart instantly with the single keystroke shortcut or create a chart on the worksheet with just 2 mouse clicks.
  • Copy charts and then adjust the chart type to view data with the "different eyes" for a whole new outlook.
  • Adjust the worksheet so as to align with your cells, or toggle such location of a chart from the very same worksheet to another.
  • Convert the jagged chart lines into the smooth continuous-looking lines and insert ClipArt so as to replace columns or bars for more eye-opening results.
  • Mixing the column and line charts in order to accentuate a chart series or to accommodate wide-ranging data.
  • Selecting the source data for a chart from adjacent or non-adjacent ranges — chart only the data you need.
  • Adjusting the scaling for all chart types and rotate 3-D charts so as it fits where you need it.
  • Annotate all the charts with text, lines and then customized arrows and make the chart tell the story

You′ll learn the best and the quickest ways so as  to prepare data for charts and create and modify them with little effort.

About Our Speaker(s)

Dennis Taylor, Microsoft Excel Training ExpertDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Mastering Excel Charts and Graphs
    Presenter(s): Dennis Taylor Protection Status