Creating Interactive & Dynamic Charts

Price: $42.50

CPE Credits: 4.5

Category: ,

Course Number: CXDCHTMC

Description:
This course walks your through how to set up Excel charts so that they update automatically as data in entered into the worksheet. So, set your charts up and as you enter data over time, your charts will dynamically update and save you time and potential errors.  These are also useful in dashboards.
Table of Contents

This EBook covers:
 Creating Range Names in a SERIES formula
 Using OFFSET and COUNTA functions for charting purposes
 Discusses other COUNT functions
 Shows how to create Self-Expanding Charts
 Shows how to 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
There are practice exercises and each exercise file has a corresponding answer file so that you can compare your results if you wish.

Delivery Method: QAS Self Study.

Level: Intermediate to Advanced

Version:   This course was written for Excel 2016 however users of Excel 2007/Excel 2010 and Excel 2013 should experience no difficulty.

Prerequisites: You must be able to create and edit a simple chart. Familiarity with basic functions and absolute cell references is strongly recommended.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: March 2009
Updated: August 2016

Format: PDF and Exercise Files
PDF: 48 Pages

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
1. Differentiate between different types of cell references and recognize to apply them.
2. Recognize the steps needed to create the components of range names and named formulas.
3. Differentiate between the different COUNT functions
4. Recognize how to use the SERIES, OFFSET and COUNTA functions to create dynamic charts that update automatically
5. Recognize the concept of input cells and how to apply them.
6. Recognize the steps needed to link a chart title to a cell so that a chart title updates automatically
7. Recognize the steps needed to create a spinner or scroll box.

 

Description:
This course walks your through how to set up Excel charts so that they update automatically as data in entered into the worksheet. So, set your charts up and as you enter data over time, your charts will dynamically update and save you time and potential errors.  These are also useful in dashboards.
Table of Contents

This EBook covers:
 Creating Range Names in a SERIES formula
 Using OFFSET and COUNTA functions for charting purposes
 Discusses other COUNT functions
 Shows how to create Self-Expanding Charts
 Shows how to 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
There are practice exercises and each exercise file has a corresponding answer file so that you can compare your results if you wish.

Delivery Method: QAS Self Study.

Level: Intermediate to Advanced

Version:   This course was written for Excel 2016 however users of Excel 2007/Excel 2010 and Excel 2013 should experience no difficulty.

Prerequisites: You must be able to create and edit a simple chart. Familiarity with basic functions and absolute cell references is strongly recommended.

Advanced Preparation: None

Author: Patricia McCarthy

Publication: March 2009
Updated: August 2016

Format: PDF and Exercise Files
PDF: 48 Pages

Passing Grade: 70%

Exam Policies: Exam may be retaken. Course must be completed within one year of purchase.

CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:
1. Differentiate between different types of cell references and recognize to apply them.
2. Recognize the steps needed to create the components of range names and named formulas.
3. Differentiate between the different COUNT functions
4. Recognize how to use the SERIES, OFFSET and COUNTA functions to create dynamic charts that update automatically
5. Recognize the concept of input cells and how to apply them.
6. Recognize the steps needed to link a chart title to a cell so that a chart title updates automatically
7. Recognize the steps needed to create a spinner or scroll box.

 

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet

  • You guys do a great job!  As a person in industry it can be really expensive to stay current and you have great options that are actually useful as well as cost effective!

    - Sue

  • “..may I say it is rarer that I ever have gotten a personal reply from a CPE Site! Glad I have found your site.”

    - Tom