Microsoft Excel Tutorial for Beginners #5 - Number Formats

[cschmiedlechner]

275k views and only 600+ likes? c'mon a like is all u have to pay for this free amazing tutorial!

[cervantis1]

thanks a lot for the tutorials, really helped!

[kelvynjayy]

Great... Very helpful and well explained....

[shinvergil777]

These Tutorials are really great and helpful. People like yourself are a good reason to go to youtube for something that assists others not just for entertainment.

[Holyboy1978]

Blessings multiplied to you my friend... It is nice to others give back... You the kind of person that will help others want to give back as well.. Thanks again.

[trulakesho24]

i love this dude i wish teachers were as good as he is at teaching good job

[zhouxuan21]

Question: What if the amount is a negative number, say, you're calculating the profit/loss? It seems when using the Accounting format, Excel makes a negative number look like $(100.12), which looks kind of weird to me... How could we customize the format for a negative number (with the symbols like "##_0") ?? How do negative numbers usually look like in such tables?... Thank you so much in advance, Mr. MotionTraining! :)

[granma40]

Thank you for this. I am just learning this and was totally confused until I found this site. God Bless You!

[JuTuubi]

I'll need excel in my work and I was kind of getting worried about that but after checking these videos = problem solved. Thanks a million times! :)

[TheYanni1978]

YEA DIS IS THE BOOM

[ThePupidarko]

THAAAANKS A LOT !!!!!

[lubzilulusai]

i dnt kno hw to express my gratitude...u r an amazing person to hav made these videos....god bless u friend... ur accent is gr8 nd the way u explain evrythng is jst amazing...blessed ur... thnx a million...

[EddyC123]

Great tutorials, but there are a number of methods to reduce noise, especially speaking/saliva sounds, would be even better if they weren't so prominent in your recordings.

[skfarkowski]

@EddyC123 honestly mate.....!

[EddyC123]

@skfarkowski yes?

[Arazadia]

This is so clear and easy to understand. Thank you so much for sharing it with us all!

[victimofsleep]

where is the format painter in excel 2010?

[cristian692012]

thanks for your free lessons they helpme a lot

[ivan22957]

even for a personlike myself where english is my second language it sound so easy to understand and your accent is just the best i´ve ever heard. keep going

[poonmcnugget]

A job recently reviewed my application and told me that experience with excel and word is a plus! I hope this helps.. Thanks! @MotionTraining

[bcwemployment]

8 People clearly must be mad at the world and should seek psychiatric help. This is by far one of the best tutorials ever! You sir, should be or are a professional instructor. Thank you again and keep things like this coming!

[jsg262]

These tutorials are fantastic! Thank you so much. Now I feel like I can start applying for jobs that require Excel Experience. I'll keep learning more and more, and by the time I'm called for an interview, I should know enough to get by.

[powerpia2000]

You are such a good teacher

[AIONBERSERKER]

eww nice vid

[djgioalvea]

im learning a lot! very helpful..... Thanks Motion Training. im your fun now!

[noura88]

<3 I Love You <3

[annarell786]

YOU ARE THE BEST TEACHER. THANK YOU FOR SHARING!!!!!!!!!!! I LEARNT ALOT :)

[313pookie313]

@annarell786 - great! Now find a teacher who will correct your grammar usage!

[RMLEE77]

I completely agree!!!! I'm not very good with computers but you are making it very easy for me to understand everything. It is such a relief to know that I can finally understand what I am doing!! Lol. Thank you so much for your help!! You are AWESOME!!!!!

[mgang4020]

Wow, I have learned something new with each video I watch. Great job, and thanks for creating these wonderful videos!

[tvrtkoticinovic]

Thx,great videos

Oo

[shaylamarie23]

on 2010, in the comma formatting when i clicked the comma all the numbers went to ####### but if my arrow went over it, it would show the comma format that you have. idk if thats like a new addition for it? or if i'm doing something wrong! id appreciate any help if you can ty!

[LanakristyDesigner]

Your teachings are incredible. Thank you for sharing this !

[seeyousoonbaghdad]

oh my god i never thought that learning Excel is that easy, i've tried books, online classes and nothing was as good as your way of teaching, i was watching your video one after one , since i woke up, oh my god you made my day a waonderful day, i have learned alot, thank you so much for this gift, God bless you, you are an angel ,^^

[mikekukas]

