Microsoft Excel Tutorial for Beginners #7 - Formatting Pt.2

[solnoe1]

formating in excel 2011 is harder

i cant find the auto format

[Pyorie]

I love your accent. XD

[phoen99rising]

I've found that putting 0 as the cell value will make the minus sign appear automatically. Anyone else?

[darkhope2]

YOU ARE AMAZING.....THANK YOU SO MUCH!!!!!

[SirTripmeister]

MotionTraining for president!

[drl72381]

Thank you, Ringo!

[drl72381]

'merica!



[mstax]

Echoing all the others here... thanks so much for your tutorials!!

[tiffanykeepgoing]

It's extremely helpful...

I dun know why people dislike it...maybe thet don't install Excel in their computer :P

[juleidy16]

Thank u sooo much for your help now i can get a better jobThanks to your help! I love YOU eventhough i don't know u !!! :)

[himo848]

good



[tim2co]

i have been searching for a good tutorials foe excel. this one is the best one ever, its simple and easy to understand and explained so clearly. thank you so much. i have interview tomorrow and i have learned everything from you in space of a week for my interview. so happy to find you.

[theinlwinchen11]

stop at around 6:5 :)

[ovaistauheed]

well it is realy the best i can say,how nicely it has been made easy to understand ,thums up.....

[spookszone]

thank u buddy

[TheDaylightMidnight]

Thank you so much for these tutorials. I stopped using excel for quite some years but since I need excel for my studies/work.. I have to start all the way from the beginning all over again.

And from all the other tutorials for excel i have seen in YT, yours are the only one I can comprehend.

[shylildude]

how would you format the cell so that there is a border in the middle min won't let me do so

[skyelass]

I could listen to you talk all day; perhaps a possible career in radio in the future?

[GingerMonkey21]

How do you format then entire column to always do the greater/less option. Meaning like your example of higher or lower than 9 -if you have a continued spreadsheet that will be added to-can you format the entire column of C to always calculate that without having to go back & do any paste formulas etc....?

[keepgoingism]

You Rock Sweet as Mr....... TVM

[Triniboi231]

Thank you so much for you time and effort for making these videos, I had no experience with excel and will be taking a computer coarse in my first year of highschool so thanks once again for preparing me for this :)

[cabobila]

Brilliant tutorials. Very well explained with clear language and perfect pace. Thank you so much for your time and effort.

[pauymatt]

Well, I'm Mexican and Even with the English accent I can understand everything so far and it has been so helpful. I'm really thankful.

[TheTommorow1982]

Thanks alot.Id completly forgotton exel,and there is no way to get back on track more interesting than these videos.i cant get enough of it,its like i want to watch all of them nonstop!!thanks again for execelent job:)

[ynot623]

Great tutorials! Real easy to understand :)

Thanks alot

[tennanttrainee8]

Are you from Manchester?

[ZIM2309]

You, my friend, are going to heaven!!

[Wideolink]

Great Excel Tutorial Well Explained - Keep it up!

[TheTarrBaby]

I start a job next week where I will need Excel. I haven't used it in years. Thank you so much for your videos. I feel much more confident going in there Monday. :)

[BlariX]

@TheTarrBaby I started my job today and I was absolutely clue less. I used to use Excel a long time ago but I completely forgot what I was suppose to do. Bit embarrassing but hopefully these tutorials will rejuvenate my brain again.

[StewartHaasNewman]

Is this excel 2007 or 2010? Please get back to me ASAP

[JudgeJulieLit]

@StewartHaasNewman It's Excel 2002 or 2003. MS Office 2007 and 2010 have a new, different interface -- mainly "the ribbon" atop the screen, left margin to right. It newly groups functions differently. For example, in upper left corner is an "Office" button that when one clicks, drops down a menu like the old File button. Fairly easy and quick to get used to. YouTube has Excel 2007 and 2010 tutorials you can "graduate" to. Have fun!

[StewartHaasNewman]

@JudgeJulieLit Ok thanks so much

[skfarkowski]

Hey mate. Thanks a lot for these tutorials. They made my life much easier :)

All the best!!!

[xadam2dudex]

how did u delete the C14 and D14 values and enter the dash ( - ) ?

[majigga]

THANK YOU!!!

This is really demystifying excel for me, I am quite confident that I can master these tasks now!

[majigga]

THANK YOU!!!

This is really demystifying excel for me, I am quite confident that I can master these tasks now!

[mightyironleg]

seriously thank you so much, i'm about to start temping and this has sent my confidence through the roof :)

[mikeymyer]

This tutorial is so great! Even using Excel for more than a year now I still find this helpful! Fav and Subed

[mohdtaqui]

Hi, let me inform you that you have made me learn excel and i am excel in excel now.. I really appreciate your time and patience in explaining and uploading these videos on you tube. You have made my life easier. I am getting lots of appreciations from my boss and its only because of you.. thanks alot and god bless you...

[Zodija]

Love this! Love learning to move those little boxes around! Love learning to do conditional formatting! Thank you so much!

[janetitan]

I can tell green is your favorite color!

Thanks SO much for these awesome tutorials. They are very helpful.

