Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

OFFSET

Woman sitting at a desk making an Excel dynamic chart

How to Make an Excel Dynamic Chart & Keep Updates Consistent

By Excel University | September 20, 2022 |

For the purposes of this discussion, an Excel dynamic chart is a chart that automatically updates itself whenever new data rows are added. The opposite is a static chart, which won’t incorporate any new data rows added to the existing range. To be clear, when Excel creates a chart based on a range of cells,…

Read More

Moving, Rolling, and Trailing Averages

By Jeff Lenning | March 19, 2015 |

The terms Moving, Rolling, and Trailing are commonly used to describe the same calculation idea…that we want to operate on the previous say 3, 6, or 12 data rows. In this post, we’ll allow the user to define the number of rows to include and use the OFFSET function to dynamically define the desired range. Objective…

Read More