🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@salamatuyeabusesay359 Жыл бұрын
I want to work as a financial assistance but I have no job experience. Can you help
@gowaymike95093 жыл бұрын
There are short keys worth mentioning that not covered in this video. After selecting row(s) or column(s) by using the shortcut key as illustrated in this video, press Ctrl + minus sign to delete, Ctrl + Shift + plus sign to insert
@jillturner40533 жыл бұрын
omg this is amazing thank you.
@joyabsalon92162 жыл бұрын
True. This is indeed worth mentioning😊
@calystanguyen3929 Жыл бұрын
Yes. I used a lot of plus and minus sign.
@itsnotif.itswhen Жыл бұрын
Yes, the Ctrl + Shift + plus sign to insert is huge in my daily workflow when I adjust general ledger items for bank reconciliation.
@animate9612 Жыл бұрын
thank you!
@mohdabdulmateen51592 жыл бұрын
Good Evening Sir, I"m from india & i've been searching a teacher like u who gonna explain everything in detail as u did in this video, because i was at zero in MS Excel and unable to find correct path to grow but i found u here, i truly admire u & have a huge respect for your time. Thank u from bottom of my heart. Please keep making new knowledgeable videos on MS Excel. i'v also shared your videos to my loved ones & family.🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰
@AndreaGibson-fc7pt2 жыл бұрын
Thank you! Just watched a number of your videos from shortcuts to Pivot Tables, Concat and Macros. Your videos are so helpful and much appreciated.
@ciaran1105052 жыл бұрын
Brilliant Kevin you have restored my belief in Excel as i have not had to use it for a while so watching your Videos has been fantastic keep them coming.
@OlufojudeGbengaАй бұрын
I wish I could like this video a million times it's so simple easy when you teach❤
@6989yogesh2 жыл бұрын
9:55 - T stands for table and L for list box. Tables were referred to list box until 2003 versions.
@KevinStratvert2 жыл бұрын
Ah, that makes sense! Thanks for sharing!
@johnbutler27504 жыл бұрын
The alt shortcut to navigate the ribbon is great!
@wcdx19813 жыл бұрын
Alt h h to highlight without the mouse saves me time!
@MrDariusAtl10 ай бұрын
Kevin always come with fire content. 🙌🏾🔥
@dariusanderton37603 жыл бұрын
a story from a very long time ago I first learned spreadsheets before computer mice were common, and many things were in DOS (before WIndows). Keyboard shortcuts were the only way to do things, along with Function keys. Then when Windows and computer mice came along it seemed like all the young people were using the mouse and right clicking or left clicking on things, and it was just the old people who used the keyboard shortcuts. So I kind of forgot many of the keyboard shortcuts for a few years, but then other people were all saying the shortcuts were faster so I took the effort to learn them again.
@joelweiss70134 жыл бұрын
Thanks Kevin. I learned many new ones. I will be watching & studying more of your videos to learn, adapt, and apply my new knowledge.
@MyRockMyFortressАй бұрын
Thank you for this wonderful tutorial.
@saffabockarie1435 Жыл бұрын
Bro, Excel is my weakness since I came to the United States. I didn’t Accounting from overseas but never did anything about Excel. I really like the Excel shortcuts. And I will definitely prefer to work with you. Hope we can be in touch and get more knowledge on Excel. I really appreciate if you can be my teacher. Thank you .
@ianpatrick23 Жыл бұрын
This was super helpful getting me up to speed on Excel. Thank you!
@kmiracle99482 жыл бұрын
you are the best!! Learning alot from you 😌
@arthurletim12483 жыл бұрын
this is very helpful for us visually impaired community. shortcut keys is the best way to navigate excel. keep it up! thanks!
@starboy7151 Жыл бұрын
You are such a perfect guy who should be doing tv apps
@vaibhavsumit79173 жыл бұрын
Hi Kevin, nice job learnt 5-6 new shortcut enjoyed your video keep posting such videos. thanks
@ilove2playgames Жыл бұрын
Thank you. The alt+enter, I wanted that. Very helpful.❤
@rasgullakhan7973 Жыл бұрын
Excellent video.. Valuable content👍
@nathanielbalmes659710 ай бұрын
Thanks, Kevin! This is a big help. :)
@raquelrodriguez8657 ай бұрын
Thank you so much, Kevin - this was awesome :)
@petlover6072 Жыл бұрын
Oh my God ! ! That's so much help in one video. Thanks a lot
@feraidoonerfani6678 Жыл бұрын
enjoyed with the shortcuts.
@Anikvikram Жыл бұрын
Thank you for such a nice video 🎉🎉
@olgacotto7915 Жыл бұрын
Very helpful! Thank you.
@kanikamaheshwari9732 Жыл бұрын
Merci pour exister! and thanks for the amazing & insightful content 😍
@samueldegraftmintah12262 жыл бұрын
incredible. So easy to learn. Thanks Kevin
@sweetlovevlog9573 Жыл бұрын
Thank you kevin ilearned so many iwill be contenue watching & studying more of your vedios
@zishangamer63922 ай бұрын
Yes I got it very helpful video thanks ❤
@meghanb45413 жыл бұрын
This is excellent. A lot of clear and concise information in a short amount of time. Thank you!
@balakrishnankamala3744 Жыл бұрын
Thank you. It's very much helpful
@dyeninalibut3025 Жыл бұрын
Thanks again, Kevin! You make learning easy and straightforward! Glued to your videos!
@m.mohtashim20004 жыл бұрын
Thank you so much for sharing this sir. I'm so grateful to you for teaching me so much in so little time through your videos. Lots of love and tons of support from your little brother here. ♥️😊
@dianaroseprincillo79242 жыл бұрын
Thank you so much. I learned a lot today:)
@wcarlosw4 жыл бұрын
Can someone do a compilation of his intros? They are the cutest things ever.
@saburjonsaidov29043 жыл бұрын
I have learned a lot from your video, thanks a bunch
@ushernleya36266 ай бұрын
thanks Kevin good stuff
@UmairAli Жыл бұрын
a quiz with these shortcut keys would be perfect for a person preparing for exam.
@zombie20x2 жыл бұрын
This was really helpful bro thanks
@habibullahalizada61732 жыл бұрын
Thank you for your information
@RajaEdits3525 Жыл бұрын
Superb learning Excel shortcuts
@the.min9yu_k.fangirl Жыл бұрын
thank you soooooo much for this!
@partapchandra57392 жыл бұрын
Very nice class keep it up Your understanding way is very unique 👌
@MyRockMyFortressАй бұрын
I love Ctrl+Shift+! to apply number format
@wintaendriyas5192 жыл бұрын
Thank u soo much this is very helpful
@Sayedalishubbar4 жыл бұрын
thanks for your kind efforts.
@sateshn2333 жыл бұрын
Thanks! Everything except 2 I didn't know
@OlufojudeGbengaАй бұрын
Am literally studying this because of my assignment 😂😂😂
@JumpRopeVeteran4 жыл бұрын
Thanks a lot. There were several I didn't know.
@anirbanpaul1294 жыл бұрын
Hey, this is a cool video . Smart way to use Excel .
@KevinStratvert4 жыл бұрын
Thanks for the note Anirban!
@shivanmohyaddin4 жыл бұрын
Wow... Your eye color makes it so obvious of how much time you have spent learning this software...
@nataliadavila38273 жыл бұрын
This was extremely helpful! Thank you for making this video. 💜
@salamatuyeabusesay359 Жыл бұрын
it's really educative.
@buddhinihini65884 жыл бұрын
Thank you so much
@sunpasirithxssunpasiri4759 Жыл бұрын
Colud you please teach the tip that "select all colums with blanks row"?
@veronicaromero86424 жыл бұрын
Thank you for sharing the shortcut link !!! Do you have follow along videos???
@veyseltuncalan8638 Жыл бұрын
You are perfect 👍🏻
@naanbread19704 жыл бұрын
Hello Kevin. Could you tell me how to open 2 spreadsheets at the same time in Teams/SharePoint files? If we have to transfer data from one spreadsheet to another, it's very clunky to open, close, open, close to pull and enter data into separate spreadsheets. Thank you so much. Shout out from Redmond! Sharing your info in our company.. We love your lessons.
@valeriaouriques2 жыл бұрын
Thank you teacher!!!!!
@parbuarcharya97664 жыл бұрын
thank you so much sir
@mohdosman41543 жыл бұрын
great job
@denisethomas69273 жыл бұрын
I love this, you have made my job so much easier. I do have a question. I was (Making a correction)working on the middle of my spreadsheet. I had to go to the end to add more info. How do I get back to that spot I was working on without having to scroll up. Is there a shortcut to go back to the last spot I was making a correction on?
@reddlief8 ай бұрын
Seems I need to use the keyboard row of numbers and not my keypad numbers. Only works with the top row. Great video. Can you copy a formula down a column using a short cut?
@dclarek7412 жыл бұрын
If I have a number that is 17 digits long but I only want to sort by the last 6 digits. How do I break up these 17 digits?
@threeaxis3593 жыл бұрын
Thank You you're awesome!
@amosmuvona43474 жыл бұрын
Thank you so much.
@dmatula8112 жыл бұрын
Is there a screen recorder that allows you to show the keyboard and the keys you select?
@deshanbandara23133 жыл бұрын
Great job..!
@Suzukii-Krypto2 жыл бұрын
Thanks for your video. Are there keyboard shortcuts for moving pasted images to the back or to the front? Thanks in advance.
@lealoveees4 жыл бұрын
I always use ALT+H BA and ALT+H BT
@vijaykumar-nt3hd2 жыл бұрын
Thank you so much ✔️👍
@WTPlearn Жыл бұрын
Great resource. You may want to double check your Ctrl+Shift+Home and Ctrl+Shift+End The printed instructions seem to not follow the directions.
@ahamedriyas47122 жыл бұрын
Thank you🤩
@thawthaw3035 Жыл бұрын
Thank you Sir Kevin
@Gcharms2 ай бұрын
Great video. Can someone tell me how do I remove the shortcuts to start with key "/". Thank you
@compound324 жыл бұрын
Is there a way, with using the Hyperbole Link application I could navigate into links by using CTRL + [any key] sticky keys?
@thirikyaw77014 жыл бұрын
Thank You so much for your sharing .
@RexRaven227 ай бұрын
Thank you
@cityslicker49832 жыл бұрын
To delete a column: Ctrl+Space Ctrl+- To delete a row: Ctrl+Shift Ctrl+-
@victorape56882 жыл бұрын
Interesting. Thanks.
@karenjohnson98552 жыл бұрын
Curios, do we have the same symbols in MS Word as with excel say for other languages, Spanish , Chinese, or German?
@swethakadem195 Жыл бұрын
Hey Kevin, Do we have keyboard shortcut key to increase the column width like how we drag and adjust the same with mouse
@lucky-nz1ll4 жыл бұрын
Hi Mr. Kevin I am WPS user, then i found out some shortcut keys are not applicable.Anything you can advise?
@IsroNasa-r5m Жыл бұрын
I love it
@kalaklah48484 жыл бұрын
Kevin great video. Ques. what formula to subtract between cells using a large volume of values. ex, cell A1 minus cell C1 with answer in B1. repeating like that again with values in D1 minus F1 with answer in E1? repeating . I am wondering how to tell excel to just subtract into the empty cells between the two values
@anikchowdhury97082 жыл бұрын
Superb,just too good
@piyushnegi307 Жыл бұрын
Soo smooth
@rajiblochanswain28968 ай бұрын
Today is my exam and may this video help me😅🙏
@gohst101pubg82 жыл бұрын
its helpful , and useful but how I'm going to memorize all of them it will take lots of time to do but better to understand it first and practice 😅
@billjuss53312 жыл бұрын
Thanks Kevin, Great KZbin. Is there a shortcut to add the Date and time in 2-columns at the same time?
@ceryp95922 жыл бұрын
How to unprotect excel workbook password? Please help! thank you
@SaraHettiarachchi-rd8hy Жыл бұрын
Can I know how to change lowercase & uppercase in typed text
@mimisin6488 Жыл бұрын
Hello Kevin, is this tutorial for Macbooks? I tried using Option as the Alt key, and it did not work....
@hussainfawzer4 жыл бұрын
I knew it all... But I’m new to excel!
@raoppacheco76544 жыл бұрын
How do you delete a sheet with a shortcut? God video!.
@ravelbella73304 жыл бұрын
RAOP PACHECO Good not God
@dianal93464 жыл бұрын
ravel bella 👎🏽👎🏽👎🏽
@saiyankjaisi Жыл бұрын
which screen recorder are you using?
@Lord_of_Pings3 жыл бұрын
Sir Amazing
@suryabhai88134 жыл бұрын
Hi Kevin , thank you for the video.could you please explain about Excel VDB and how to use it?
@KevinStratvert4 жыл бұрын
Thanks for the suggestion Surya! I'll add it to my list of videos to create. Cheers!
@melodyjr89954 жыл бұрын
thank you. please teach how to create attendance, new version