[Friendsshare]

These are awesome. If there was a donate button I'm sure a lot of us would be happy to buy you coffee or something.

[verochat77]

thanks for the tutorials i needed to learn this to become more valuable at my job ,is there a free download for excel i need to practice what you are teaching me

[spookybuk]

great tutorials man, thanks a lot for them

[crisco21c]

Count (Movies)  6 6 6

:D :D

[gracieespiritu]

this is very informative and easy to understand!

[fonsecafh]

Oh my !!!!!!!!!!!!!it is getting dificult to understand it !!!!!!!!!!!!!!!! my streess is going up!!!!!!!!!!!!!!!!!!pleaseeeee­eeeeeeeeeeeeeeeeee somebody help meeeeeeeeeeeeeeeeeeeeeeeeeeeee­eeeeeeeee understand it !!!!!!!!!!!!!!!!!!!!!!!!

[milred16]

Hey there,

Your tutorials are just too good. They are so well explained and so easy to understand. Hats off to you to take the time and effort to share your knowledge with everyone. Would love to learn more on advance functions and Macros.

Thanks very much,

Ruth

[sdbizzy619]

your awesome i just hate these ignorant people that say stupid things thanks again

[gezekia22]

This is awesome thanks a lot :)

[need2learn2spkspan]

i remember doing this shit in school in IT, and i gotta say in the past 2 hours i've watched your past 6 lessons and messed around on excel at the same time, ive learned more about MS excel from this in that time than i did in a year at school!!!

that's saying something about your vids dude ;)

[KALfilms]

@need2learn2spkspan I think it says more about your school haha, public school yes?

[Mrchacha55]

Sir, professional. Very precise and clear. It would be a great help if you could teach us 2007. Mostly I guess people will have Ex 2003, but 2007 tutorials will help us learn 2007 without having to buy but will be able to use if and when we have to. Would be utterly useful for professionals.

You are so methodical, I have fallen in love with the way you teach. Thank you so much for your precious time and patience in doing this.

[yybh05]

Thanks for your great tutorial ! It is the best one that I have seen so far ...............

[4OutOf5Doctorz]

Great set of tutorials. I learned a lot and I loved the English accent. I don't know why, but I assumed automatically that he was very intelligent. :0)

[SiTaE05]

thanks a lot!! 

[4funNreal]

mufferrs your too much!! Leave the professor alone! I luv his British accent!!

[mikaeel01]

you are amazing. thanks a lot for this great helpful tutorials

[ycongleton]

Your tutorials are awesome! Thank you so much for your time, I'm learing a lot. I understand you perfectly, the accent makes it more interesting!

[djtevi]

Great tutorials! Incredibly helpful.

[peyoyomouille]

great video... How if you have an enormous worksheet with a lot of empty cells do you fill them quickly with a little bar centered is there a quick way?

And one more question how when you export data from financial statement you make the negative value in parenthesis? thanks mister

[weiwei6969]

mic volume is low..

[bomenenzo]

Thank you very much

[U53FUL1D1OT]

thankyou! i had a job interview and completely ballsed up on the excel questions! ive been called back for a second interview though so have brushed up on my skills with your ever-so-helpfull CHEW-torials!!! hehe thankyou so so much:)

[marushkah4]

I am so delighted with your tutorial....thank you

my daughter showed this to me!!!

[MotionTraining]

I'm not American so I don't say 2-torial. I don't say 2's Day and I don't download from i-2unes either.

[eacans]

@MotionTraining haha!

British English Rules.

[ilovemangos70]

@MotionTraining You rock; that was awesome

[4funNreal]

@mufferrs LOL you are to much!! I love his accent! <3

[4funNreal]

@mufferrs LOL your to much!! Plz leave the professor alone!

I luv his British Accent!!

[4funNreal]

@mufferrs your too much, plz don't mess with the professor! I luv his accent! :)

[antkiller905]

@mufferrs

How thick can you be, idiot?!

[komisobaba]

You are the best. Thank you so much!

[believetrust]

The best tuitor ever ! thank you

[leah42607]

Thank you so much! Looking forward to a second interview on a job and I think this will help!

[dilanlan]

Thank you thank you teşekkürler xiexie arrigato tak danke merci

[DahakaGR8]

Wonderful

[LondonForever75]

These tutorials are great - so helpful.

[mohamedbichara]

Man! you did a great job!

Mohamed from egypt

[Euromergina]

thank you very much!

[dharmalondon]

that really helps.. i have been watching it so far and and it really helps

[sekarva]

Yes, click to float does not appear on Excel 2007, but if you right click on any cell, it would give you the options for font, colour, text size, etc

[SingHouse]

The 'click to float' feature doesn't appear in Excel 2007. Anybody know why?

ps Thanks you are an absolute legend, I have a job interview tomorrow and this really improves my confidence. Do you have any idea how many people come away happy after watching your FREE videos? you are the new king of youtube.

[mitten2787]

Got a job interview tomorrow for a data entry position. This helped refresh my knowledge, thanks alot.

[vnin2012]

