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.

  • 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.

Review Questions and Final Exam are completed under section "Review and Test".

Learning Objectives
  • Identify 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.
  • Identify 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.
Last updated/reviewed: March 6, 2024
5 Reviews (16 ratings)

Reviews

5
Anonymous Author
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 eBook walks you through the process step by step and then includes practice exercise for each topic as well as answer files.
4
Anonymous Author
There is always a way to improve Excel use to make it more efficient. I appreciate that she has added the OFFSET formula in Excel.
5
Anonymous Author
Simple language and good examples to guide the practice. I liked this course, learned several things!
5
Member's Profile
Great module. I would recommend any one that Ms. McCarthy authors.
5
Member's Profile
I liked this class. Easy to follow along and informative.
Prerequisites
Course Complexity: Intermediate

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.

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
  Course Overview CPE
Course Syllabus
SUPPORTING MATERIAL
  Create Dynamic and Interactive ChartsPDF
REVIEW AND TEST
  REVIEW QUESTIONS quiz
 FINAL EXAMexam