MS Excel - Cell Reference
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- MS Excel - Cell Reference
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
To Buy Full Excel Course: bit.ly/38Jyu3p
Use coupon "TH-cam" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialsp...
In this video, you will learn the application of absolute, relative, and mixed cell references in Microsoft excel. This is one of the important concepts of ms excel.
For more updates on courses and tips follow us on:
Facebook: / tutorialspointindia
Twitter: / tutorialspoint
LinkedIn: / tutorialspoint
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Who's here in 2024😂
Me for ssc CGL mains ...pre nhi hua abhi 😂
sir this actually helped me a lot I was constantly getting confused in mixed referencing but after watching this video I understood everything
You are so amazing. A living example of find passion in what you do!! Loved the video thanks a ton.
Thank you ...finally, I understand this topic.
Your videos are so interesting and not boring, it ends while you're waiting for something new
May Allah increase us in knowledge
FUck your allah
Who the hell are guys to dislike this video...Man..you are simply amazing for beginners like me..Thanks a lot for providing me this enormous content event without paying a single penny for it.
There are some rival channels who did such things.
People who are watching thus in 2024 ... Then like 👍👍👍
People who are seeing this a day before exam 😂 pin me plz
😂
day of
😂😂😂 it's 1 : 30 am , I have exam in morning at 9:00 am .
Pass ho gye tum
Me!
Very well explained
Really helpful for my tomorrow's computer test
We want teachers like you in our school
Very appreciable teaching
th-cam.com/video/XZ1rIbIshfw/w-d-xo.html
I also have a computer test tomorrow. Seriously, this used to seem soooo boring when taught by my school teacher, but actually it isn't boring!
Everyones watching this video for the same reason.LMAO
Thankyou sir finally I got worthy playlist on yt to learn excel ,that useful in reality not like other youtubers time wasting videos.
All the best all of you for your Term 1 exams
I've been struggling to understand the concepts behind cell referencing. You made it extremely simple. I'm truly grateful for this.
I have my IT examination tomorrow and I was finding it hard to memorize it as the textbook words didn't appear familiar, but after seeing this video I understood well! thank you so much !
I hope it went well, I have an exam tomorrow
Thanks for whoever liked it
Thanks for whoever liked it
This is the best video ever . Ur fluency in english and teaching method is just amazing. Thanku so much sir 😇
The content is undoubtedly great but your systematic way of teaching the topic has inspired me Sir. Thank you!
Your videos are so interesting and not boring, it ends while you're waiting for something new
May Allah increase us in knowledge
No one can beat your lecture sir. Amazing
I like your English language very much ❤ it's interesting to listen and I understand this topic also
I just started a course and it sounded so complicated plus my trainer speaks too fast. This has helped me so much. Not as complicated as I thought. Thank you.
you practically are a life saver ...... thankyou I'll be passing my exam successfully tomorrow :')
Not Relative Not Mixed , Absolutely Understood Sir ! ☺️👍
Sir your videos are very crisp and to the point....very helpful and productive
It is really very helpful. You are explaining every topic very well, it is easy to understand. Thank you so much.
I really appreciate the work you're doing great , m getting all very smoothly the you teach sir ,, salute you... big thank to you sir you providing all free for the needy people.....
Thanks a lot for this sir I am having my exam tomorrow but this topic seriously confused me 🙄 but you video was a great help 😁😁👍👍👍🙏🙏🙏🙏
Highly applauded!..ur efforts are really remarkable...Hats off to this young man...🎩🎩🎩
This is the only tutorial video that I clapped👏
haha ...literally I did the same
Great video
School m aise teacher hone chaiye👨🏫
You are so straight to the point. Excellent teaching
👍👍👍👍👍👍👍
YOU TEACH REALLY NICE.PLS CONTINUE MAKING VIDEOS LIKE THIS.
Thank you .Well explained
One of the great excel tutorial I have ever came across. Please keep uploading informative videos.
there is clarity in your teaching siR
Really you explained very clearly .
Its very easy to understand .
Seriously i had lot of confusions in F4 ,you made it understable to me.
Thank you very much for such a great explanation Pavan .
NEYAH THIS IS SO ETHICAL AND PROFESSIONAL😮
My man here with the fancy-ass touchscreen, I need that in my life.
ikr lol
Yes Yes! Fancy-Ass #Pavan's fancy ass
@@mdzoran799 Bruh.....
Excellently explained i did not find any other video that explains as this video .
Keep continuing good job and once again thankyou from my heart
This was just amazing! Thank you so much, it really helped me!!
Sir, You are great I was looking for mixed reference.. Thank You Thank You....Best Video
First of all thank you so much sir. Very nice videos, the way u explain i reaally like ur videos. Its very helpful
Perfect explanation it is jst fabulous 😊
Really appriciatable efforts very clear tone very helpful. thanks again.but I didn't see menu bar create in Excel sheet please try it
##########
This was the epic tutorial I had ever found in youtube
THANK YOU FOR MAKING THESE LESSONS EASY SIR, I HAVE A QUERY WHEN I WAS FINDING THE PERCENTAGE AND PUTTING THE SAME FORMULA AS YOU DID I WAS GETTING THE RESULTS ONLY OF DIVISION NOT PERCENTAGE THEN I APPLIED % SIGN AT THE END THEN F4 I GOT THE ANSWER BUT THE % SIGN WAS NOT THERE ONLY THE NUMBER. IF YOU COULD PLEASE ASSIST ME WITH THE SAME.
same problem anyone please assist
Select row
Then
Ctrl+F1
Select percentage
Thank you sir. It had really helped me.
This has been well understood, you examples are very good and simple. Thank you.
reduce decimals from 2 to 0 using format cells then it will show percentage mark %
Thanks a lot Tutorial Point...... it is to the point lecture and clear crystal...
Great work, thanks for uploading.
Yaaa
I hope schools provide such teachers soon❤️
Finally Sonu Nigam ❤
Your examples were perfect to understand references.
*I can't thank you enough. Awesome info.* 👍
Bro this helps so much, my TA went way too fast in explaining and just expected us to know how to use excel. And after class I asked for help and every time he would have me do in front of him as in asking “okay explain to me how to do it”. Like bro I DONT KNOW, that’s why I’m asking you!!!
Hello sir .. ur videos are superb . N really helping me to understand excel but I have a question ... to lock a cell u said to press F4 but it is not locking the cell sir , is there any other method to lock a cell
LoL, i was putting a $ sign instead of pressing F4
I got it now
click Fn + F4
You are awesome sir I love the way u teach us excel👍👍👍👍
Thankyouuuuuuuu sirrrrrr
This session was very informative; however, could you please tell me.. is there any long cut besides F4..as I am unable to get doller sign after pressing this
it's very easy, in numbers section of your keyboard has $ sign, just press shift+4, you will get $ sign, and you can put it in any position you like
Prs fn+F4
@@suryavashistha6249 thank you helped
One of the best tutor. Thank you Sir!!
Who all are watching this the day before exam
👇Like
Thank you sir, tommorow is my practicals ,, it helped me a lot
Many people facing the problem that they are not getting percentage.
Plz change the format of that particular range before entering data into it, then u will get the no in percentage.
@Aleena Thanks a lot. I was wondering about it. I think he forgot to mention about the percentage thing.
May be that is homework,😂😂
Thank u so much. Please keep on doing this. Your voice makes watchers feel more comfortable.
Please show another way of locking cells ( Without using Function key)
type doller manually
@@snehal2917 not working
@@cupcakes.1112 in my laptop it's working perfectly
@@cupcakes.1112 another way is click Fn + f4...see in keyboard there is a Fn key
@@snehal2917 this is working perfectly...thank you so much
Thank you so much sir..!! You are the one who explains excel in very effective manner..!! Anyone can understand your language..!! Keep uploading more videos from different topics..!!👍👍👍
It ŕeally helped me a lot
You are my favorite sir 😊😊😊... Thank you so much sir for this video lecture 😊
How do you use big touch screen for background?
Pls tell me..Sir
I want to use it.
I get to understand excel more with d help of you videos
Thank you
Who all r watching this one day before exam ??
😂😂🙋🙋
On exam day
🙋♀️
Me
2hrs before exam😂😂😅
@@rituagrawal7003 you are a legend..
Aap ka video bhat achcha hota hain please app Hindi language mein bhi bataiye
How to lock any column no in a formula if I don't remember the shortcut key F4
Crystal clear explanation..... it's very useful...
When I try to lock with f4..it show pc screen only duplicate extend second screen only like this at left side
There should a boutton named 'fn' press it along f4 ... it should lock the cell
tq IK
I always learned this concept but never understood how it actually worked . This video helped me a lot thank you so much sir
nice tutorial. can somebody help me here. when I try to drag the formula down into numerous cell and press enter there is no calculation happening
yes.. i'm also facing this problem
Thank you sir ❤️. It helped me
Hi please help me i want to learn the formulas perfectly
so kindly requesting you to reply me back
Shazia Banu watch all the videos carefully..
You will learn easily
Have my IT practicals and i almost felt like crying as i couldn't understand anything. This is a life saver! Thank you very much.
@minxsvagI am watching this video 4hrs after you
I too have exam today.and I am watching it at 12:56 am mid night.
how many of you are learning new stuff in this lockdown and not for any exam ?
Yash Wankhedkar me
Come teach me bro
Bro... Count me out
@@sunita6692 same
Tomorrow is my paper and i am studing today
You are a specialist in teaching
In the previous reference the earlier cell was used as a reference to subtract the next cell, but in case we want to find the percentage then this reference will not work. In this case we would require Absolute reference.
Name Student marks Percentage
Total Mark 100
a 80 80.0%
b 90 90.0%
c 60 60.0%
d 40 40.0%
e 50 50.0%
So if we want to divide all the marks with 100 to get a percentage, all we have to do is =B3/B2
And press F4 when the cursor blinks at B2, in this way all the numbers will be divided by the Max marks Hundred.
**Remember to change the format of the sheet, you can either Right click and change it using the Format cells option and choose Percentage, else you can do it by moving to the Top (Bottom) of the screen, next to Wrap next, a drop down is there, please choose the Percentage option from the drop down.
You earned a subscriber and you deserve this so as to spread your information.. thank you once again
sir plz make video in hindi
Thanks for your wonderful explanation
I AM WATCHING THIS BEFORE EXAM!!!!!!!! AND IM SUPER SCARED FOR THE EXAM IGCSE
have really benefited from your teachings thanks sir
Percentage method confused me
I too
Thank you sir today is my computer practical of this only.👍
I am watching this video before my exam
These type excellent...👍
How did got that percentage in absolute reference
Correct qsn
thanks bro, tmrws my exam
Sir f4 key not working in my system instead it increases brightness
Bro press fn key it will change the function keys and it will work
@@shubharokzs Thank you so much! Mine was forwarding the videos.
@@shubharokzs 👍👍
Excellent video and really appreciate this
PERCENTAGE NOT COMING
You select percentage option while selecting colum in which column you want percentage
me hindi medium se hu lekin hindi ki sari videos dekhli kuch smjh ni aya. apki video me itni asani se explain kiya ki ek hi bar me pura concept smjh me agya. thanku so much sir..
Thank you very much sir , tomorrow is my exam and you have helped me a lot
I don't need to watch any video after watching this video , thank you sir 😊🤗😊🤗😊😊😊
Check out latest MS Excel Online Training
courses on : bit.ly/38Jyu3p
Use coupon "TH-cam" to get FLAT 10% OFF"
Anyone have joined this classes ???
@@aartichoudhary4086 No need to join the courses, you can buy the course it recorded, and very cheap and it is great course!
#3tom