Creating Dynamic and Interactive Charts
SKU: 02-059-01-CPE
Credit Hours: 3
Level: Overview
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA
Course 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.
At the end of this course, students will be able to:
- 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.