Agree! No more “move left in the text box to manually enter the two dollar signs but you forget that using the arrow keys selects a new cell then you have to undo and use the mouse and why is life so hard 😭”
Great video. For #4 if your data is in an Excel table as it seems to be in the video, you don't need to freeze panes as the headers will replace the column letters when you scroll down.
Nice to know something I been doing is one of these tips. Ctrl + S will always be my favorite, Ctrl + H was one of those shortcuts I wish I knew sooner. I need to remember Tips 2 and 3.
Thank you so much Kevin for all helpful tips and tricks! Did you use OBS to create videos where you talk on top of a video background? Could you please make a video on how to create a UA-cam shorts like that? Thank you so much again!
I have an excel file that I use for work, specifically car parks. The data I use are the following, license plate number, time of entry, time of exit, duration of stay, and based on these the price is calculated. Sometimes I mistakenly click on the classification, as a result of which the numbers get confused, i.e. they get mixed up. If I don't understand it right away to reverse it with undo, what options do I have?
I want to make an Excel line chart that ranks Top 40 music albums. So, the number one album in the country will be at the top of the Excel chart and the line will go down as the albums go down in ranking like down to # 200 on the album chart. Excel charts are configured to do the exact opposite with the largest number, say 200, will be a the top while the highest-ranking albums will be at the bottom. How do I reverse this? Thanks
Is there a way to fix the regional number formate in excel, i have a shared sheet between people is my departemet And if i see numbers like 1.5 they see it as 1,5 Thanks
How can I reference one column to another...what I mean is I have one column for "Products" and one column for "Parts Per Hour". So what I'm needing is when the person chooses "Product B" in the product column...the "Parts Per Hour" Column automatically puts in the number. I hope I make sense. I'm not sure what this function is called. I enjoy your videos. thanks.
Great tips, Kevin. Thanks a lot. Greetings
Ohh! I didn't know I could scroll horizontally!! Nice tip!
The 5th tip alone deserves a thumbs up!!!
Agree! No more “move left in the text box to manually enter the two dollar signs but you forget that using the arrow keys selects a new cell then you have to undo and use the mouse and why is life so hard 😭”
Are y'all new to Excel?
Not being judgmental, genuinely curious. I thought everyone knew this.
@@vignesh1065 lol agree
Thanks for reminding Ctrl+Shift scroll.🤗
It doesn't work in my Excel 16, do we need to set up anything?
@@NhungNguyen-iv8bmfor me it’s hair shift not control
Ctrl+shift+roll is what I've been looking for since forever!!!!!
Scrolling horizontally is such a game changer!
I often need to freeze one or more row at the top of the sheet. Your trick is convenient. Also the “Ctrl+1” shortcut will save me time 🙏🏼
How about you format the table as an actual table with headers? Will the top row not automatically be fixed and always visible?
Great video. For #4 if your data is in an Excel table as it seems to be in the video, you don't need to freeze panes as the headers will replace the column letters when you scroll down.
Nice to know something I been doing is one of these tips. Ctrl + S will always be my favorite, Ctrl + H was one of those shortcuts I wish I knew sooner. I need to remember Tips 2 and 3.
Kevin, I love your videos.. Do you have a video relating copying a sheet and automating the copied sheet in real time?
Time 0:33
How about you format the table as an actual table with headers? Will the top row not automatically be fixed and always visible?
Thanks uncle ben, this helps
Thank you so much Kevin for all helpful tips and tricks! Did you use OBS to create videos where you talk on top of a video background? Could you please make a video on how to create a UA-cam shorts like that? Thank you so much again!
you always great man!!!
Thank you Kevin, great tips! ❤
Great information
Link of the web that he mentioned in this video, please
I will appreciate it if you create a cheat sheet about this and many other things 😊
Thank you so much
Dude plz do more
can you do vs code tricks next
How to make check ✔️ bubble in the cell , many thanks
Thanks for sharing
Thanks for watching!
Kevin always the best thanks
Youcef from Manhattan
Great tips, thank you
You bet!
thanks for sharing kevin
Very helpful tips!!
thanks for the programme, i love it
"You're a wizard, Harry."
I have an excel file that I use for work, specifically car parks. The data I use are the following, license plate number, time of entry, time of exit, duration of stay, and based on these the price is calculated.
Sometimes I mistakenly click on the classification, as a result of which the numbers get confused, i.e. they get mixed up. If I don't understand it right away to reverse it with undo, what options do I have?
I want to make an Excel line chart that ranks Top 40 music albums. So, the number one album in the country will be at the top of the Excel chart and the line will go down as the albums go down in ranking like down to # 200 on the album chart. Excel charts are configured to do the exact opposite with the largest number, say 200, will be a the top while the highest-ranking albums will be at the bottom. How do I reverse this? Thanks
Thank you - that was helpful
Glad it was helpful!
Bro ur video is very informative thanks for giving the best possible content ...... I like u so much...keep doing great workers stay blessed
Nice video
You were great in Avatar 2😊
Thank you
Awesome 👍
Is there a way to fix the regional number formate in excel, i have a shared sheet between people is my departemet
And if i see numbers like 1.5 they see it as 1,5
Thanks
Try Ctrl-1 (Format Cells) > Tab Numbers > under Category go to Customs > create a new one using this code: 0.0
How can I reference one column to another...what I mean is I have one column for "Products" and one column for "Parts Per Hour". So what I'm needing is when the person chooses "Product B" in the product column...the "Parts Per Hour" Column automatically puts in the number. I hope I make sense. I'm not sure what this function is called. I enjoy your videos. thanks.
Index and match or vlookup, but I'm sure you're an excel wiz by now!
Cool. Thank you ❤
You genius
Great video
Thanks
Thanks bro
a couple good ideas
Amazing. I tried to contact you through the video request link. unfortunately not available.
please guide me on this.
No.4 is goat
5 excell tips. . . For complete nubes.
never heard of this in Hogwarts... this wizard academy is better! Might be Gandalf's alma mater. 😁
5th point doesn't work in my laptop I don't know why
kevin cookie company
We bake ‘em fresh 🍪🍪🍪
Great
I'm a wizard ! LOL
I know all that….but I still don’t have power😢
Dammmmm didn't know I am a wizard 😂
My F4 key doesn't work like that😭
F4!🎉
I saw my name!
I do all of these and more than that on a daily basis
🎉
Please give me the link for the chat gpt website thank you ❤❤❤❤❤
👏👏
✋️✋️✋️
😱
I didn't become a wizard
Mastering #1 alone will get you to god level 🧙♀️
@@KevinStratvert I just became a freakin GOD!!! The hell with a wizard!!
@@ChrisRy 😂
🔥🤍
Thank you
thanks for the programme, i love it