Dynamic & Interactive Charts - Excel 2007/2010/2013
This course walks you 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 course was written for Excel 2016; however, users of Excel 2007, 2010 and 2013 should have no difficulty working through this course.

Course Publication Date: February 06, 2017

This course is available with NO ADDITIONAL FEE if you have an active self study membership or can be purchased for $15.00!

Author:Mill Creek Publishing
Recommended CPE:1.50
Delivery Method:QAS Self Study
Level of Knowledge:Overview
Prerequisites:Intermediate to advanced knowledge of Excel
Advanced Preparation:None
Recommended Field of Study:Computer Software and Applications
Add To Your Cart

Ready to take a course?

  • Includes all self study courses
  • Earn as many CPE credit as you need
  • 100% Guaranteed
Buy Self Study Membership

Learning Objectives
  • Differentiate between different types of cell references and recognize to apply them.
  • Recognize the steps needed to create the components of range names and named formulas.
  • Differentiate between the different COUNT functions.
  • Recognize how to use the SERIES, OFFSET and COUNTA functions to create dynamic charts that update automatically.
  • Recognize the concept of input cells and how to apply them.
  • Recognize the steps needed to link a chart title to a cell so that a chart title updates automatically.
  • Recognize the steps needed to create a spinner or scroll box.

CPE Depot Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Sponsor Number: 109423


Search Courses

Group Plan

Group plans are convenient and cost effective!

Authors Wanted

We are looking for authors!