Absolute, Relative and Mixed Cell References in Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 6
Jon
I'm playing WoW and I'm collecting herbs to make potions. After I level up a few rungs, some of the potions are too weak for me but I'm still collecting the herbs. I figured I could always sell the weaker potions and get a little extra cash as I quest. Then I realized that sometime it would be much better to sell the herbs rather than make the potions and sell them. So as I set up my spreadsheet to help me decide whether to sell the herbs or the potions, I realized I had a problem. I started the sheet with about 12 herbs all listed in alphabetical order to make it easier to find their costs and profits, but then I'd find new herbs and added them to my growing list. When I used the sort feature to keep the herbs in order, the prices and profits didn't follow the alphabetization. I figure I have to make absolute references in some columns or rows to keep everything hunky-dory. I'm sure fast food places like MacDonalds and Dairy Queen have a similar problem when they add items to their menu and they want to know what's profitable and what's not so profitable. I'm going to your next video on how to filter to see if that will help.
reply
I'm playing WoW and I'm collecting herbs to make potions. After I level up a few rungs, some of the potions are too weak for me but I'm still collecting the herbs. I figured I could always sell the weaker potions and get a little extra cash as I quest. Then I realized that sometime it would be much better to sell the herbs rather than make the potions and sell them. So as I set up my spreadsheet to help me decide whether to sell the herbs or the potions, I realized I had a problem. I started the sheet with about 12 herbs all listed in alphabetical order to make it easier to find their costs and profits, but then I'd find new herbs and added them to my growing list. When I used the sort feature to keep the herbs in order, the prices and profits didn't follow the alphabetization. I figure I have to make absolute references in some columns or rows to keep everything hunky-dory. I'm sure fast food places like MacDonalds and Dairy Queen have a similar problem when they add items to their menu and they want to know what's profitable and what's not so profitable. I'm going to your next video on how to filter to see if that will help.
reply
Louise
I'm doing ICT Level 2 and I told my tutor yesterday that I was leaving the course because this and the IF function made no sense the way he was teaching it. Iv bought 2 books which didnt help and hardly slept, so out of desperation turned to YouTube and found you. Your amazing, I see it so clearly now THANK YOU so much
reply
I'm doing ICT Level 2 and I told my tutor yesterday that I was leaving the course because this and the IF function made no sense the way he was teaching it. Iv bought 2 books which didnt help and hardly slept, so out of desperation turned to YouTube and found you. Your amazing, I see it so clearly now THANK YOU so much
reply
justO
took the basic Excel Microsoft certification test, passed it, and still could not get the absolute etc. references. Now I need it for Business Analytics course, your explanation was the best. Thank you, Kevin. Olga
reply
took the basic Excel Microsoft certification test, passed it, and still could not get the absolute etc. references. Now I need it for Business Analytics course, your explanation was the best. Thank you, Kevin. Olga
reply
Patrick
Hey Kevin , i like to watch your videos - could you change your cusor to a larger pointer so I can better follow where your go in the demo?thkyou!
reply
Hey Kevin , i like to watch your videos - could you change your cusor to a larger pointer so I can better follow where your go in the demo?thkyou!
reply
KEVIN
Thank you for your Help Kevin i really suck at the absolute thing in excel, after watching u made my day great, THANK U,(I'M KEVIN TOO..)
reply
Thank you for your Help Kevin i really suck at the absolute thing in excel, after watching u made my day great, THANK U,(I'M KEVIN TOO..)
reply
Roy
I've been using Absolute, and Relative Cell References for years, but I still picked up a few tips from this video. Great job Kevin.
reply
I've been using Absolute, and Relative Cell References for years, but I still picked up a few tips from this video. Great job Kevin.
reply
Add a review, comment
Other channel videos
6:43
13:19
3:55
