Excel OFFSET function basics + Dynamic Ranges | 5 Examples
In this video we show the excel OFFSET function basics and 5 practical examples.
Download Example Workbook here:
https://bit.ly/3kBlRNv
How to use INDEX & MATCH:
• How to use INDEX MATCH in Excel for l...
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 OFFSET function basics 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.
Secondly, we show how you can create dynamically expanding and shrinking range using OFFSET.
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.
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.
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!
DON'T FORGET TO LIKE, SHARE AND SUBSCRIBE TO THE CHANNEL FOR MORE VIDEOS!
Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9
Subscribe to my Youtube Channel:
https://bit.ly/2NdO6UP
Visit my website at www.ExcelBonanza.com
#offset #dynamicrange #exceltricks
