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


Mastering Microsoft Excel Charting Secrets (IMEB202)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, March 20, 2014
Event Description

A chart is worth a thousand words -- or lines of data! Learn the secrets to creating fabulous Excel charts in just one hour!

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

Join Excel guru Dennis Taylor for this audio and video learning session where you′ll learn productive techniques for turning data into attention-getting results.


  • How to select source data for a chart from non-adjacent ranges or from multiple sheets
  • Learn the fastest ways to create a chart – one keystroke shortcut to create a chart on the same sheet as the source data, another keystroke shortcut to create a chart on a separate sheet.
  • Learn which chart types are best for the data being depicted and how to change types quickly
  • Learn how to insert trendlines and adjust gridlines and axes
  • Learn how to annotate charts with data labels, arrows, and boxes
  • Set up dynamic charts (those that grow daily, weekly, or monthly) with Excel′s Table feature
  • Create in-cell charts with the new (in Excel 2010) feature Sparklines

And much more...

  • Create a chart instantly with a single keystroke shortcut or create a chart on a worksheet with just 2 mouse clicks.
  • Copy charts and adjust the chart type to view data with "different eyes" for a whole new outlook.
  • Adjust worksheet charts to align with your cells, or toggle the location of a chart from the same worksheet to another.
  • Convert jagged chart lines into smooth continuous-looking lines and insert ClipArt to replace columns or bars for more eye-opening results.
  • Mix column and line charts to accentuate a chart series or to accommodate wide-ranging data.
  • Select source data for a chart from adjacent or non-adjacent ranges — chart only the data you need.
  • Adjust scaling for all chart types and rotate 3-D charts so it fits where you need it.
  • Annotate charts with text, lines and customized arrows and make the chart tell the story.

You′ll learn the best and quickest ways to prepare data for charts and create and modify them with a minimum of 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 Microsoft Excel Charting Secrets
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status