Intermediate Excel Skills, Tips, and Tricks Tutorial
HTML-код
- Опубликовано: 19 июн 2024
- 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🎯
@@Troublle_editz .nomnnm
Mm
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
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!
You got me back my self-confidence which secure me a high paying job with this Excel videos tutorials. Thanks a million
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!!
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
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!
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.
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.
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
The beginners guide to excel was no less than amazing for someone who had absolutely no experience at all. Thank You!
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.
best voice for tutorials on youtube..
Agree
absolutely !
The best!
Yes and best communicator too
I agree!
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
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 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 was always so intimidated by excel but these videos are really changing that, thanks!
i was more confused on how to use it
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.
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.
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'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!
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.
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.
All tutors need to study this guy.
It's unbelievable how smooth an informative this short clip is.
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.
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 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!
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!
Thank you😊 this was so helpful as newly unemployed 50+ (due to Covid 19) who has been left behind by technology. Have all the experience and skills but prior everything went computerised. Now gives me a little more chance at interviews 👍
This guy needs more subscribers. What an underrated youtube channel.
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!
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.
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! 👏🏻
thank you man! you are saving jobs everywhere hahahah
hahahahahahahahaha lmao!!!!!!!
Truth!
This was the most productive and understandable tutorial I have seen - thank you!!!
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!
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!
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 =)
Your explanations were perfect, thanks for sharing and continue to share your knowledge with us.
Crisp voice, plesent tone, clear pronounciation....and no nonsense, simplified, well structured Content.
Absolutely useful, easy to learn mode.
Many thanks 🙏
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
Wow... I have learned almost everything I wanted in just 2 tutorials. You r the best
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😊
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 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 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!
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'm an aspiring digital nomad who has zero digital skills. I was close to buying a course from Udemy (but waited until I have a new laptop), I'm so glad I found your Excel beginner's video and this one! Your channel has a wealth of information I will have a wonderful time watching and learning.
When I get a job and if you have a membership channel, I will subscribe to your membership platform. For now, I subscribed here. Thank you.
this is life saving tutorial for me.. other channels are providing 15-20 hr excel guide and you saved me only in 45 mins.. thank you so much
I watch a lot of how to videos on RUclips. 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!
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! 🙏🏼
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've been using Excel for years and I've learned through trial and error with no knowledge of the terminology. I have an interview coming up and this has helped tremendously. Thanks
I really appreciate you making this video. Everything you showed was clear, and easy to follow and this has really helped me a lot.
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.
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
Absolutely loved the explanation- Simple & Interesting
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
Another very informative video, thank you!! You really break the information down and make it very easy to understand. Well done sir!
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.
I absolutely love your tutorials!! You were destined to be a teacher! the best and most useful tutorials on RUclips👍
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.
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!
I would really just like to thank you for teaching these things. I've used my iPhone for so long being unable to afford a computer that I've forgotten most computer basics. When going for job interviews they all want you to know these things. So thank you! 🥰
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 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) 🍀
This tutorial is FANTASTIC. Your explanations make perfect sense, and the order of presentation was so comprehensive, THANK YOU!!! 🌺🤘
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.
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.
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!
Needed a refresher course. Your explanations are very clear. Thanks 😊👍
I have indeed watched the Beginners and this Intermediate video and they are very good and provide a sound basis - Thanks! (I'll now watch the other ones and continue to learn...
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.
Greatest two videos of all time! Congratulations!
Your video is so informative, i have no background on computer or the terms and languages that is used but with your video it taught me how to used it.
Thank you for doing this video's for the people like us who have no experience or knowledge about computer.
Thank you from the bottom of my heart! Excellent job with this video and the beginners one!
Making excel spreadsheets is my new addiction
Lol - Mine too!
Me too fellow nerd
Same
Great tips! Thanks for sharing
I went through some paid LinkedIn videos, I found this tutorial far more helpful than those Paid LinkedIn excel tutorial. Easy to follow and Implement. Have implemented those tips at work place. It saved my time massively. Thank you so much
Excellent start/ reminder for use of Excel spreadsheets. Thank you!
This is amazing. I knew nothing about excel before. Now I feel confident
thank you very much for this amazing way of teaching Excel
God Bless you, Brother :)
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
I am beyond thrilled I found your channel. You explain the material in such a way that it is concise and digestible. 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 👍
Of all my years watching vids on RUclips, 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.
Wow, you have really simplified things for me. This was my first step (knowing and understanding Excel) to becoming a data analyst.
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.
great video ! im a student that needs to learn about excel and this helped me a lot. Thank you!
Thank you so much for this tutorial .
This was so helpful! Never thought I would understand anything in excel but you definitely changed that!
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.
nice work dude...awesome video, very useful..I really dont understand who are the ones to dislike such a useful video (86 in this case).
Flawless presentation. And great voice, too. Thank you for this cool tutorial :)
WOW!! Your videos have been a life saver for me! I started a new job a few months ago and had very little experience with Excel. I needed practical knowledge fast and your videos gave me all the information I needed and so much more. Thanks to you I now love working in Excel so much that I've started using at home too.
Thanks for your kind words. I’m glad you’re finding my videos to be helpful.
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.