How to use the OFFSET in Excel (step by step)

Published: 06 September 2023
on channel: Professor Cubs
471
17

In this video we'll learn about the OFFSET function in excel. Admittedly, the OFFSET function is kind of the oddball of the Excel functions. It's a bit awkward, but it does serve a purpose. Just be aware the main goal of this video is to describe how the OFFSET function behaves.

We'll start by defining the OFFSET function, then walk through several examples to help you fully grasp how the OFFSET function works.

⌚ ** TIMESTAMPS **
0:00 Intro
0:18 An analogy of how the OFFSET function works
1:00 A super simple example
2:16 A more practical example of using the OFFSET
3:50 Nesting the OFFSET with other functions

💾 * FILE DOWNLOAD*
https://1drv.ms/x/s!AgnhzVKiTqWmgQ-qT...


📄 *RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...

Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...


☕ ** BUY ME A COFFEE? **
https://www.buymeacoffee.com/professo...


Watch video How to use the OFFSET in Excel (step by step) online without registration, duration hours minute second in high quality. This video was added by user Professor Cubs 06 September 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 471 once and liked it 17 people.