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 TH-cam shorts like that? Thank you so much again!
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
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.
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?
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
![[MV] A leap of faith...ความเชื่อใจครั้งสุดท้าย (From "Petrichor the series")](http://i.ytimg.com/vi/U1piZH2CNXA/mqdefault.jpg)
![BOWKYLION - วิงวอน (ex-change) [Official MV]](http://i.ytimg.com/vi/cLdnZWDaO-w/mqdefault.jpg)
Ohh! I didn't know I could scroll horizontally!! Nice tip!
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
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
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.
Ctrl+shift+roll is what I've been looking for since forever!!!!!
Great tips, Kevin. Thanks a lot. Greetings
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.
Thanks uncle ben, this helps
you always great man!!!
Thank you Kevin, great tips! ❤
Great information
Very helpful tips!!
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 TH-cam shorts like that? Thank you so much again!
Thanks for sharing
Thanks for watching!
Kevin, I love your videos.. Do you have a video relating copying a sheet and automating the copied sheet in real time?
thanks for the programme, i love it
Kevin always the best thanks
Youcef from Manhattan
thanks for sharing kevin
Great tips, thank you
You bet!
Thank you so much
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
Cool. Thank you ❤
Great video
Nice video
Awesome 👍
Dude plz do more
Thank you
You genius
"You're a wizard, Harry."
You were great in Avatar 2😊
Thanks bro
Thanks
a couple good ideas
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?
I will appreciate it if you create a cheat sheet about this and many other things 😊
No.4 is goat
can you do vs code tricks next
How to make check ✔️ bubble in the cell , many thanks
Great
Link of the web that he mentioned in this video, please
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
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!
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?
Amazing. I tried to contact you through the video request link. unfortunately not available.
please guide me on this.
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
never heard of this in Hogwarts... this wizard academy is better! Might be Gandalf's alma mater. 😁
kevin cookie company
We bake ‘em fresh 🍪🍪🍪
I'm a wizard ! LOL
Dammmmm didn't know I am a wizard 😂
I know all that….but I still don’t have power😢
5 excell tips. . . For complete nubes.
F4!🎉
5th point doesn't work in my laptop I don't know why
👏👏
I saw my name!
🎉
My F4 key doesn't work like that😭
😱
✋️✋️✋️
I do all of these and more than that on a daily basis
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 😂
Please give me the link for the chat gpt website thank you ❤❤❤❤❤
🔥🤍
thanks for the programme, i love it
Thank you