YouTube: Innovative CPE Channel Listen to Our Customers, Preview Our Instructors, Stay On Top of Breaking News
Connect with Western CPE on Facebook Western CPE on Twitter Western CPE on LinkedIn
New in Self-Study
  • Accounting Update—2012
    Join accounting expert Patricia Williams for a clear explanation of accounting pronouncements.
Self-Study Editor's Pick
 
  Innovative Education

Phone:
(800) 822-4194
(406) 556-0115

Fax:
(206) 774-1285

E-mail: wcpe@westerncpe.com

243 Pegasus Drive
Bozeman, MT 59718

Office hours:
Monday - Friday
7 A.M. - 6 P.M. MST

Self-Study — Course Detail

links to other topics
Accounting & Auditing Computer Applications & Technology Corporate Finance
Management & HR Ethics Government & Nonprofit
Personal Development Professional Development Taxation & Financial Planning

Creating Interactive Charts with Excel 2007
Patricia McCarthy
Copyright© 2011

Course: 2114524   Version 1103

NASBA Category:     Spec Knldg & Apps     CPE Credits 3
Level: Intermediate  (37 pages)
Prerequisite: Intermediate knowledge of Excel.
Advance Preparation: Excel 2007 required.



Course Description
Creating Interactive Charts with Excel 2007 gives you the tools you need to improve productivity and efficiency in charting by learning how to create dynamic or interactive charts that update automatically. Step-by-step instructions and practice exercises help you understand how to apply the given tip or tool to your own work. This fundamental course covers everything you need to know about creating charts in Excel 2007, including:
  • Creating Range Names in a SERIES formula
  • Using OFFSET and COUNT functions for charting purposes
  • Self-Expanding Charts
  • Displaying the last x number of data points
  • Selecting a beginning and ending point for a data series
  • Creating and using Spinners
  • Linking a Chart Title to a Cell
*To access the practice files for this course, go to westerncpe.com, log in to your account, and click on “Order History.” Practice files are included under Downloadable Materials.


Table of Contents

Learning Objectives
Upon successful completion of this course, participants will be able to:
  • Gain an understanding as to what the SERIES formula is and how to apply range names to it.
  • Gain a basic understanding of the OFFSET function as well as the COUNTA function.
  • Edit a chart so that it will automatically update as new data is entered into the worksheet.
  • Learn how to have an Excel chart only display the last specified number of data points. For example You may have 24 months of sales data but only want to display the last 12 months.
  • Set up the chart so that only the last 4 data points display.
  • Create a chart where the chart’s beginning and ending point is controlled by the user.
More Learning Objectives




: : Privacy Policy : : Refund Policy : : Shipping Policy : :

Western CPE | Offering Continuing Professional Education (CPE) and Professional Development for Accountants and Financial Planning Professionals | Home

Photo of Beartooth Mountains courtesy of www.magicpixel.biz