OFFSET function Basics + Dynamic Ranges ( 6 Examples)

OFFSET function Basics + Dynamic Ranges ( 6 Examples)

You can download the workbook here to follow along with the Video!

Creating Dynamic ranges is a skill that can completely transform the way you use Microsoft Excel (It happened to me!)

In this video tutorial, we illustrate the basics of the OFFSET function and we show how you can create dynamic ranges with 5 examples:

  1.  First of all, We show the basics of the OFFSET function and how to select a cell’s value using the OFFSET function.
  2.  Secondly, we show how you can create dynamically expanding and shrinking range using OFFSET.
  3. In the third example, we show you how you can dynamically select the values of the last 3 months of Sales in a list of months and sales values.
  4. In the fourth example, we show you how you can display the sum of Sales starting from a certain month that you select from a drop-down menu.
  5. Lastly, we show how you can create a dynamically expanding and shrinking drop-down menu with the help of a mini Pivot table!

This tutorial is about 30 mins, and it’s packed full of useful information!

I hope you like the Tutorial.

Please watch the video and let me know if you have any comments or feedback in the comments section below.

Please share

If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!

Ace your Excel Career by learning how to create Excel Dashboards!

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Abdelrahman Abdou
Latest posts by Abdelrahman Abdou (see all)
It's only fair to share...Share on Facebook
Facebook
0Pin on Pinterest
Pinterest
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin