This course walks you through setting up Excel charts so they update automatically as data in entered into the worksheet. In addition, to discussing self-expanding charts, it also covers how to specify the number of data points to display in a chart. For example, you may only want the last rolling six months of data to display, in the chart, as you add new data each month. Linking a chart title to a cell and creating a spinner control is also discussed. This course walks you through the process step by step and then includes practice exercise for each topic as well as answer files.
Course Publication Date:
June 24, 2020
This course is available with
NO ADDITIONAL FEE if you have an active
self study membership or
all access membership or can be purchased for
$15.00!
| Author: | Mill Creek Publishing |
| Course No: | COMP-EXCELCHART-2130 |
| Recommended CPE: | 1.50 |
| Delivery Method: | QAS Self Study |
| Level of Knowledge: | Overview |
| Prerequisites: | An 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 2019 and Microsoft Office 365 users; however, users of earlier versions should have absolutely no difficulty. |
| 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 the SERIES, OFFSET and COUNTA functions work 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.