Intermediate Excel Skills, Tips, and Tricks Tutorial


Here’s my entire playlist of Excel tutorials:
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:
***Consider supporting Technology for Teachers and Students on Patreon***:

Click below for more information about some of the movies mentioned in this tutorial:
Dirty Rotten Scoundrels:
The Princess Bride:
Young Sherlock Holmes:
Mystery Men:


Xem thêm bài viết khác:


  1. Sara Fleming 11 May, 2020 at 07:03 Reply

    Bravo!! Thank you — this and the beginning video are extremely clear and well-done. You saved me hours!

  2. Mohamad Azarchehr 11 May, 2020 at 07:03 Reply

    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.

  3. Janice Johnson 11 May, 2020 at 07:03 Reply

    I admit I have used excel in the past but have been out of the office environment for years now and trying to get back to work. I know everyone uses Excel today and MS Word, your video refreshed and taught me things I didn't even know when I was using it. All of your tips/tricks made me feel so confident in just the time of watching, I'll be ready to apply for the jobs I want. I will continue to watch and learn and without a doubt recommend anyone to watch and subscribe! I have watched others and have never picked up the whole concept this fast. Thanks again!!

  4. Julian Benabides 11 May, 2020 at 07:03 Reply

    Good video- thanks. But I didn't really learn anything as it felt more like beginner stuff. Would really love a video with more advanced techniques. Anyway, thanks again!

  5. mukundhan krishnamoorthy 11 May, 2020 at 07:03 Reply

    I'm totally in love with this series, this is very helpful for me. Thank you very much for teaching , sharing your knowledge and supporting us in all the way.

  6. paozi小笼包 11 May, 2020 at 07:03 Reply

    for the conditional formatting do we need to ensure the values we selected must be in numeric format before we apply the rules?

  7. Stella_bella EMG 11 May, 2020 at 07:03 Reply

    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!!!!!

  8. Richard Chalone 11 May, 2020 at 07:03 Reply

    Very useful! Thank you so much! Why at the time of viewing there are 636 thumbs down makes no sense to me!? Are they just trolls and jerks?

  9. infarct 11 May, 2020 at 07:03 Reply

    I was carrying an A in my Quantitative Reasoning class until the first EXCEL project. It was assigned as if each student used EXCEL every day. Our dismal performance showed that we were not familiar enough for the project. Despite the poor results the instructor failed to address the shortcomings even with other projects on the horizon. Some teachers just suck credentials and all. In desperation, I sought further instruction from Youtube. You, sir, have restored my confidence and taught me things that were taken for granted by an individual responsible for educating me. As we all know in college most students are only required to take an intro to Windows/ Office. And that is usually in the first semester then they never need EXCEL again, don't even bring up ACCESS! Thank you.

  10. vector 11 May, 2020 at 07:03 Reply

    EXEL Spread IS A IS ESSENTIAL PART OF LIFE, IT plans your journey, these tutorial s is very good lesions worth doing as a beginner & professentials.

Leave a reply