10 Best Excel Tips for Beginners
HTML-код
- Опубликовано: 30 июл 2024
- Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E... Want to get ahead in Microsoft Excel? This video will show you 10 time-saving tips in Microsoft Excel. These tips will show you some of the most effective ways on how to use Microsoft Excel 2016. Check out the tips below:
Stay up to date, subscribe to Teacher's Tech: bit.ly/Subscribe_TeachersTech
0:00 Start
0:42 Quick Analysis
2:16 Filter
3:57 Control keys
4:25 Adjust column widths in Excel
5:13 Flash Fill and Auto Fill in Excel
7:04 Absolute cell reference
9:24 Transpose tables in Microsoft Excel
10:14 Text columns
11:47 Inserting a screenshot
12:53 Show formulas
Check out these detailed tutorials:
VLOOKUP Function for Excel: • Vlookup Function in Ex...
Microsoft Excel - Beginners Tutorial: • Microsoft Excel Tutori...
Learn Pivot Tables for Beginners: • Excel Pivot Table Tuto...
Microsoft Word - Beginners Tutorial: • Microsoft Excel Tutori...
Learn Pivot Tables for Beginners: • Excel Pivot Table Tuto...
Microsoft OneNote - Detailed Tutorial: • Microsoft OneNote - De...
I use Camtasia to create my video tutorials: techsmith.pxf.io/KYOeN
My online teaching tech kit: kit.com/teacherstech/online-t...
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Thank you so much!! I'm a Beginner.....and when I say Beginner...I mean I'm like an alien who just stepped foot onto Planet Earth!!! I'm pretty new to all things Microsoft but work in the Front Office of a middle school and now that we're quarantined because of Covid-19, I am determined to be at my job and stretch myself. I'm really understanding the tutorials and no longer feel like an alien... more like Big Foot with some knowledge of how the (computer) world looks and works!! Thanks again and I'll continue to better myself and apply all I've learned!
how courageous r u, I luv that not may people would accept to say they are in office n know nothing. watch this to see the power of excel ruclips.net/video/SQbRatup2qU/видео.html. don't forget to subscribe to my channel for more
Hi Crissy, how's it going now?
@@peteradeteacher1380 the by
@@davidtaylor4630 you are welcome also
I've been using Excel (and loving it) for 30 years so I don't consider myself a beginner but even I learned a few things with your tips! Thanks so much for sharing your knowledge in an easy to understand way. I shared with a few of my colleagues so I hope I can help you get to 1/2 million views on this one!
Thank you very much for your videos! I was a complete beginner in Excel. I never used it in my life and thought it's incredibly difficult . But after your tutorial for beginners I am now able to use it and find it very interesting!
Even as a long time Excel user this is great, we get stuck on old slow habits and your fresh look at shortcuts is a great time saver! Ctl ~ my new favourite. Thank you
Great tips! I like the teaching style because I am learning and it is easily understandable.
I have never messed with Excel in ten years. So much of my forms I use for work are Excel and now I understand how they were made. I have watched all your videos.
Wow! That was excellent refresher course for me. Big up for the updates.
For quick cell reference lock hit F4 to apply $ signs to both column and row, click again goes just to column, click next goes to row, click again takes it away. Very fast and easy. Hope this helps others.
I love this tip! Thanks for sharing!
I'm not a beginner but this was a good refresher and learned new stuff. Thank you!
I like style of teaching, Kevin makes everything so easy to understand, from the basic to the advance.
This guy knows his stuff! Love the video!
Excellent tips, well demonstrated... thank you!
Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊
Hey, you give the desire to learn in the late in the night ... Excel . Incredible ;) any way - super extra explanation !!! Keep going :)
Super explanation! Looking forward to learn more about Excel .
Thanks for this video. I'm trying to decide the best way to introduce Excel to teach my high school computer class (remotely). This will help!
I honestly cant get into words how much of a life saver you are sir!!!!!!!!!
Good video. One neat thing about Excel is that there is usually more than one way to achieve a goal. I have found the Keyboard shortcuts have really saved me time, as compared to using the mouse.
Really well presented, not too fast, not too slow. Thank you.
I really enjoy watching such great training videos. I appreciate it if you would make MS Excel videos suitable for levels upper than beginners.
Excellent video and instruction al style. Thank you!
This is so good - I’ve used excel for years. And learnt loads from this.
Thanks 💛
Fantastic tips. Thank you so much.
Unbelievably useful. You are a life saver, sir.
Wow, I learnt so much from this video today. Thank you. Great easy to follow presentation. I will now go and have a practice.
this is very helpful tutorial for beginners . thankyou . i want to learn more about using excel spreadsheet .
This is totally awesome. This tutorial is just perfect, not too fast not too slow.
That was very helpful and you are a great teacher! Thank you for sharing!
Awesome! Some of the tips I never knew before. Thanks for the tutorial!
Want to learn more about Excel? Check this tutorial out: ruclips.net/video/k1VUZEVuDJ8/видео.html
OMG I love it.. so easy to understand and learn. Thank you so much.
Marvelous Jamie bless you for explaining Ms excel so easily great work.bleep it going.
This was great! I would love to learn about pivot tables. I need to merge donor information into a word document from an Excel Sheet and not sure how to do with over 600 donors.
Fantastic tips! Thanks for another great video on Excel.
Thanks!
Another great set of tips Jamie. I know enough about Excel to do what I want to do, but there are some great little time saving gems here. Well done. Looking forward to the next one! ;-)
Thanks, Tim!
The best tutorial yet.
Thankyou very much Sir , Great teacher easy to learn and highly recommended . God Bless you more
I found this useful. I didn't know about the screen shots, and how to show the formulas. I forgot how to make a formula absolute although I know the difference. Great video.
Have a job interview and going through stuff. THanks for the help!
Really amazing, thank you so much.
Love your video on Excel; I'm just a beginner but know just enough to get by; however, with your tips and treats in Excel, I know that I'll be able to show my collagues at work these awesome shortcuts that you have provided me, appreciate ya!
hi sherl, learn more from here ruclips.net/video/SQbRatup2qU/видео.html very nice timecard tool with a lot of formulas.
That screenshot tip and screen flipping are excellent!
Amazing tips and great help.
Thank you.
Great tips, Thanks so Very Much!
Great video, excellent explanation!!!!!, thanks man helped a lot
Brilliant, thank you
Thank you for the very useful tips !
I'm new to excel, such cool tips to save time and be like a pro ... You are great thank you for these ...
These videos helped so much I got a promotion at work by knowing how to use Microsoft programs properly because of your videos ! Thank you so much
this is really wonderful.... thanks for sharing.
Great work! Thank you so much for showing the easy ways to work in excel. Although, can you please make another video to solve formulas and other quantitative values in excel? IT WOULD BE A BIG HELP, AGAIN THANKS A LOT.
Thank you so much for the tips..very informative..
I'm a beginner and receiving Excel spreadsheets from coworkers. Knowing how to quickly reveal formulas on spreadsheets I didn't create is extremely helpful.
Great tips! Easy to understand.
helped me SO much, thank you, sir!
All your tutorials about Excel are fantastic. Although I need sometimes to do some research especially concerning the shortcuts. The use of shortcuts depends very much on which kind of keyboard you are using. Belgium here with french keyboard, so sometimes I get confused, but that of course isn't of your fault. I am really glad I found your channel, I learned a lot about Excel. Keep going!
This is a great video. Thanks a bunch!
Thank you very much. Very informative and easy to understand. I will be looking for other helpful tips and videos. God bless.
Very much helpful. Sir, Could you please upload a video on Pivot Table and Dashboard for multiple sheets? I will wait to see that
GREAT JOB SIR. THANKS ALOT
This is a great lesson, it has opened my brains to excel
You can have a look at this first. ruclips.net/video/xO-IIzz_tgA/видео.html
You should wacth the tutorials, he makes them so well
lol "opened my brains" I like that! 😃
They were truly useful thanks!!!
you deserved a like and a subscriber congrats teach you've gotten one
THANK YOU!!!
This was really helpful for work, thank you :)
Thanks a lot you are our teacher and big respect for the job you doing
Your explanation is short and clear. Thanks. Subscribed and thumb up.
I guess I really need the Excel program in order to follow along...So much to learn
You rock man. Nice job. I learned a lot.
Great Tips. Keep up the awesome work :)
Love this tutorial, thank you!
This was awesome!!! Thank you SO much 😊
very great tips, I am beginner, I love your teaching style, It is very clear, easy understand and follow.
AWESOME HELP! THANK YOU SO MUCH! I GAVE YOU THUMBS UP! : )
That was great! Thank you! Got yourself a new subscriber 😊
Wow, very lucid and simple way of making people learn excel
This is great, you teach in a way that is understandable and to the point. Thank you!✌🙂
ruclips.net/video/SQbRatup2qU/видео.html check this out Debbie for excel formulas. please like n subscribe to my channel you will find great excel work
Thank you!
Great video thank you.
This was GREAT!!! This is better than the courses. It's so easy to understand!!
Ok watched it, which one should I watch next Teacher Tech?
Thank you
Learning a lot😃thanks so far, Marielle
Your tutorials for beginners is just great. I would appreciate it if you show how to remove or correct those #### that show up in cells. I have one in a date cell I can't get rid of the date shows up in the ribbon but I can't clear it in the cell. Thanks
Very useful. Thank you. Google Sheets and Excel are similar but not the same...
great tips! Thank you for sharing!!
This is great content. Thank you!
Very helpful , thanks a lot for your great tips.
thank you for that useful information. you deserve huge praise :)
Loved this!
Hi. I am watching this in July 2021 as a refresher. I will share this video with my Accounting Instructor. I especially love the Control Tilda feature in Excel. Thank you for your video. Be safe!
I am impressed to learn this symbol. I was taught it was named Tilde and that it had no function other than a fancy dash mark. Exciting to me.
I really appreciate you! Thanks for being such a good teacher. I am unsure how this is happening, but sometimes I get a blue arrow connecting two columns on the same row. What does this mean? Thanks.
Super helpful and excellent talking speed. Thank you
Very helpful!
Thank you very much for your wonderful efforts!
Your Excel tutorials are very helpful! Thank you!!! Can you do a tutorial showing how to export from a Google Drive document to Excel?
Thanks and Thad a good idea!
thanku soo much
Excellent. Thank you!
Thanks a lot. This is an excellent lesson.
great teaching style very easy to understand thanks a lot
Thanks for sharing these useful tips.