Simply amazing. Your generous sharing of knowledge is so well appreciated.

[ernestomck]

Awesome tutorial, great teaching. Thank you.

[MicheleSakyi]

Veeeeeery helpful. I thank "GOD" 4 u

[Labady21]

I wish every learning video was simple as yours. I enjoy it and learn a lot. I am looking forward for other great video on that excel and any other topic.

Thank you so very much

[meditater99]

I'm gratefully appreciated you made those videos for all the excel beginners, you save us a lot of time and headaches, can't thank you enough for doing this!!!

[woodyman20]

Quality, easy to understand and follow. many thanks

[oaklandrmoss18]

jeez everyone worships this guy cuz he made a few tutorials. lol its good and all but get off his dick

[jjlljjll]

We are "on his dick" because a lot of people watching these videos needed to get proficient at Excel QUICKLY.

I got a job interview at short notice, and part of the job would involve working with this package. These videos got me up to speed in less than 2 hours time. They tell you everything you need to know, in a way that's easy to understand.

People have every reason to feel grateful towards him for taking the time to make these tutorials for public use.

[michellem775]

I actually learned excel in college but I feel like I didn't learn enough. Instead of spending so much time on accounting classes I wish they made us take more Excel & Powerpoint classes. Thank you, I'm learning so much:)

[kotabenerjee]

I am very scared about excel before but now i am feeling very easy. thanks a lot .

[barrow410]

Fantastic series of tutorials, thank you very very much!

[antichushka]

the best video in youtube!!!

[Paktaykana]

this tutorial is very helpful to those people who are looking for a job especially office work and not only that even students and teachers...

so thank you very much for your effort of doing this tutorial and posting it in here...

God Bless and may the Good Lord be with you always! Tnk u again

[islandbabe26]

Great Job!!

[islandbabe26]

wow very, very helpful...by the way I'm a beginner and you make learning excel so great!! Thank you!!!

[lubenitza2004]

I think you are a GREAT teacher. I get everything so easily from you. Awesome!

[vannesses]

It's nice description and easy to catch up for beginners. Very helpful, Thanks a lot!

[1965jon]

Thanks teacher! Succinct and to the point.

[muss212]

u convey the message much better than a lecturer teaches in class, u should be teaching in uni, great work 5/5

[see2saw]

u r the best teacher ever..i was excel phobic all this time and now i feel light.. :D

[Slayallica84]

very good job mate, I have been out of school for a couple of years and this was a very helpful brush-up course. Bravo!

[ksibtain]

I've learned more from your videos on excel than I did in class. Thank you so much - keep up the great work!

[Ganeimama]

Great teacher:)

[darko2279]

UGH when I try to do the conditional format it tells me "No cells were found" very frustrating!

But I DO LOVE ur videos! :D

[kornblomstvej]

very useful. great!!!!

[DangeRadidas]

NO COMMENT ! JUST gREATE !

[Romeodxb]

Great Job, thanks indeed.

[ifitl]

Simply Great. Congrats for this great help!! :D

[SomeUsefulVids]

I've stumbled accross these videos looking for some advanced tips and stayed to watch a few

excellent instruction videos very clear with very precise use of language and terminology so as to not confuse (some of the self proclaimed excel gurus would do well to take a leaf out of your book)

[doristang1411]

Thanks for your tutorial, how can I set the condition if the figure at one column (eg. column B) bigger than (might be 50) then that row should highligh to red color.

[gonewiththewind001]

Thank you so much for your wonderful presentations. I have just one suggestion: Could you speak a little bit louder please? I turned my speaker to max, and still, it is not quite loud for me. Really appreicated

[hiltongal]

You are the BEST teacher!!

Thank you!

[nibiru2012]

You rock!!!

[chocnuts08]

awesome! thanks!

[ashrafkamal1999]

Hi,

Good work

Keep it up

thanks

[evilchrist213]

your the best..

[Tonty53]

Interessante la formattazione condizionale.

Non mi perderò le prossime lezioni!

[atp260]

hi nirajrm and MotionTraining,

i guess MS have removed the floating colour palettes feature from Excel 2007 just becouse they have improved it: you just need to select what you want to format then drag the mouse over the color you want, then it gives you a sample of the result.

PS: you are a very good teacher!

[nirajrm]

Hi,

Thanks a lot for nice presentations....

I was wondering about the presence of "floating menu" for background colors and font colors in MS Excel 2007.

Thanks again.

Keep it up.

[MotionTraining]

Hi nirajrm, Sadly, I think that MS have removed the floating colour palettes feature from Excel 2007. Maybe they will bring them back in a future upgrade.

[airsoftcvb]

@MotionTraining Yeah I noticed that! too bad :'( why would you remove somthing SOOO useful?

[bumtrouble]

Thank you. Your tutorials are terrific. You're a great teacher. I was dreading learning Excel, and you've made it really easy.

[chpnac]

I wish people that are paying so much for classes can see your tutorials. I have absolutely no excel experience, but you style of teaching is making it so very easy for me to learn. Thank you and I truly appreciate it, I am on the way of watching all your videos, you are turning a beginner into and expert Thanx