Contents
Overview
– Range Names and SERIES
Relative and Absolute Cell
References
SERIES Formula and Range Names
Overview of OFFSET and COUNT
Functions
Create an Automatically Expanding
Chart
Review Questions -OFFSET and COUNT
Functions
Review Exercise -Self Expand 2
Series
Controlling Data in a Self-Expanding
Chart
Display the Last X Data Points in
the Worksheet
Review Exercise – Display 4 Data
Points
Selecting a Beginning and Ending
Point for a Series
Review Exercise -Beginning and
Ending Point
Review Questions -Scroll Bars and
Spinners