Microsoft Excel Tutorial - Beginners Level 4

0:00 Introduction
1:04 What is Conditional Formatting in Excel?
1:44 How to use Conditional Formatting
12:18 What is Data Validation in Microsoft Excel?
12:53 How to create a drop-down menu in Excel
15:31 Create a drop-down list from a list
20:07 How does a slicer work in Microsoft Excel?
20:54 Add slicers to your worksheet

***More Videos on Microsoft Excel***

I use Camtasia to create my videos:

Use this coupon code: TEACHCAM10

DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for the support!

[TequilaCone]

I started watching all your excel videos and practicing because I applied for a job promotion and needed to take a excel test, haven’t really had to use excel since high school (25yrs ago).
Took my test and was very confident and comfortable, I’ll let everyone later if I passed or not.

[Karenhenders]

I just missed out on a job because my excel wasn't strong. Let me say that after I'm finished all your videos I think I'll have advanced knowledge. Thank you, Thank you, Thank you

[myimran]

Hello! Mr. Jamie, your videos are excellent without any question. I have a suggestion for you, please introduce "projects" on the basis of your videos, so we can apply your teachings as practical knowledge. regards.

[ashleygozo]

Spent the past couple of hours watching the series of beginners. Now I feel like I can conquer the world. Haha! Thank you for your existence :)

[Roman-rsum]

12:53 IMPORTANT TIP! While setting data validation he wrote "Indoor, Outdoor, Both". If it doesn't work for you, try "Indoor;Outdoor;Both". Use semicolons. Hope it helped!

[marilynmoreno]

Here at level 4 can’t believe how easy it is to follow your videos, I’ve tried a few out there and so far yours is the best! Thank you!

[AmjadNasir]

Hello Jamie, your vids must have at least 1 Million views. I wonder why so many people are still deprived of the great stuff you put out over here. Hats off sir.

[ummuamira]

You are helping sooo many people. Thank you!!!

[arifiqbal]

I have been trying to learn excel for quite some time now. But, all the channels I have found so far either works on the very basics or directly forwards to the advanced level. I think, yours is the best series I have foundon youtube to learn excel step by step. Thank you for your hardwork.

[jacquespaquette]

Hello Jamie, I will be watching Module 5 of this series on Excel for Beginners. After watching the first one, I must admit that I no longer needed to go anywhere else. You are really great in your way of explaining the functions and interactions of Excel. it is very clear and easy to assimilate, moreover by practicing with your example files, it is even better! I take a few moments to say hello and thank you for this great learning tool. Jacques from Canada :)

[tiffanybailey]

I am so appreciative for the simplicity of your videos. Thank you!

[NusratHKhanNishi]

I usually don't comment on videos. But your videos are amazing that I had to! I learned so much. Thank you.

[hwm]

wow, have been using excel for so many years and the lessons in this tutorial opened my eyes. Thanks for the effort.

[bellendcheeses]

Thanks so much, you are a fantastic teacher.Everything is explained simply and crystal clear. 👏👏👏💪

[TAKETHIA]

Mr. Jaime I just want to thank you so much for these tutorials! They are easy to understand I’ve learned do much in watching this first video, I truly appreciate you taking out time to do these videos.

[jonburnette]

Jamie, you are amazing! I have been self-taught with excel have managed to get by but man! These instructional videos are having me do repeated face palms! I have been wasting way too much time and effort!! Many, many, many AHA moments. Can't wait to finish the series!

[CandyQuackenbush]

I’ve been teaching myself excel from YouTube for several weeks. Your videos are by far the best.

[kritijain]

you make really helpful videos. These tutorials are very easy to understand. THANK YOU!!

[evinharrelson]

So I have been watching your tutorials for job interviews to freshen up on, and came to realize that a tutorial going through each ribbons options and what they can, a quick summary of each, would be GREAT!!! that way we can know what everything does with quick examples. Doesnt have to be drawn out or long on each part.

[allisonwendell]

Thank you. Excel doesn't seem so intimidating after practicing these tips with you. Your instructional style is awesome. Clear, to the point! Ready to move onto formulas!