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
Thank you for this nice comment Tomasz. I don't expect everyone to like my videos..... I appreciate the ones who find them useful and can benefit from the content. As long as there are more likes than dislikes, I am happy :) Thank you for your support.
In the first sentence she called offset a "formula". It's not a formula, it's a function. I didn't give it a dislike, but I'm not watching it after that.
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 RUclips 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!
HI Liela, did you by any chance got mixed up with count and counta, count only counts numbers right but you said other way around. Thanks for so great content. Namaste
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
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!
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
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.
Struggling to get an dynamic offset formula right. Thank you for this well explained and easy going tutorial. I have found what I was looking for. My favorite Excel tutorial channel
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.
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!
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!!
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
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.
I'm doing your advanced class in Udemy right now and am ready to do all of them! Pretty awesome material. If you have a book or any other instructional stuff send it in my direction!
Great Scott. Do let me know if you run into any questions on the Q&A board on Udemy. Will be glad to help. I have a detailed ebook on the course you're taking. You can download it from here: www.xelplus.com/free-ebook/
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!
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
Thank you for this nice comment Tomasz. I don't expect everyone to like my videos..... I appreciate the ones who find them useful and can benefit from the content. As long as there are more likes than dislikes, I am happy :) Thank you for your support.
In the first sentence she called offset a "formula". It's not a formula, it's a function. I didn't give it a dislike, but I'm not watching it after that.
@Will Moffett Your loss.
I appreciate your videos. Thank you for your time.
@@LeilaGharani 0l9!8
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 RUclips 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!
1 OF THE BEST TEACHERS ON RUclips ^^
I have spent the whole day looking for rich information on this subject. So far this is the best I have found. Thank you
Awesome, thank you!
Saving my life, one video at a time! Thank you!!!
kheyli khub bud!!! Cheghad ba hoseleo tamiz!!! Damet garm
HI Liela, did you by any chance got mixed up with count and counta, count only counts numbers right but you said other way around. Thanks for so great content. Namaste
BEST EXCEL VIDEOS EVER! AS A SENIOR ACCOUNTING TRYING HARD TO IMPRESS THE CFO THESE ARE A GREAT HELP!
Finally I understood offset ...........lots of interest to learn with passion.
Glad to help. Keep learning :)
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
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
EXTREMELY helpful 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.
Thank you for the kind feedback!
I think the simpler the way you speak the better.This is just my opinion you are a great trainer
Really appreciate your teaching..... very clear and easy to follow.
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!
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!
Thank you! 😃
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
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.
Thanks for the approach/explanation at 7:45, which I actually learned first.
You're welcome Danny.
No word to explain your perfection !!! Highly appreciated...keep it up.
Thank you so much 😀
Struggling to get an dynamic offset formula right.
Thank you for this well explained and easy going tutorial. I have found what I was looking for.
My favorite Excel tutorial channel
Glad it was helpful!
You r training is the best I have found on the internet for Excel in simple explanations
Thank you! That's very kind! I'm glad you like the tutorials.
Excellent and deep hands-on knowledge which helps me greatly to solve a current business need. Thank you.
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.
My pleasure David. Glad it was helpful.
Thanks to Leila for a simple but powerful lession.
What an easy way to explain! Simplicity comes when the knowledge is at its best.
Many thanks for the kind words!
This worked, I used it with the Sum function, thank you!
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
It's my pleasure.
Your teaching is wonderful !!!!
Thank you! Glad you like it.
you are the best here. Congratulations. Simple and direct.
Thank you Leonardo.
Thank you so much Ms. Gharani for this beneficial video. Greetings from Turkey...
My pleasure Ali.
Dear Leila, Thank you, perfectly explained. I appreciate your lesson. I am also your loyal subscriber.
I just saw your one video, and very effectively you convinced me by your teaching and knowledge to subscribe your channel.
Lots of Respect.
I finally found an explanation that was easy to follow, THANK YOU.
Glad it was helpful!
I had the same problem on my job few days ago, like you explained in this video. Thank you for posting this.
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!
Wonderful!
Great explnation in the correct speed Thanks
So much easy way to explain. Now I have clear everything. Keep it up.....
Glad it's helpful.
The power which I get after watching Leila's Excel tutorials :)
Seldom used powerful "Offset" function explained very well. It has certainly helped me with one of my simulation EXCEL.
Thanks for the kind feedback. I'm glad the video useful.
your explanation is very clear, thank you.
No Way Out To Make Your Lesson Not Understanding........Again Love You And Your Style Of Teaching Leila Gharani
Thank you very much Zera! I'm really happy to hear that. Appreciate the support :)
Thank you Leila, excelent video for learning Excel.
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!!
Excellent explanation with example
Awesome!!!!!! Really helpful, clearly explained 🎉
Explaining it so clearly shows how knowledgeable you are on Excel..
A smart and beautiful lady..
Glad you like the video Simon.
This is the best explanation for this formula ever.
My beloved teacher! Your tutorials are very helpful.
I'm glad to hear that.
Very well explained. Thank you very much.
God sent you from above, Leila. You and your family will have a Beautiful Christmas!
Excellent method of explanation.. Thanks
THIS IS BY FAR THE EASIEST TO UNDERSTAND
I'm glad to hear that!
You deserve a special price, you're so helpful, Allah bless you!
Happy to help.
Your explanation is awesome.
Glad you like it.
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.
Amazing!! Cannot ask for a better demo!
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
Wow, thank you!
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.
That's great to hear. Thank you.
I want to give 100 thumbs up but can give only 1 here. The way you explain is awesome. Thanks a lot.
So nice of you!
Fantastic video, this saved my assignment! I've been trying to find a solution to my problem for the last three days, thank you!
Brilliant, absolutely brilliant!!
excellent explanations , has all the possible explanations to go through in your website, thank you
another great explanation, congrats and thanks again!
Thank you so much! This was a life saver!
Great video, nice way of explaining things
Wow I didn't even know they had that Evaluate Formula, That's very helpful!
Great explanation! Your usage of home, street and town made the explanation all the more intuitive and easy to remember. Brilliant metaphors indeed.
you are outstanding in everything I'm glad to catch this explanation
Thanks a lot. Very useful for learning.
Thank you for all the training in excel, you are very good at what you do and are very knowledgable. Subscribed and liked!
Thanks! I'm glad to have you onboard.
you inspired me to become an excel expert
you are a great teacher!
Thank you!
I was reading the explanation for Offeset in the Excel help module and it made no sense! This definitely cleared it up.
I felt the same Scott :) Glad to hear the video helped.
I'm doing your advanced class in Udemy right now and am ready to do all of them! Pretty awesome material. If you have a book or any other instructional stuff send it in my direction!
Great Scott. Do let me know if you run into any questions on the Q&A board on Udemy. Will be glad to help. I have a detailed ebook on the course you're taking. You can download it from here: www.xelplus.com/free-ebook/
Scott Miller f2
Too good Leila , Thanks , you explained it so well
I'm glad you like the video.
I been to loads of sites on understanding the offset function.
This is the best tutorial✌
Explained so clearly !! thank you Leila!
You're very welcome.
awesome explanation!!!
Commendable teaching.
Combination of skill,devotion&desire to impart best.Good show.
Lovely! So nice. Thanks so much. You're a fantastic communicator and educator!
Thank you Erica!
Amazing Teacher ! Thanks
Thank you! 😃
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!
Great to hear!
the best tutorial ever
You got mad skills Leila.
I like the way you explain the toughest task so simply. I teach my students everyday something new after very little practice on it.
Excellent tutorial along as are all your others. Thanks very much.
very good, easy to explain
Thank you very much, my esteemed teacher.
Thank you so much.God bless you
I always search the video but add Leila Gharani after, you explain so well.
Thank you! 🙏
Excellent video!
Excellent demo. Thank you!
The most useful channel in youtube
Complex work became simple one. Thanks
Great way of teaching. thanks
Thanks and you're very welcome.
Thank you so much Leila, you gave us fundamental and dynamic uses of Offset function.
You're very welcome Sanjay.
Searching for excel functions brought me to the right place...
I'm glad to hear that :)