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

  • @bluebee29
    @bluebee29 Жыл бұрын

    Ohh! I didn't know I could scroll horizontally!! Nice tip!

  • @gajdet
    @gajdet Жыл бұрын

    The 5th tip alone deserves a thumbs up!!!

  • @girabbit

    @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 😭”

  • @Rice0987
    @Rice0987 Жыл бұрын

    Thanks for reminding Ctrl+Shift scroll.🤗

  • @NhungNguyen-iv8bm

    @NhungNguyen-iv8bm

    Жыл бұрын

    It doesn't work in my Excel 16, do we need to set up anything?

  • @d11ita
    @d11ita Жыл бұрын

    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 🙏🏼

  • @abdikarimgedi7442
    @abdikarimgedi74429 сағат бұрын

    I will appreciate it if you create a cheat sheet about this and many other things 😊

  • @140.subs.with.1video.challenge
    @140.subs.with.1video.challenge Жыл бұрын

    Thanks bro👍 I excelled in excel

  • @turnabol
    @turnabol Жыл бұрын

    Thank you Kevin, great tips! ❤

  • @YoucefYoucef-ft9ce
    @YoucefYoucef-ft9ce Жыл бұрын

    Kevin always the best thanks Youcef from Manhattan

  • @JR-xu1ez
    @JR-xu1ez Жыл бұрын

    "You're a wizard, Harry."

  • @h4niali
    @h4niali Жыл бұрын

    Thank you so much

  • @Buharialtinee
    @Buharialtinee Жыл бұрын

    Thanks for sharing

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    Thanks for watching!

  • @StepByStepExcelTutorials
    @StepByStepExcelTutorials5 ай бұрын

    Scrolling horizontally is such a game changer!

  • @sergeirachmaninoff6397
    @sergeirachmaninoff6397 Жыл бұрын

    Nice video

  • @locolocococ
    @locolocococ Жыл бұрын

    You were great in Avatar 2😊

  • @bendilla5191
    @bendilla5191 Жыл бұрын

    Great tips, thank you

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    You bet!

  • @spuneet156
    @spuneet156 Жыл бұрын

    Thanks

  • @DeborahJohnson-ym9co
    @DeborahJohnson-ym9co Жыл бұрын

    Kevin, I love your videos.. Do you have a video relating copying a sheet and automating the copied sheet in real time?

  • @flashi1800
    @flashi1800 Жыл бұрын

    Awesome 👍

  • @nicolassandoval4225
    @nicolassandoval4225 Жыл бұрын

    You genius

  • @Haytham93
    @Haytham93 Жыл бұрын

    Thank you - that was helpful

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    Glad it was helpful!

  • @Allinone-cn5wd

    @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

  • @whitefoxff8994
    @whitefoxff8994 Жыл бұрын

    can you do vs code tricks next

  • @connellacyrus5468
    @connellacyrus5468 Жыл бұрын

    Cool. Thank you ❤

  • @BooksInSeconds
    @BooksInSeconds Жыл бұрын

    Great video

  • @waelalaa2557
    @waelalaa2557 Жыл бұрын

    How to make check ✔️ bubble in the cell , many thanks

  • @normaluser84
    @normaluser84 Жыл бұрын

    kevin cookie company

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    We bake ‘em fresh 🍪🍪🍪

  • @TrangLe-wb9nc
    @TrangLe-wb9nc Жыл бұрын

    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!

  • @stevenw354
    @stevenw354 Жыл бұрын

    a couple good ideas

  • @motivation_m00d
    @motivation_m00d8 ай бұрын

    Great

  • @centynela2235
    @centynela2235 Жыл бұрын

    Link of the web that he mentioned in this video, please

  • @spuneet156
    @spuneet156 Жыл бұрын

    I do all of these and more than that on a daily basis

  • @Ahmedssamyy1
    @Ahmedssamyy14 ай бұрын

    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

  • @AR15_Texas
    @AR15_Texas Жыл бұрын

    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.

  • @k.c1126
    @k.c1126 Жыл бұрын

    I'm a wizard ! LOL

  • @user-fg6pf2ox1i
    @user-fg6pf2ox1i Жыл бұрын

    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?

  • @hanguyen5101997
    @hanguyen5101997 Жыл бұрын

    I know all that….but I still don’t have power😢

  • @ahnuhmannathly
    @ahnuhmannathly Жыл бұрын

    Amazing. I tried to contact you through the video request link. unfortunately not available. please guide me on this.

  • @angienic1
    @angienic1 Жыл бұрын

    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

  • @bvrbvt05
    @bvrbvt05 Жыл бұрын

    never heard of this in Hogwarts... this wizard academy is better! Might be Gandalf's alma mater. 😁

  • @alexmendez9627
    @alexmendez9627 Жыл бұрын

    F4!🎉

  • @platoonutzeyz88
    @platoonutzeyz88 Жыл бұрын

    Dammmmm didn't know I am a wizard 😂

  • @brendamartinez6955
    @brendamartinez695510 ай бұрын

    👏👏

  • @jaycie5021
    @jaycie5021 Жыл бұрын

    5 excell tips. . . For complete nubes.

  • @ziaahasanrana7629
    @ziaahasanrana7629 Жыл бұрын

    ✋️✋️✋️

  • @ChrisRy
    @ChrisRy Жыл бұрын

    I didn't become a wizard

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    Mastering #1 alone will get you to god level 🧙‍♀️

  • @ChrisRy

    @ChrisRy

    Жыл бұрын

    @@KevinStratvert I just became a freakin GOD!!! The hell with a wizard!!

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    @@ChrisRy 😂

  • @karimbenzima2922
    @karimbenzima2922 Жыл бұрын

    Please give me the link for the chat gpt website thank you ❤❤❤❤❤

Келесі