Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps 

Grab the file I used in the video from here 👉 pages.xelplus.com/offset-file

How on earth this video has 5 dislikes? Perfectly executed and explained, also you can connect better with the tutor by seeing her rather than just seeing a spreadsheet

Not sure if you are monitoring comments as this video is old but I have to say, THANK YOU! I paid for a course by CPA and it was aweful. I have to keep coming to RU-vid to search for videos on what they are teaching in the pre-recorded course to understand what is happening and this video saved me. Very much appreciate it! If you have one on how to turn offset into charts please let me know!

LEILA, You're absolutely amazing. Your way of explanation is making my life easier. I've decided to go through all of your videos from oldest to newest

I had the same problem on my job few days ago, like you explained in this video. Thank you for posting this.

I have watched numerous videos and I am no way an expert. I appreciate the detail and step by step process as well as explanations as to why you do something. This kind of training was never around a few years ago so thank you.

Thank you very much, I struggled for offset functions for years, you helped me to get out the fog. Your excel tutorials are simply amazing, inspire us to dig deep and find fun with it. Thank you very much.

Amazing lecture, amazing explanation, amazing simplification, amazing language. I can't help myself but to fully understand every word you said. Thanks a lot lady!

1 OF THE BEST TEACHERS ON RU-vid ^^

I think the simpler the way you speak the better.This is just my opinion you are a great trainer

BEST EXCEL VIDEOS EVER! AS A SENIOR ACCOUNTING TRYING HARD TO IMPRESS THE CFO THESE ARE A GREAT HELP!

Saved my day once again. So many videos explaining OFFSET but you did it the best and you seem to be the only one that did it with a ROW example (horizontal data) that cleared up where I was making a mistake. Thanks again and keep up the great work.

I have spent the whole day looking for rich information on this subject. So far this is the best I have found. Thank you

What a pleasant teacher! Your demeanor is such that you make it fun to learn from a pro. I'm so glad you took the time to make these videos. They helped me tremendously with my new job. Thank you!!

Thanks to Leila for a simple but powerful lession.

God sent you from above, Leila. You and your family will have a Beautiful Christmas!

I didn't know your work, but now you're one of my favorite teachers. Thank you, Ms. Gharani! You do a great job! Greetings from Brazil!

Thanks for this video, I've been trying to learn more about OFFSET and this was a really clear way of breaking it down, love the videos! Keep up the great work!

I liked your way of explaining five years ago . Clear and helpfulI , that's why i loved your Channel Your information was very useful to me . Thank you for all of your hard work

Omg. I love you for this. I've been stuck at my new job for an hour trying to figure out how to manipulate horizontal data. Thank you

Saving my life, one video at a time! Thank you!!!

Really appreciate your teaching..... very clear and easy to follow.

Great explanation! Your usage of home, street and town made the explanation all the more intuitive and easy to remember. Brilliant metaphors indeed.

Excellent and deep hands-on knowledge which helps me greatly to solve a current business need. Thank you.

What an easy way to explain! Simplicity comes when the knowledge is at its best.

Explaining it so clearly shows how knowledgeable you are on Excel.. A smart and beautiful lady..

I always search the video but add Leila Gharani after, you explain so well.

You r training is the best I have found on the internet for Excel in simple explanations

Thank you! After watching i feel accomplished today that i learned something new. This gives me the starting point i needed to work on my sports data project!

EXTREMELY helpful thank you!!

you are outstanding in everything I'm glad to catch this explanation

This is the best explanation for this formula ever.

Finally I understood offset ...........lots of interest to learn with passion.

You deserve a special price, you're so helpful, Allah bless you!

I like the way you explain the toughest task so simply. I teach my students everyday something new after very little practice on it.

The power which I get after watching Leila's Excel tutorials :)

I been to loads of sites on understanding the offset function. This is the best tutorial✌

No Way Out To Make Your Lesson Not Understanding........Again Love You And Your Style Of Teaching Leila Gharani

Commendable teaching. Combination of skill,devotion&desire to impart best.Good show.

Thank you very much Leila, you gave me an idea to use SumIf function in conjunction with the Offset to calculate different times in a variable range.

Thank you medam.. im so confusing in off set function... But now im relaxing when im seen this video... Its really help on my work

How simply have you taught us. Thankyou so much

THIS IS BY FAR THE EASIEST TO UNDERSTAND

