Excel Cell Reference: Absolute, Relative or Mixed?
HTML-код
- Опубликовано: 27 июн 2018
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Reference cells correctly when writing Excel formulas. If your formulas are not working correctly when you copy them to other cells, you've probably made a mistake with your cell referencing.
Some cell references might need to be fully fixed, some partially fixed. This is called absolute versus relative cell referencing in Excel. Understanding this concept really simplifies your Excel work.
🔍 What You'll Learn:
- Cell Referencing Basics: Grasp the concept of Relative Referencing and see how cell references adjust as formulas move across your worksheet.
- Absolute Referencing Unveiled: Discover how to lock cell references with Absolute Referencing, essential for consistent calculations across your data.
- Mixed Referencing Mastery: Learn when and how to combine Relative and Absolute referencing for precise and flexible formula adjustments.
- Practical Examples: Apply these concepts in real-world scenarios, like calculating yearly totals, quarter percentages, and sales data comparisons.
★ Links to related videos: ★
Check out the full Excel Basics playlist here: • Excel Introduction - L...
★ My Online Excel Courses ★ www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
This tutorial TRUELY reflects your level of knowledge
Thanks Leila, this sorts something I was having trouble with. Your way of explaining things is great. You are turning me into a excel nerd.
I'm from the U.S.! Thank you! I'm studying for my microsoft excel exam... this helped me! :)
Miss Leila you are using Thoroughly and for me after using the MS Excel for more than twenty years and don't know even this mixed function.
Thank you for explaining it so perfectly and in layman terms. I had so much trouble understanding this concept!
The fact that I’m learning more from this video than class 💀
You are simply an amazing instructor. As a Director of Nursing in this post-COVID19 world, I am required to generate and present copious amounts of data at a moments notice. You have rekindled my love for excel and exponentially improved my productivity. I am actually thinking of starting my own channel ... Excel for Nurse Managers, ... we will see.
Best of luck, John!
Thanks for all your excellent tutorials and time Leila, I am learning a lot with you!!!
I Love how you explain the mixed ref. part perfectly make it easy to understand for me
Audio is completely in sync with your steps. Nicely explained. You are truly a gem. Thanks again. Keep sharing.
My pleasure. Glad you find it useful.
You are one of the brilliant Online Mentor for Excel.
Thank you so much.
Thanks Leila! I love the way you explain. It makes everything much easier. A question now, how do I use mixed references in an Excel table?
Leila provides the best concise lessons. Thank you so much for sharing.
This was really helpful, and i must applaud your calmness and ability to communicate well. Thanks a lot
Glad you enjoyed it!
This just blew my mind and solved a ton of issues I have with writing formulas! I've been getting creative with my solutions, this is a hell of a lot simpler. Thanks!
You're very welcome. Glad this helps :)
Thank u for such a helpful tutorial. Now i understand why different types of referencing are used in Excel.
Can't believe I didn't know about this! You just saved me so much time, thanks!
I've always had a hard time understanding mixed references - this is a perfect explanation, thank you!
Glad it was helpful!
I love your instruction. Thank you for your detail while keeping it simple.
Thank you very much. Really well explained. And your voice is so calm and composed.
your videos are so good and easy to understand thanks Leila for making such incredible excel knowldege videos
I loved ur explanation on the mixed cell referencing! Thank you! x
Thanks Leila. Mixed referencing is now clear to me
Loved the way you explain. Concise.Thanks a lot.
Great video. I needed to undestand these concepts and you gave a good example to explain.
This is an impressive and very well presented tutorial
I hope you will be having 10 million subs✨one day dear eonni~
By the way your voice is very nice and rare🙂Which would make anyone to concentrate
I really love the way you present it .Thank you so much!
very clear and concise explanation. thank you, Leila!
Very well explained, I have just started learning and your videos have helped me a lot.
This was a great explanation. Thank you. مرسی خیلی قشنگ و کامل توضیح دادید 🥰
You explain things so well and beautifully. Thank you!
Your instruction is so clear and easy to understand. You are beautiful, having a difficult time learning.
Hello, clear and simple, as usual. I didn't know that changing the position of the $ can be so important. Thanks again.
Glad it was helpful!
Thanks for your brief and easy understanding of these important stuff. Your lessons are really informative thanks Leila
Thank you very much Sandeep for your support. I'm very happy you find the videos informative.
So clear to follow your instruction. I will surely try this in my workplace.
Hi mam, great job thanks alot. warm greating from middle east. it was really helpful , confident & simple explaination.
Leila, you are the best of teaching XLS....thank you very much for your valuable efforts :)
My pleasure. Glad you like the video.
i LOVE the way you think!!........that was really helpful!!!
I love you Leila Gharani hahaha the best explaining Excel!
Thank you your Courses are very helpful.
Thank you! This explanation makes a lot of sense.
Thank you for doing this video. I really understood each a every point you told. I really enjoyed this video☺
Thank god for this lady and her videos. So helpful!!!!!!
Excellent!!! Thank you for explaining this so well!
Very good explanation. Understood. Thank you
thank you so much for all these tutorials
Thank you enjoyed your video, very easy to listen too
Clear and concise. Thank you!
Why is it so great ? thank you very much !
Thank you, Leila! I love your videos!!
Applied this to GSheets, great lesson!
Love the way you explain, it makes it super clear! Thank you
You're very welcome!
This video really helped! Thank you!
Wow you made this so easy to understand
Superb easy explanation, Thank You
Must know for every Excel user. Thanks for sharing!
Very true! and you're very welcome :)
This really helped me a lot for understanding this! Thankyou so much ❤️
Thanks Sis, I came from another course where i was having trouble in understanding , so i came to youtube and you explained it so easily, again thank you
You are welcome 😊
The example with the mixed referencing was very helpful. Thank you
You're very welcome!
Thank you so much, Leila! Very instructive and helpful.
Is it possible to use these different reference types when your data is in a Excel Table format?? Many thanks!
You are amazing!!! Best explanation ever!!!
Best explainer for me. Thank you.
thanks @leila for the valuable knowledge thanks once again leila... may be god bless you.....
Thanks Leila for nice explanation.
Brilliantly done. Thanks
Great and simple explanation with some very helpful shortcuts
You make it so easy.....Thank you
Thanks a lot. I was struggling with the references for quite a well and by watching your video helped me to identify different types of references...Thanks again, madam.
My pleasure. I'm glad the video is helpful.
You're way of explaining was great.. I would need to capture change of cell value Like old value and new value of a cell. Without vba. Do we have any options for this.?
So simple and smart! Thank you!
I've needed this for a few months now....Thank you so much.
Glad I could help Kevin!
You. Are. Awesome. You just saved me a ton of time!
Love your explanation. So clear. I actually learned something. Thank you. I will be watching all of your videos
Thanks Leila, Excellent Tutorial
This individual is brilliant
Thanks for this video. Quick question. If I want to do the same in a table, how do I lock the cells. The tables have: [@Year] for example. Year is the name of the column. Thanks
Hi Leila you are my excel guru always
Wow your lessons are really fantastic and very simple .I really appreciate your effort and patience alot.
Miss Leila, thank you soo much for this video.. actually because tomorrow is my computer practicals exam.. soo, it's sooo helpful... Thank you soo much 💓
Best of luck!
@@LeilaGharani Thank you actually and it went well... All thank you you miss Leila. ✨
Well explained ,thank you
Great explanation!
Yet again, thank you so much!
many thanks for you..your really explain everything is a perfect way.please keep it up. my respect from egypt
My pleasure. I'm glad it's helpful. Greetings to Egypt!
perfect very brilliant discussion madam...
So cool video. I understood every thing
Thanx
You saved my life
I had my practical
Could you please tell me how make multiple cell links absolute all at once, insted of clicking F4 for each individual cell?
Very well explained, Thank you!
Glad you enjoyed it!
Greatly Explained Madam
Thanks! You answered my questions and solved my problems so well!
Great to hear, Stacey!
Tommorow is my computer exam and i just saw this video
It helped me a lot
Thanx Leila
Oh! Wish you all the best for your exam :)
Hi Leila.. nailed it right into my head for .. if and or.. Crystal clear. I have a doubt why do you -1 while calculating percentage and threshold
I'm glad to hear it's clear :) the -1 comes from this calculation: The difference from Budget to Actual is (Actual-Budget)/Budget. This can also be written as Actual/Budget - Budget/Budget which equal Actual/Budget -1
wow !!!!!
glad i found your channel
I was too lazy to explain implicit/explicit cell referencing to my gf over the phone so I just sent her this link. It's perfect, thanks! :)
Haha. I hope she liked it :)
Great explanation
Thank you!
very clear
Awesome presentation , easy to concentrate
Glad you think so!
Thanks a lot. Was very useful