Can't belive how much paper, money and time is waisted on training books and a 10 minute video beats them all. Stupid world we're leaving :(

Some produce useless garbage and others are buying it, than it all goes to waste like so many other useless things from the consumer's society.

[xadam2dudex]

what version of Excel are you using ?? mine is different

[seeyousoonbaghdad]

@xadam2dudex mine is differnt too, but if you look up you will find the tools just in differnt places,lol

[marsillante]

thank jou very much now its easy to learn

[EasternWind29]

I have spend a lot of money on books trying to learn it by myself, but it was too hard for me and I found your Excel video so easy to understand. Thank You very Much!!! You're a life saviour~~~~))))

[EasternWind29]

You are very good in teaching excel. I don't know anything about Excel so bought some books to learn by myself, but still can't understand at all. Your video make it easier for me to understand. Thank You Very Much!!! ^^

[rachle81]

These are incredibly helpful...thank you so much!

[aherna9557]

I would like to thank you very much for these very informative videos. Like FreddyKay21 I've saved a lot of money by coming here to learn excel, it's been very helpful. I just started, so I take notes, I go on my excel program and practice what I'm learning here. Excel is one of the programs that came with my computer

but I had no idea how to use it.

[malcorn4]

I do hope you reap plenty of benefits from making these videos available. They are wonderful tutorials.

Thanks.

[smartboy140597]

can u tell me what version of excel is that? thx

[tigerskittykat]

Thank you for sharing your skills. I am unemployed and I don't have extra funds to take a class. This has helped me improve my skills tremendously!! Thank you! Do you have a training on powerpoint?

[Friendsshare]

I am very immature. @ the 8:51 mark, the selected columns seem to look like a blue elephant's trunk...teehee

[SuperRASPOTIN]

well, i hope so so many peopl are take this advantage from you,.that u help to

so many people traind here and got job,. we are pray for you,. u are so excellent

and vry good teacher,. i personaly i request for this teach he so nice and good man

who helps lot of people., God bless you,.

YOUSEF RAJA UK

[SuperRASPOTIN]

well,. this so nice amazing teaching excel i am so happy to learn,. even i donot use or somehow it so nice way to teach these lessions,. many thanks nice rythem and

nice procdure to teach,.

yousef raja uk

[fido6297]

u are a natural teacher..

[mjowsiany]

thanks dude, you make everything seem very easy.

[jasminsolis]

i just came back from an interview.. and when they asked me "are you familiar with excel" i said.. yes.. of course i failed..:( and now i realize that its so easy! thanks to you ! yay.. sometimes you think you know but you don't! but thank you now i do! :)

[gerardkambing]

@jasminsolis omg me too!! i told em i was "good",so they asked me to demonstrate my skills. i cant even multiply the numbers. so embarrassing!

[manolitomulat]

its very helpful..thank you so much

[nts87]

Very Nice teaching way Keep it Up

[aleksa94777]

man,thank you so much :DDD

[shopaholic1]

Hey, thanks so much for this. I passed the excel test after watching your videos and got the job because of you. You are a God sent and may God bless you..

[JHakaJoeVanni]

More tutorials need to be like this! Easy to understand and well taught. Great job!

[oranpier]

Your teaching is just amazing. So easy and simple to understand. It was extremely helpful. Thank you so much.

[goflamesgo96]

thank-you so much for all your help...your a God send!

[dvndiva54]

This is great I can not believe I can now do a spreadsheet just from these video tutorials . Very easy to follow and understand.

[twix2580]

great work. man....keep it up. you will be blessed more and more...........

[elliethousand]

This series is a real godsend. You are providing a brilliant service, thanks!!

[usmanadnan]

thanks man u just rock

[vizintez]

@usmanadnan My best friends name is Adnan and you said exactly what he would of said......to this excell ent tuter.....you rock, are the words of the Adnan's.

[beautiful20106]

what year of this excel? is it excel 2008? is it the same with ms excel 2009/2010?

[halfn0te]

british accent are always ideal for narratives and tutorials.. very good to the ears and the speaker himself has good transitions. thanks man.. i am watching all ur vids for my promotion MOD exam. thanks alot.

[Dknutzen]

Thanks very much for helping me to save money and time to go for Excel classes in an evening.Atleast I can now stay at home with my kids and learn from you.

[waseem336]

genious person like you makes dumb people like me inteligent .... thanks a ton brother

[chabovic]

Thanks for a great yet simple tutorial for the best price in and out of town! By the way, when you took away the decimals on the numbers you took awat the decimal on the average of the rentals too!

[riah1977]

I listen to you and its so esy to learn from you

[kamikim1]

i m watching ur whole series though i m not a beginner but also not a profesional .u have made it look incredibly easy ,u r awsome i m looking forward if u have any other series other than beginners ,

i have no word for u but great

[Jane10395]

it is so good of whoever is sharing this knowledge. This has been so much help for me. thank you whoever.

[MrChiragm]

You're really great, the world needs more people like you. Your voice, camera work and presentation are fantastic. Thank you very much.

[purpleshuang]

hey thanks a lot! your tutorials are very engaging and not distanced at all...:)

[SonnyLodi]

I have to agree with all the positive reactions been given to you. Your voice is pleasent and easy to listen to. Thank you very much for being so helpfull.

[bottlencork4u]

God bless you for doing this! I'm starting a business and need Excel for banking and inventory uses. Your camera work and voice are both great. This makes learning Excel so much easier....

[diesstro]

thx

[diggsmiggs]

Awesome! Thanks! People who help, like you, make this world a better place.

[sim0332]

gud present. . .

[ManceRaider]

This is great stuff, learning made easy!

[willmackay]

Thanks for your time man... I think i'm turning into a geek!! Great teaching style, you make the learning process fun and simple. I'm now looking at my accounts figuring out what i earn on average per day... Is this good or bad news?!

[revandd1]

thanks for you vids

[doppelGR]

thnx men ... ive learned a lot too... damn it is so easy .... good job....

[yolyduran]

Brilliant! Thank you for taking the time. You have pleasant voice as well.  :)

