5 Tricks to Become an Excel Wizard
Ғылым және технология
Master shortcut keys, easily understand functions, freeze panes, and more.
📚 RESOURCES
- Excel shortcut key guide: bit.ly/excelhotkeys
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
- Playlist with all my quick tips: • Quick Tips
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZread
kzread.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel #exceltips #exceltipsandtricks #microsoft
Пікірлер: 55
Ohh! I didn't know I could scroll horizontally!! Nice tip!
The 5th tip alone deserves a thumbs up!!!
@girabbit
Жыл бұрын
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 😭”
Thanks for reminding Ctrl+Shift scroll.🤗
@NhungNguyen-iv8bm
Жыл бұрын
It doesn't work in my Excel 16, do we need to set up anything?
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 🙏🏼
I will appreciate it if you create a cheat sheet about this and many other things 😊
Thanks bro👍 I excelled in excel
Thank you Kevin, great tips! ❤
Kevin always the best thanks Youcef from Manhattan
"You're a wizard, Harry."
Thank you so much
Thanks for sharing
@KevinStratvert
Жыл бұрын
Thanks for watching!
Scrolling horizontally is such a game changer!
Nice video
You were great in Avatar 2😊
Great tips, thank you
@KevinStratvert
Жыл бұрын
You bet!
Thanks
Kevin, I love your videos.. Do you have a video relating copying a sheet and automating the copied sheet in real time?
Awesome 👍
You genius
Thank you - that was helpful
@KevinStratvert
Жыл бұрын
Glad it was helpful!
@Allinone-cn5wd
Жыл бұрын
Bro ur video is very informative thanks for giving the best possible content ...... I like u so much...keep doing great workers stay blessed
can you do vs code tricks next
Cool. Thank you ❤
Great video
How to make check ✔️ bubble in the cell , many thanks
kevin cookie company
@KevinStratvert
Жыл бұрын
We bake ‘em fresh 🍪🍪🍪
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 KZread shorts like that? Thank you so much again!
a couple good ideas
Great
Link of the web that he mentioned in this video, please
I do all of these and more than that on a daily basis
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.
I'm a wizard ! LOL
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 know all that….but I still don’t have power😢
Amazing. I tried to contact you through the video request link. unfortunately not available. please guide me on this.
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
never heard of this in Hogwarts... this wizard academy is better! Might be Gandalf's alma mater. 😁
F4!🎉
Dammmmm didn't know I am a wizard 😂
👏👏
5 excell tips. . . For complete nubes.
✋️✋️✋️
I didn't become a wizard
@KevinStratvert
Жыл бұрын
Mastering #1 alone will get you to god level 🧙♀️
@ChrisRy
Жыл бұрын
@@KevinStratvert I just became a freakin GOD!!! The hell with a wizard!!
@KevinStratvert
Жыл бұрын
@@ChrisRy 😂
Please give me the link for the chat gpt website thank you ❤❤❤❤❤