No word to explain your perfection !!! Highly appreciated...keep it up.

I just saw your one video, and very effectively you convinced me by your teaching and knowledge to subscribe your channel. Lots of Respect.

Excellent! Clearly explained and uses my favorite thing - visual aids! The ONLY way information gets into my head is to SEE it work; written instructions are of little to no use to me, LOL! Thank you!

I finally found an explanation that was easy to follow, THANK YOU.

you are the best here. Congratulations. Simple and direct.

i love ur teaching style

Seldom used powerful "Offset" function explained very well. It has certainly helped me with one of my simulation EXCEL.

This worked, I used it with the Sum function, thank you!

Thank you so much Ms. Gharani for this beneficial video. Greetings from Turkey...

That’s the clearest explanation I’ve yet seen. 👍🏻

Thank you. Your videos are great! My work in University Timetabling has been made easier by many of your videos. Dr. Joshua Itumo- Kenyatta University- Kenya

You are my favourite excel teacher

Fantastic video, this saved my assignment! I've been trying to find a solution to my problem for the last three days, thank you!

Dear Leila, Thank you, perfectly explained. I appreciate your lesson. I am also your loyal subscriber.

Thank you! I've been looking for a way to make excel choose the next cell with a value, in a column, for a while now! This was great

your explanation is very clear, thank you.

My beloved teacher! Your tutorials are very helpful.

Great explnation in the correct speed Thanks

Excellent explanation with example

I finally understand what the OFFSET can do. Thanks!

Your make every formula sound so easy.. absolutely amazing! your voice is very calm and the pace is perfect!

Thank you for showing things I wasn't aware off and how to combine.

So much easy way to explain. Now I have clear everything. Keep it up.....

you inspired me to become an excel expert

perfect explanation! very clear and easy to understand. thank you so much🌻

Thanks for the approach/explanation at 7:45, which I actually learned first.

Excellent method of explanation.. Thanks

Thank you Leila, excelent video for learning Excel.

You are amazing the way you explain everything! Very straightforward and easy to comprehend. For this reason, I already started one of your courses on Udemy. What I was looking for and I did not found is a tutorial about conversion of multiple currencies to home currency, but except the vlookup multiplication formula, more specific, a formula that does also division for currencies like USDJPY for example or a combined formula for multiplication and division in the same time (to be included in the same data).

Excellent tutorial along as are all your others. Thanks very much.

You are awesome person, I appreciate the lessons and I learn too much things from you.

Thank you so much Leila, you gave us fundamental and dynamic uses of Offset function.

Complex work became simple one. Thanks

Time and time again even at the advent of Python one has to go back to Excel from time to time. Thanks, it was a good refresher actually good for everyone.

You explain this so much better than my professor! Thank you so much for the help!

Thank you. I have been struggling to fully understand the offset function. Your explanation has made the light bulb light up for me.

God Bless you Leila

Thank you for all the training in excel, you are very good at what you do and are very knowledgable. Subscribed and liked!

Your teaching is wonderful !!!!

You got mad skills Leila.

Very well explained. Thank you very much.

I like the way you explain it and anyone can easily understand... Thanks for the Videos

Thank you so much.God bless you

The most useful channel in youtube

You are an amazing tutor!! Taking your course on Udemy.

Hi. I have data starting from column B1 till B9 (in column B). Data is 1,2,3,4,5,6,7,8,9 (B1=1, B2=2, B3=3 etc.) I want to put this data with a suitable formula in Column A starting from cell A1. Should look as below: A1 = 1 A3 = 2 A6 = 3 A9 = 4 so going on.

Awesome!!!!!! Really helpful, clearly explained 🎉

Thanks a lot. Very useful for learning.

Thank you Leila.

Thank you very much Finally, i can say that i understand this OFFSET function

the best tutorial ever

I have watched the video. Your teaching style is just too good. In fact I am a trainer for MS-Excel and Tableau as well. But I enjoy the way of teaching and the practical applications you give. One suggestion would be to use the table format to make the range in the counta function dynamic. Thanks for your wonderful videos.

Perfect for what I needed. Many thanks and well explained/demonstrated.

I want to give 100 thumbs up but can give only 1 here. The way you explain is awesome. Thanks a lot.

Nicely explained, thank you🙏🙏

This Video made me clear in OFFSET function.

Wow! Your channel must be one of a kind in teaching ms excel! Thank you so much!