5 Tricks to Become an Excel Wizard

5 Tricks to Become an Excel Wizard

Master shortcut keys, easily understand functions, freeze panes, and more.

πŸ“š RESOURCES
– Excel shortcut key guide:

πŸ“Ί RELATED VIDEOS
– Playlist with all my videos on Excel:
– Playlist with all my quick tips:

πŸ“© NEWSLETTER
– Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week:

πŸ”½ CONNECT WITH ME
– Official web site:
– LinkedIn:
– Discord:
– Twitter:
– Facebook:
– TikTok:
– Instagram:

πŸŽ’ MY COURSES
– Go from Excel novice to data analysis ninja in just 2 hours:

πŸ™ REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

πŸ”” SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

πŸ™Œ SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: (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


Five Excel tricks that will make you a Wizard number one go to the following Website and here you'll see all of the Different available shortcut keys in Excel my personal favorite highlights Themselves and press Ctrl 1 to very Quickly format them number two when Entering a function click on this icon This opens up the function Helper and This will walk you through how the Function works Number three use your mouse wheel to Scroll up and down press Ctrl shift Together with your mouse wheel and you Can scroll left to right Number four go up to view freeze panes And freeze the top row now when you Scroll down it'll lock the header in Place Number five when referencing another Cell press the F4 key this will toggle Between absolute or locked references And relative references With great power comes great Responsibility