Creating Dynamic and Interactive Charts

SKU: CPE-07-059
Credit Hours: 3
Level: Basic
Field of Study: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Patricia McCarthy, MBA

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.