Excel Tips & Tricks: Demystifying the OFFSET Function

In this video, I'll guide you through using the OFFSET function in Microsoft Excel.

First, we'll cover the basics of the OFFSET function and solidify our understanding of its syntax.

Next, we'll explore various use cases to further build our knowledge and apply what we've learned.

By the end of this tutorial, you'll be equipped to utilize the OFFSET function effectively in your own Excel projects

Time Stamps:
00:00 Offset Basics
06:10 Calculate Year to Date sales dynamically
10:14 Calculate last 3 month sales dynamically

Link to the working files:
https://drive.google.com/drive/folders/16YQ5_iBci9041fxmou2cfWgJJ4C5fHXk?usp=sharing

Other Interesting Videos:

Power Query:
https://youtu.be/EyKiPn02GGk
https://youtu.be/SDBZkjxC4vY

Excel:
https://youtu.be/8uHRgnEHlqQ

Тэги:

##exceltips ##exceldashboards ##microsoftexcel

Скачать видео