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 |
Course No: | SKA-EXCELCHARTS-2136 |
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
|
|
|
|
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.