Just to make it simple for you to understand I have divided the Offset Function in 2 parts

 

Offset Basic

 

DOWNLOAD THE EXCEL FILE USED IN THE VIDEO

 

And Offset Advanced

But there is no such thing as basic or advanced, it was just to make it simple for you guys. Also read a detailed article on Offset Function

 

DOWNLOAD THE EXCEL FILE USED IN THE VIDEO

 

Related Functions

  1. Index Function Video
  2. Index Function Blog Post – Very Detailed
  3. Match Function

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI