Use Landscape to see Search/Filter
Item Types:
Field of Study:
CPE Hours:
Course Details

Creating Dynamic and Interactive Charts - Excel 2010/2013/2016 (Course Id 1152)

QAS / Registry   Add to Cart 
Author : Patricia McCarthy, MBA
Status : Production
CPE Credits : 3.5
IRS Credits : 0
Price : $31.45
Passing Score : 70%
NASBA Technical: Yes
Primary Subject-Field Of Study:

Specialized Knowledge - Specialized Knowledge for Course Id 1152

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.

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.

Usage Rank : 0
Release : 2016
Version : 1.0
Prerequisites : An intermediate to advanced knowledge of Excel is assumed. You need to be familiar with functions and have an understanding of absolute and relative cell references. This course was written for Excel 2016;
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Additional Links :
Advance Preparation : None.
Delivery Method : Self-Study.
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 17-Dec-2016
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - NASBA Registry - 1152

Keywords : Specialized Knowledge and Applications, Creating, Dynamic, Interactive, Charts, Excel, 2010/2013/2016, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

By the end of the course participants will 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.
Course Contents :

Chapter 1 - Creating Dynamic and Interactive Charts

Overview Range Names and SERIES

Relative and Absolute Cell References

Range Names

SERIES Formula

SERIES Formula and Range Names

Review Questions- Overview


Overview of OFFSET and COUNT Functions

OFFSET Function

COUNT Functions

Create an Automatically Expanding Chart

Review Questions -OFFSET and COUNT Functions


Review Exercise -Self Expand

Review Exercise -Self Expand 2 Series

Controlling Data in a Self-Expanding Chart

Display the Last X Data Points in the Worksheet

Review Exercise Display 4 Data Points

Selecting a Beginning and Ending Point for a Series

Review Exercise -Beginning and Ending Point

Scroll Bars and Spinners

Create a Spinner

Scroll Bar

Linking Title Text to a Cell

Review Questions -Scroll Bars and Spinners


Chapter 2 - Links for Spreadsheets



Excel Course 1152 Home: https://www.cpethink.com/excel-cpa-courses
Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
Exam completed on .

Do you want to add the course again?