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. These are also useful in dashboards.
Table of Contents
This EBook covers:
Creating Range Names in a SERIES formula
Using OFFSET and COUNTA functions for charting purposes
Discusses other COUNT functions
Shows how to create Self-Expanding Charts
Shows how to displaying the last x number of data points
Selecting a beginning and ending point for a data series
Creating and using Spinners
Linking a Chart Title to a Cell
There are practice exercises and each exercise file has a corresponding answer file so that you can compare your results if you wish.
Delivery Method: QAS Self Study.
Level: Intermediate to Advanced
Version: This course was written for Excel 2016 however users of Excel 2007/Excel 2010 and Excel 2013 should experience no difficulty.
Prerequisites: You must be able to create and edit a simple chart. Familiarity with basic functions and absolute cell references is strongly recommended.
Advanced Preparation: None