Intermediate Excel Skills, Tips, and Tricks – 2017 Tutorial

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 two 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.
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:


Ultimategaming47 Uzamaki says:

you are the real MVP

David Castle says:

I have watched a lot of videos in an effort to understand a little of Excel. Your two just viewed, are really a great help, with superb presentation?tutoring. Thanks. Now, regular viewing for me. Bonus for here is the subject you chose? Originally, all i wanted to do was create a DB for my Movie disc’s! How fortunate am I.
Thank’s a lot

Lorena Bernal says:

Sound is too low to follow

fanny says:

thank you man! you are saving jobs everywhere hahahah

Elizabeth Lohman says:

these were great tips! thank you so much!

CharityEspina says:

Great instructor! Do you have a Camtasia tutorial??

ndelpurg says:


Milka Namina says:

great tutorial, thank you for getting me started to use Excel

Frances Hale says:

I didn’t know about freeze panes. So glad I found you because you’re an excellent teacher.

David Anderson says:

Thanks for all the help on Excel, I really could not understand till you explained it so well in 2 lessons cheers.

Olushola Aileru says:


TheFloralP says:

Thanks man, well paced and really helpful!

theartplaza says:

It’s amazing how many people have viewed this video and have hit the like button. Is that a sign of how ungrateful people are nowadays? You can call me a troll for asking that question if you want but I’m sure that more than 265 people have benefitted from this video. You explain things so clearly it’s hard to believe that only 265 people have benefitted from this video.

Sara Fleming says:

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

Ankita Thakkar says:

Hi when you say drag the + sign and it will type exactly the same – but its not working , its actually using the pattern can u show if this happens what to do?? But I’ve learnt lot of different ways and techniques to use excel.

Judy Berkeley says:

Great help!

Simoy Morales says:

Your explanations were perfect, thanks for sharing and continue to share your knowledge with us.

Lisa Kimble says:

Really enjoyed both videos so far! Thank you

Rahi Mahi says:

Very nicely explained !! thank you soooo much.saved my time

DJB Music says:

Very clear and extremely well presented. This is an excellent teaching tutorial. Thank you.

Anna Maria Schurmann says:

Very useful. Thanks.

JorgioDiGiorgio says:


Khandokar Nabil says:

you are the best!


Thanks Alot ! Can you make more excel tutorials with shortcuts.

Eggfryinobrien says:

Well done

Joe Joak says:

I have a problem with doing a formula. I try to work with five columns with numbers not ordered, but I want it to automatically take a mean of the three mid values, meaning It ereases the higher and lower value. Could you help me, please?

Giuliana Schoeman says:

Thank you! You are a legend.

Gaijin says:

The colour scale didn’t work for me i am using excel 2013

Ronald Friedman says:

WOW-Excellent. I have been using excel since it came out and just upgraded
to 2016. I can’t believe what I did not know. Thank you

theartplaza says:

i love the way you explain things. You explain everything so clearly and concisely. It seems you would an excellent teacher. Thanks for the videos.

 Write a comment


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!