[komisobaba]

Its 4.47 in the morning and you are still keeping me glued to the screen. Thanks for your help. You are great!

[Rosesnails]

Thanks A Lot man,tomorrow I have a job interview and I´ll have to take an excel exam,I wasn´t really into it and now,thanks to you,I´m sure i can take that exam without any fear.

Thanks man.Best wishes and Peace.

[ggefh]

Thanks again,

x

[fahadsaeed50]

What a great video

really help me

thanks for uploading

[FreddyKay21]

Wow man, i was gonna spend 200 Euro for an Excel seminar! thanks for saving me the money!

[simpleman2423]

@FreddyKay21 The person you were gonna pay 200 Euro to is the person who disliked the video. heh

[Brillianceinthemakin]

You are amazing..I cant believe how easy it is to use excel..I've learned 1 1/2 hour

[CapitanoGUC]

@Brillianceinthemakin thats cause this tutorial is in proper english and not some american chewing gum sound ...:-D

[TheDoRaEMY]

I really learn something from your video!!!thanks a lot!!!!

[kingodyxz]

good teaching,,,thanks a lot ^_^

[vnin2012]

You're the best at teaching. We have so much confidence after watching your training. Awesome!!!!!!

[jsprincessrue6]

you are the best!

[stolencurse]

Thanks these are great even if you do know basic excel thanks=)

[ernestomck]

Very helpful, thank you

[pein417]

aww man i stayed up waaay past me normal turn in time to watch all of these thanks a lot man. big help. I've got an excel assignment to turn in tomorrow. and thanks to this i'm almost through.

[jjlljjll]

It seems that 90% of the people leaving positive comments are swatting at the last minute for a job interview the following day. Count me among those unfortunate individuals. Your video has been a massive help for someone like me who "exagerated" their Excel skills on their job application. Cheers!

[bpcjigga]

You really are doing a service with this video. Thank you so much.

[rjanemj]

This Video is really great, I really learned a lot. Thanks so much man, whoever you are, you really are a big help to me.=)

[kitten1719]

You have been a tremendous help.Thank you so much.

[sonjac59]

This is so GREAT! I can't thank you enough for "tutoring" us!

[cesztoszule]

well can u help can be a way to have a colum to have 2 functions at the same time? i give an exampla Fcolum F-E and F+D when i type in any E2->E20 and i have a number in F2->F20 they should substract and when i type any number in D2->D20 they would add to numbers in F colum i dont know how to do it and its for making work easyer :(

[muss212]

great work buddy, 5/5

[kanizeraza]

This is good

[Cheekyangel28]

Thanks so much for the information, I was willing to sign up for a class to learn excel.. Keep on the good work..

[onlyravian]

hey thanx buddy.. i think this is the best way to use the youtube..and you are doing just that...Best wishes for you..

[luciferakathedevil]

Awesome mate. Ima rock & shave ya balls ya hear me!!!!!!!!!!! ahahahahaha

[DangeRadidas]

THX A LOT !

[ozluvrob]

You thank us for watching, the thanks all goes to you. THANKYOU

[ewanq0h]

could you make a vid about database??? i mean access???? please

[aopscrubs]

You are so hot! Thank you!

[Boonorp]

flawless!

It's a pleasure to learn Excel this way. I hope to find such great tutorials on the rest of the office programs too.

Thank you for posting!

[nick88999]

this mans my nigga, saved me wit my test today

[marwanomar]

ahaha i feel you he is mah nigga too

[fabian1868]

thank you very much...it was very helpful

[mitou1616]

Very Useful Again Thanks! I use your tutoring all the time

[Khufu11]

Who needs evening classes when you're loose on youtube?! :D

Awesome, cheers!

[john12332101]

Thanks a lot..the tutorial was very much helpful...

[BigOldDirtyBastard]

I hope you will be happy for the rest of your life.. THANK OYU

[capdeelite61]

Thank you so much.

[rosez2011]

you are great , god bless you

[evie3451]

Your tutorials are fantastic. I even joined youtube just to thank you... So, thank you (very, very much)!!! :)

[Tonty53]

Dopo questo quinto video sono "quasi" un esperto eh eh eh.

Sempre così!

[hypotz]

Ur gr8

[waldo795]

geat Video thanks again

[heavalina]

wonderful.....

[camskater6]

its nice

[eyadvi]

thanx alot