Intermediate Excel Skills, Tips, and Tricks Tutorial

Join this channel to get access to perks:

Click below for more information about some of the movies mentioned in this tutorial:

[sarafleming]

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

[atomicmatter]

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

[joshuamark]

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_*

[danielcatapang]

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

[tomster]

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!

[sanitarycockroach]

The crap they don't teach you in school is always the most needed. Thanks for this!

[stella_blu]

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

[arbitrarylib]

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.

[adelajasonoiki]

You got me back my self-confidence which secure me a high paying job with this Excel videos tutorials. Thanks a million

[danmac]

My resumé for 2020:
Excel level: intermediate.
Excel Experience: 45 minutes on youtube.

[narmins]

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

[sharonbush]

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!

[wallaceandrews]

The beginners guide to excel was no less than amazing for someone who had absolutely no experience at all. Thank You!

[trash]

I was always so intimidated by excel but these videos are really changing that, thanks!

[UniversalStylez]

I'll admit I have learning disabilities. Whomever this is teaching gave me so much confidence in learning. Thank you so much! Wonderful!

[Bikerbelly]

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.

[subrosa]

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

[nathanprincewill]

All tutors need to study this guy.
It's unbelievable how smooth an informative this short clip is.

[mrCetus]

Of all my years watching vids on YouTube, 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.

[misslienglishclassroom]

I really love your tone, your pace and it makes a great knowledgeable presentation. I do learn and comprehend a lot from you . Thanks