🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@louisepeters8455
3 жыл бұрын
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 KZitem and found you. Your amazing, I see it so clearly now THANK YOU so much
@roymark5845
4 жыл бұрын
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.
@mohamed-hassan-
10 ай бұрын
Thanks a lot, mate, I've been working with Excel sheets and I'm a programmer that has no idea how things work in Excel, but instead of working right away, I've decided to learn a few fundamental knowledge about excel to be able to understand what I'm doing.. this saves a lot of time.. thanks again
@rasinahbinteshaiksafiudeen9101
3 жыл бұрын
Your explanation is much better than my lecturer's
@clintonrodgers9522
4 жыл бұрын
Kevin, Thank you I enjoy all of your tutorials.
@marinacvir7426
3 жыл бұрын
Thank you so much! I’ve learned a lot in a total of 9 minutes.
@victoriaagomuo3918
Ай бұрын
Simple, straight to the point. Amazing 😍
@allthatisroyaltyfreemusice6012
3 жыл бұрын
One of the best youtubers
@geotom5627
3 жыл бұрын
This is my channel
@dragnfly138
3 жыл бұрын
You sir are awesome !! Just saved me a weeks worth of work.
@danaxellind5211
9 ай бұрын
Dude thank you so much, we owe you one, big time.
@donnalee4165
3 жыл бұрын
Thank you so much. I know understand the difference between the two.
@manojillangasooriya3590
3 жыл бұрын
This is what I'm looking for mate. U r an absolute legend.
@albertvanzyl4407
Жыл бұрын
Thanks a million Kevin, I never really understood this function. But you have made it so clear. Thanks!!
@shawnsongz
3 жыл бұрын
Thank you! You explained it clearly and simply.
@tik68
2 жыл бұрын
thanks i was using goskill, but had more questions about cell reference, thanks buddy
@kv5124
3 жыл бұрын
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..)
@joshmexus9535
2 жыл бұрын
Kevin u are really a good master of computer
@philt8322
Жыл бұрын
Hi Kevin, a very useful and well explained video. Many thanks
@XMegaJuni
4 жыл бұрын
Brilliant, thank you for sharing your knowledge. Keep up the great work
@Moondog123
3 жыл бұрын
Kevin you’re a legend
@klevykids
2 жыл бұрын
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
@anishabasu4709
Жыл бұрын
Thank you @Kevin Love ❤from India
@ranjanagundumane5949
2 жыл бұрын
Thank you so much, Kevin.
@aliouseck1285
4 жыл бұрын
Thanks Kevin this video help alot😊
@bobdunyak9869
2 жыл бұрын
Thank you Kevin. Great video
@ssoltani22
3 жыл бұрын
Best explanation on utube
@KA-vx2xs
2 жыл бұрын
Very nicely explained. Thanks
@chisomobuleya
Жыл бұрын
Nice I enjoy the lesson
@joeleoalex6196
Жыл бұрын
Thank you very much your videos on MS Excel have been a great help to me. I did an expiry alert but would like to add color to it. Say Green for indate, blue for near expiry and red for expired. How do I add colors to correspond. Thanks. Much appreciated.
@liuuu534
10 ай бұрын
Thanks ❤
@yaparker22
9 ай бұрын
This came in handy.
@Nazim.InoviSolutions
3 жыл бұрын
Thanks for this great video
@FibFract
8 ай бұрын
Hi, thanks for all the great excel training videos. I recorded a macro to execute formatting I apply to a report I recieve multiple times a day. One of the formatting I apply is insert table, but the macro fails to input the table because the # of rows for each report vary - sometimes it's more or less. How can I write the macro so the code updates to the relative # of rows? Thanks.
@lyn1575
Жыл бұрын
You are amazing at tutoring. Thanks so much.
@luxrayvgc
3 жыл бұрын
super super helpful thank you so much!
@ChristopherGoodman-f8s
Жыл бұрын
THANKS!!!!!
@mohitgola9192
2 жыл бұрын
Tommorow is my exam thnx for great help
@BusinessTraveller786
Жыл бұрын
Big Thank you 👍🙏
@geotom5627
3 жыл бұрын
lifesaver
@nkechiizeji
7 ай бұрын
Pls I would like a video on IF statements, Solver, and scenario Manager. 🙏
@bridgerpetersen788
3 жыл бұрын
Thank You!!!
@Ang-s8f
3 жыл бұрын
thank you sir
@yoony5899
4 жыл бұрын
Can you do a video on formatting cells
@wivinek2815
2 жыл бұрын
thank you
@Agustinoism
2 жыл бұрын
very useful
@mackensonreginaldmichel399
7 ай бұрын
Thanks for the video. I'd like to know if I buy the 365 version, will I be able to use EXCEL online, without having to install it?
@adarshtiwari7395
2 жыл бұрын
Awesome !
@danielrittatore4394
6 ай бұрын
Kevin, i want to define some cells so someone can hover over and see what the term means in my spreadsheet. i cannot seam to figure it out. your help would be really helpful.
@josephthmas2070
2 ай бұрын
Hi Kevin, could you please help me how to change the underlying value of a cell? For example the value is 26.3773 but I want to change it to 26.38 underlying value not only the number formatting showing the displayed value is 26.38. Thank you
@scguy681
2 жыл бұрын
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!
@Michael-sl9jv
4 жыл бұрын
How to create this formulae total cost = individual cost x quantity rather than showing formulae " A10 * B9 ? TQ
@Subhash_VCU
2 жыл бұрын
Folks who find it a bit confusing, remember columns are called by letters and rows are called by numbers, now try watching the video again
@patrickpinholt
Жыл бұрын
Ahh, you can lock the number too with $! 😄
@kurtreber9813
Жыл бұрын
I need to reference cells by their row and column numbers.. Isn't there a function like CELLS(4,1) that is the same as A4? I thought there was, but it isn't working 😕
@ifeoluwaojeleye4512
2 жыл бұрын
Hello, How do I configure a cell to always reference the cell above.
@jamesogbonda8096
2 ай бұрын
lovely video . please how do i get in touch with you. i have some issues with my word
@cliccme
4 жыл бұрын
Hi, Kevin. Your all tutorials are amazing. How can i contact you through email.
@KevinStratvert
4 жыл бұрын
Thanks Hassan, email is on the about pivot of the channel. Cheers!
@cliccme
4 жыл бұрын
@@KevinStratvert I got it. Thank you very much. Also I send friend request on your facebook profile. Be blessed and happy new year.
@mosesfelix5719
3 жыл бұрын
How to create a table of two prefect squares
@princenkrumah5647
4 жыл бұрын
60th like, 7th comment.
@ashleeandrews4568
Жыл бұрын
Can someone please Write out $3.99*40 as a formula for me 😢
@raina1195
4 жыл бұрын
Pogi
@omprakashsingh2043
2 жыл бұрын
bakvash hai👎👎👎👎👎👎
@Jeaucques
Жыл бұрын
Nalayak 😒
@TigeyPuss1
3 жыл бұрын
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.
@Keyce0013
Жыл бұрын
You could probably achieve similar results if you highlighted all of the relevant cells (herbs, costs, & profit) and then went to Home -> Format as Table. The columns have built-in sorting capability so you can add new herbs, sort them alphabetically, and have their prices shifted within the table to match!
Пікірлер: 71