Intermediate Excel Skills, Tips, and Tricks Tutorial
Here's my entire playlist of Excel tutorials: bit.ly/tech4excel
Learn many of the intermediate skills, tips, and tricks that you'll need in order to be able to use Excel effectively. This is the second of several video tutorials on Excel. Please consider watching my other video: The Beginner's Guide to Excel. In this intermediate video you'll learn some advanced formatting tools such as conditional formatting, how to save time by using the Autofill Handle, the basics of formulas and functions, sorting and filtering, and a few random useful tips such as Freeze Panes. Find my whole Excel playlist here: bit.ly/tech4excel
Join this channel to get access to perks:
/ @techteachersandstudents
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with the video: bit.ly/intermexcel
Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels: amzn.to/2xTpck1
The Princess Bride: amzn.to/2yk3tDc
Ladyhawke: amzn.to/2xOhLsA
Stardust: amzn.to/2yjJvs9
Young Sherlock Holmes: amzn.to/2xaJJNv
Mystery Men: amzn.to/2yRmQ3r
Bravo!! Thank you --- this and the beginning video are extremely clear and well-done. You saved me hours!
Sara Flemin
Agreed 👍 Great clip 🙌🏆 Just found this channel so hopefully there's more 😊💛
True, it teach me a lot :)
Olá galera do Canal Sara Fleming Nós trabalhamos ministrando Cursos, Mentorias e Treinamentos On-line, seja para Sair das Dívidas, seja para Conseguir o seu Emprego no Mercado de Trabalho, seja para Empreender....ou até mesmo aprender INFORMÁTICA do mais absoluto zero... Ahhh abaixo, está em detalhe, um dos nossos cursos Oii tudo bem? 📢📢📢 É complicado né? Não conseguir organizar as nossas dívidas e nossos gastos, receber várias ligações de cobranças, ficamos perdidos, más sabia que a grande maioria das pessoas não sai das dívidas, por não saber organizar? Curso Dívidas Zero (Administração Financeira). 🎯Como reconhecer a sua dívida 🎯Como reconhecer a sua dívida 🎯Como NÃO negociar as suas dívidas 🎯Possibilidades de negociação com juros menores 🎯Como organizar as suas dívidas em Planilha 🎯Como organizar Gastos / Despesas e Investimentos 🎯Como organizar Gastos / Despesas e Investimentos 🎯Como prever cenários de gastos futuros 🎯Como transformar Passivos em Ativos 🎯Como calcular quanto Gastar e Quanto Poupar 🎯Como montar um Controle Financeiro Mensal 🔔🔔🔔E muito mais ... queremos realmente que você conheça 100% de uma das Áreas que mais contratou em 2019🎯 📢📢📢.....matrículas limitadas🎯 🔔🔔🔔E muito mais ... queremos realmente que você conheça 100% de uma das Áreas que mais contratou em 2019🎯 📢📢📢.....matrículas limitadas🎯
@@Nycritz_edits .nomnnm Mm
The crap they don't teach you in school is always the most needed. Thanks for this!
foreal
True, my school taught me how to use openoffice, but all the jobs require excel.
U right!
Damn what schools you attended 😂 we went over this in highschool here in SC
My school taught me Latin, I’d really like to know what relevance that has in the age of a technology world
Not all heroes wear capes.
Yeah... Maybe he is a retired Microsoft worker
@YOO HOO Ok, boomer. Calm down.
agree
some just do microsoft software tutorials on YT
Yeah... They can also wear scarves.
Format painter 1:09 Conditional formatting 2:18 Specific formatting 4:28 Formulas 5:20 =Sum( 6:50 & 8:15 8:45 (auto sum) Reformat conditional formatting 9:35 =average( 9:55 =max( (highest value) =min( (lowest value) Formula bar 11:25 Auto fill 13:10 Pattern auto fill 14:00 Dates/time auto fill 15:05 Sort 15:55 Filter 16:48 Freeze pane 18:30
how did you know i needed this? thank you
Appreciated the content breakdown, thanks buddy! 😁
Thank you!!
Thank you beautiful I needed this ☺️
imagine having this kind of professor in college. I bet everyone would listen to him. I love your tutorials. They're straight to the point and easy to understand. Excel isn't scary after all lol. Thank you so much!!
I completely agree!
My resumé for 2020: Excel level: intermediate. Excel Experience: 45 minutes on youtube.
Don't settle for just intermediate. Watch a couple of my advanced Excel videos! :)
@@techteachersandstudents I am always wathing ur regular videos. I need some on writing mathematical symbols and equations. Can you plz upload some.
Hahaha! Exactly!
Graduated with these videos hahaa
cut that number in half , i understood everything even at 2x speed
This helped me review for a big certification test I have today. Thank you! If I pass, I will be the only person in my middle school to have a MOS (Microsoft Office Splecialist) certification. Edit: *_I PASSED_*
Congratulations👏
Congrats!
Congratulations
Bawss
Congratulations!!
You got me back my self-confidence which secure me a high paying job with this Excel videos tutorials. Thanks a million
I've felt like a moron not being able to make some simple spreadsheets at work in the job I'm currently in. I knew I was capable, however I lacked a solid base of foundational instruction to create simple, easy to read and accurate information. Your basic excel along with this one have given me the ability to give a higher quality product for folks to access the information I've been asked to provide. Thanks!
I learned more in two videos than i did in four years of high school
It may be due to that forced learning is not so worth than self learning
Dam true
😁 Me, too!
😂😂🔥
ya, he saved me before it happens to me. it's true what you're saying. yep
Thanks to this video, I passed an Excel test today and got a higher paying job!
Congratulations! Thanks for sharing your good news with me.
What kind of job do you have?
Wow
this is the dream looooll. learn free through youtube and get paid more😂😂
I am writing one tomorrow
This guys tutorials should be featured in every school, just slap his vids up on the projector in your IT class and let the kiddos learn. big help thanks a bunch.
Everyone needs this type of teacher. People would pay for what you do, but thank you for making this free because you are CHANGING lives honestly.
best voice for tutorials on youtube..
Agree
absolutely !
The best!
Yes and best communicator too
I agree!
I was always so intimidated by excel but these videos are really changing that, thanks!
i was more confused on how to use it
The beginners guide to excel was no less than amazing for someone who had absolutely no experience at all. Thank You!
Oh My goodness this video is awesome if you need to brush-up on excel and if you don't know it very well it will give you the information in bite sized portions, the tone and speed in which the person is speaking makes it not boring to listen to the tutorial the whole way through.
I highly recommend to watch this video, Its easy to follow through, not redundant, very explanatory. I applied for an office job and after the interview I took an Word test and an Excel test. Coming from waitress to an office job I had no clue how those program worked. This videos were so helpful. I cannot wait to apply what I have learned from this video. Thank you so much!!!!!
I'm starting a new job next week which involves a lot of Excel, this is saving my career and is gonna help keep me from the streets hahaha. thank you man!!!
Narmin S how did it go? Did this video really end up helping you tremendously?
weak.
All the best!
Same here
I want to thank you so much for these videos! I am trying to brush up on my excel skills for my dream job. This is so great because I can work at my own pace. I watched half this video last night and the other half tonight. You explain everything so well that someone who just worked a 12 hour shift and is half brain dead can still understand! I am so grateful to you! I cant wait to continue on to the rest of your videos!
I hope you got your dream job..
Same ✨
I really love your tone, your pace and it makes a great knowledgeable presentation. I do learn and comprehend a lot from you . Thanks
I'll admit I have learning disabilities. Whomever this is teaching gave me so much confidence in learning. Thank you so much! Wonderful!
Good way of saying it. It is probably just alot of teachers are just like robots.Its not your fault at all. This is clearly delivered and not taught by some know it all tutor.
Me too but I am going to keep watching this so I can understand it
You got this!!!!
Same here! Just an absolutely gifted instructor. I wish all my teachers in school were this great lol!
All tutors need to study this guy. It's unbelievable how smooth an informative this short clip is.
The most concise and useful videos on the web, a masterclass in content editing, always TO THE POINT. No fancy tricks or wasting time presentations. Great content! 👏🏻
This is absolutely awesome. Your explanation is very concise, perfect, short and to mark. It really makes very clear for beginners on basics. Thanks for this.
I haven't used excel since I've graduated highschool over 7 years ago and I must say your two vids on this have been an awesome refresher! Bravo brother! 👏👏
69?
same here
I promised myself that I would learn the basics of Excel this summer so that I will not get anxiety when discussing this topic during interviews. OMG!! I am so happy this channel exist!!! I have watched two of your videos so far and I am hooked on learning this stuff! I feel so much more confident in Excel now. Thank you so much for taking the time and patience to help others!!! You are the reason why some of us are landing the job of our dreams or completing tasks that we once believed we could not do!!!!
I could not agree more!
Thank you so much I appreciate your videos, they have helped me through a lot. I literally new nothing about excel but from watching your tutorials on it, I can confidently go on about my school work and do the activities.
Thank you so much for this tutorial. I just came from watching your beginners guide and it really freshened up my skills on excel. I'm a lot more comfortable now playing around and getting things done.
thank you man! you are saving jobs everywhere hahahah
hahahahahahahahaha lmao!!!!!!!
Truth!
Of all my years watching vids on KZhead, regardless of the categories, the beginner's and intermediate videos you've done have been the most significant and beneficial. Teaching guru. Passed an inventory clerk excel test, the same day after watching these videos. Honestly, I had used excel a couple times to print sheets, but they couldn't tell. Lol Thank you.
Wow, thanks! You've made my day with your kind words. I'm glad you've found the videos to be helpful. I post new videos at least every Monday.
The most helpful video I've seen. I took a brief in person course on excel over the summer and did not learn as much as I have watching just your first two videos. Thank you.
I never understood why my dad would get so excited about excel when i was younger, and i never thought much about it, but now that i'm getting a little bit comfortable with the program, i'm having so much fun using it. thank you!
This guy needs more subscribers. What an underrated youtube channel.
I loved this tutorial! Thanks so much for catching me up on long forgotten excel skills! You presented in such a clear manner it was very easy to follow. Cheers!
I want to personally thank you for your videos. I am in the looks for employment and many jobs want you to have knowledge of excel and functions, etc. I haven't used this since my college class requirement. Your videos are thorough, clear and very easy to follow. Thanks again.
Your explanations were perfect, thanks for sharing and continue to share your knowledge with us.
Wow... I have learned almost everything I wanted in just 2 tutorials. You r the best
In 2020 this is still one of, if not the best, tutorial. Well done Sir. I know many, many folks like me are still learning from your teaching skills. Thanks again.
For me as a beginner, your tutorials are really fit to me and clear to recognize how to use. Thank you for helping me save my time!
This was the most productive and understandable tutorial I have seen - thank you!!!
Thank you SO MUCH for making these videos! Usually I think anything to do with computers is SO boring, but your videos are the first ones I have seen that are user friendly and not dry/boring. I need to learn Excel for an assessment test so your videos are going to be SO HELPFUL. Thank you again 💎
I absolutely love your tutorials!! You were destined to be a teacher! the best and most useful tutorials on KZhead👍
Very clear and attention-grabbing way of teaching. I needed to learn this for a new job coming up and this has helped me greatly. So thank you!
These tips are very helpful......clearly explained and easy to follow. THANK YOU!!
super very well presented video. thank you so much. ive learned a lot😊
I am amazed by the way you explain everything! You have saved my life hahah. I can't wait to watch the rest of the videos... Great job =)
Needed a refresher course. Your explanations are very clear. Thanks 😊👍
This is SO helpful. I’ve been needing to brush up on my excel skills for university & this video has been *chef’s kiss*
I really appreciate you making this video. Everything you showed was clear, and easy to follow and this has really helped me a lot.
Making excel spreadsheets is my new addiction
Lol - Mine too!
Me too fellow nerd
Same
Thanks for the awesome tips. I have not use Excel for many years and your tips brought all the memories back, and your explanation is super clear & easy to understand. Thank you again.
I am starting a new job in administration and your videos have helped me so so so much! Thank you for making them so easy to follow and helpful, much appreciated!
I am so grateful I found your channel. I was going to take an intermediate excel class. You've done a great job in explaining the content. Thank you so much!
I watch a lot of how to videos on KZhead. This and the beginning Excel video are excellently done. Your presentation is clear, organized and covers an appropriate amount of material in the time frame. Thank you so much!
I am beyond thrilled I found your channel. You explain the material in such a way that it is concise and digestible. Thank you!!
Few days ago I had to attend a test on MS Excel and that was on a short notice. I just saw your tutorials, prepared myself for the exam within 2 hours and these videos were just life saving. Thank you so much. Wish you all the best.
THANK YOU THANK YOU THANK YOU!!! I'm currently working on a career change. For the last 20 years Ive never even had to touch a computer for work but that's all going to change soon. I knew absolutely nothing about Excel....until now! You sir are by far the BEST instructor Ive come across online. Please keep these videos coming! Just brilliant!
Thanks for the info. Though I've been quite familiar with Excel, Freeze Panes is new to me and looks to be very useful in large spread sheets.
Amazing, I love the simplicity on the way you explained the details.
Wow, you have really simplified things for me. This was my first step (knowing and understanding Excel) to becoming a data analyst.
Wow thank you so much for the video! Love your patience love your voice love everything about the way you teach! I needed to brush up on Excel and this was exactly what I needed! 🙏🏼
Thank you for this. You are indeed a teacher! Straight forward , simple, good voice modulation, and practical items pointed out. Need this kind of video for skills enhancement. This is also good time for us who are in community quarantine. P.s I wished my school placed more emphasis on this during HS 😂 excel is life in any..in ANY profession. Thank you thank you
Great video! Thanks for making it. Definitely not too long, i think it was just right. I’d like to see another Intermediate video with more tricks ... say: common tax or profit margin formulas, organizational methods & moving formula outcomes to a different sheet.
Just had a refresh of my Excel "skills" and found this tutorial really helpful. I will now go on and watch some more, thank you for sharing.
currently watching in 2019 and can't thank you enough! you have been a life saver. I love how well you explain things, it makes it easier to learn. I never had the opportunity to learn this kind of information and my current job requires me to use excel on a daily. This has been so helpful.
i want to say something really special: the last item you teached "the freeze option", my father used to use it and i didnt know how. since he passed away, 3 years ago ive been struggling with that question but i was so lazy to search for it, and now i learnt it from you. its beautiful when you are trying to learn excel but the teacher clear a good memory from a loved lost ones.
Best wishes
That is very nice 👍
Thank you so very much. I learned so much from this video and the previous beginner video. You were so thorough and clear, I was able to understand literally everything that you explained and am so grateful to you. I subscribed to your videos and am looking forward to watching the remaining ones.
Thank you for the clarity with which you explain and show how to go about using excel
Another very informative video, thank you!! You really break the information down and make it very easy to understand. Well done sir!
This tutorial is FANTASTIC. Your explanations make perfect sense, and the order of presentation was so comprehensive, THANK YOU!!! 🌺🤘
I like the way you teach, words you say are clear, and you zoom your screen so the one watching can totally view where and what you are referring to. I'm just a beginner in everything about MS -Word, Excel, Ppt
Exactly the information i was looking for. I went round and round in microsoft itself. The instructions were not clear at all. Your instructions were clear and concise. Well done! Thank you!
Thanks for the tutorial you continue share with us. These videos have really enhance my knowledge in Excel. I really appreciate you.
Very helpful videos. You are a great teacher. Thumbs up!
Top Notch! Thank you so much. From beginning to end your video was clear and concise. You have made learning what seemed to be overwhelming very enjoyable. I thought a few times, that I wish I had found your videos sooner.
Excellent video demonstration on how to use it, I'm trying it out with Libre Office and most of the functions work in a nearly identical fashion. Thank you very much.
Greatest two videos of all time! Congratulations!
This is amazing. I knew nothing about excel before. Now I feel confident
I'm assigned to do an explanation and demonstration for Excel because some of my co-workers thought that I'm advanced in it since I'm "young". Your tutorial really helped me advance my skills more because I only know basic functions and some functions that I explored myself. Thank you so much!!! I'm a teacher btw so this really helps! Thank you!
Thank you for being both super clear and very quick at the same time! 🙏🙏🙏
Great tips! Thanks for sharing
Thank you so much for an awesome vid! I learned a lot and I def love the freeze pane info. In comparison to other vids, you don't move quicker than the eye can view...many thx for that. I look forward to other tutorials!
Thanks for the feedback. I'm glad you liked the video! Tomorrow morning I'm going to post a new Excel video on Excel Data Validation and Drop-Down Lists. It may not sound too exciting, but it's one of the best Excel features in my opinion.
Thank you so much for sharing not really used excel for over 20 years and using your tutorials it’s all now fresh in my mind again 👍 much appreciated 😁👍
Thanks for the good explanation, you are really the best. I have been watching to many videos regarding exsel for beginners and I must admit that was waisting my time... I am so grateful to you. THANK YOU SO MUCH
great video ! im a student that needs to learn about excel and this helped me a lot. Thank you!
Great tutorial, thank you! A faster way for AutoSum is the shortcut: Alt =. This works for both column and row totals. These are the steps: 1.) Select the cell you want the sum to appear 2.) On your keyboard hold down the Alt key, then press the equals sign. It will add a SUM function to the cell, then press enter and the total will appear Another way to use the AutoSum shortcut is: 1.) Select the values you want to add 2.) On your keyboard hold down the Alt key, then press the equals sign and the total will appear When you do this method Excel will put the total in the cell after your selection. Furthermore, if you mouseover (hover over) the AutoSum symbol it tells you the keyboard shortcut. Hope this was helpful!
1st method is not working..2nd one is working 👍
Amazing video. I've been hesitant to use excel but now I have no choice as I'll be using it on daily basis! Your videos are really helping! Well done.
Crisp voice, plesent tone, clear pronounciation....and no nonsense, simplified, well structured Content. Absolutely useful, easy to learn mode. Many thanks 🙏
I don't usually like to comment on the internet, but I will drop a message to say thanks and show appreciation from me. You have quite many videos - that based on my need - have been helpful to me! And I compliment you for your skill to present good and enjoyable videos, easy to understand guides. Thank you 🙏 (Love from Bali, Indonesia) 🍀
I really appreciate the way you explained with such a practical example. thanks a lot
I request if u could make a short video on "merge & center" n "wrap text"
Excellent start/ reminder for use of Excel spreadsheets. Thank you!
WONDERFUL! Thank you so very much! I now feel prepared to start my new job. You are a great teacher!
thank you very much for this amazing way of teaching Excel God Bless you, Brother :)
Can you make more? I like watching these and learning something new each time
I'm glad you're finding my videos to be helpful. Here's my complete playlist of Excel videos. I add new videos to the list regularly: bit.ly/tech4excel
What a blessings. Between the beginner's and this tutorial.. I'm feeling a lot better about putting into practice what i've learned and approaching jobs requiring excel skills.
This was so helpful! Never thought I would understand anything in excel but you definitely changed that!
Flawless presentation. And great voice, too. Thank you for this cool tutorial :)
I'm starting a new job in finance on Monday and I'll be doing all of this, thank you! Thank you, thank you, thank you!
OMG! You are such a great teacher. Clear and Concise and right to the lesson. Thank you so much.
Loved it...so helpful...not used EXCEL for a few years....on a mission this week, so this is helping enormously....thank you so much