Excel Spread Sheet Basics - Using a Formula

[xclmedia]

This excel formula is useful, thank.

[mBrooks95]

0:52

[deidara2512]

thanks lol,i missed my today's computing class,good thing i came to this vid :)

[office2012download]

Managed to crack office2012 and all this is not even in the new interface. So HAPPY :D

[pebbles1340]

whooooooo, THANK YOU.....now I can take this to my job and not feel so dumb.....lol

[supershelly4321]

very helpful

[sixfootlady]

WoW! Love You! Ha!

[bigrevkev55]

Thank you very much! 2:28-3:00 on replicating is what I have been looking for for a looong time! Finally!

[reyesdenise24]

I loved this video but I kinda got lost towardz da end. Still good though =)

[22Byrdman22]

awesome video!

[Babygingersporty101]

I love that moment at 0:55 when a killer came in your room lol

[shudukahn555]

OMG I LOVE YOU!!!!!!

[dirtyrice4ever]

thank you sir

[ALLeaseALLdayTUBE]

Thank you for this. you just saved me so much time. VERY HELPFUL!

[Aldoo97]

Much love, helped me with my computing homework.

[RHzk]

And I wanna say - AAAKKHEMM!!! xD

Thank you anyway!

[irishmoomae]

You are the only one to explain this quickly and and very easy to follow. Im trying to make a shopping list in excel using coupons etc. You just made my trips that much smoother. THANK YOU!!!!!!!!!!!

[chippy89]

THANK YOU 100 times

[adidsify]

@chippy89 thanks babby fuck u alot to enjoy u guy come on with me

[Mr88Charlie]

Thank you. I am sure it will help me ace my presentation today. It was a big help plus your explanation was crystal clear.

[manarK1988]

thanks allot it was very helpful .. <3

[e7venjedi]

One thing to add, this works for OpenOffice software as well, in case anyone was wondering. (thumbs up so other people can see?)

Very helpful! I never knew how powerful a tool this was for computing -- i can see why businesses started using this the moment it was invented. :-D I will probably revisit this again cuz I got the basics but it is still a lot to digest in one sitting :P Or maybe I'm just slow!

[hammudi90]

why dislike !

[nlawson2004]

Just to note:

In the second half of the video, instead of having to copy and paste in order to have the SUM formula applied to new cell entries, you can simply go to the EDIT preferences and look for "Extend data range formats and formulas" and have it checked so that Excel will do it for you automatically. Excel will know that any item you enter above the SUM formula wants to be added up.

[cqammaz53]

can you help me set up a spread sheet for my electric bill I'm thinking of putting in the useage, amount owe, paid, total amount owe as I'm om a budget plan so I'm not paying the full amount at the end of each mouth

[atill]

thanks so helpful

[maazi4]

very helpful for my job thanks alot sir

[firevid90]

omg the cough woke my parents :O

[penstealers]

this dude has a wicked cough lol

[AbstractDissonance]

I've never seen anyone get so excited over excel!

[gursingh30]

thanks bro it's helpful

[bluebird887]

Very Good well done

[veritycoxi]

thanks for helping us on our funtional skills exam even tho we shit ourselves in the middle of the library when u decided to cough full blast in our earholes. touch from the UK.

[easkilla80]

by far annoying when your cancer cough is noticed

\

[easkilla80]

you sound like a tool, when you cough

[FirstLadyDurr]

This is great! How can I add a formula for coupons?

[ERC22009]

THANKS SO MUCH

[POKERDEAL]

thank you so much for this thank you thank you!!!!!!!

[kmh1234able]

Very helpful thank you.

[TrainToPain]

THANKSSSSSSSSSSSSSSS!!!!!!!!!!­!!!!!!!!!!!!!!

[viborasolida]

thank u man that shit is fucking piss me off 

[Orf]

Thanks :)

[SergiuHellDragoon]

Easy ,Sure & SAFE way to make money on the internet bussiness 

watch?v=aUmqlP9Wtco

watch?v=aUmqlP9Wtco

watch?v=aUmqlP9Wtco

watch?v=aUmqlP9Wtco

watch?v=aUmqlP9Wtco

CONTACT US AT:

sergiu@moneyforsure.ws

We will help you,because giving you what you want I will get what I want.Just take a look at the website: moneyforsure.ws to make thing straight for you.

[wakelax]

Exactly what i was looking, This was so much easier than i thought.

[Dulces360]

Hey great video

[ZEINSTAIN2011]

good check my gear!

[mojiganga2]

THANK YOU

[GreatAmericanMoneyTV]

This is a reeeeally cool video. Why can't I find you on Excelville? With skills like that, you should be getting paid!

[PaulyJackson]

thank you...it helped me in my math homework=)

[sequeirajorgeluis]

Second 55 "Currency COUGH"

[asghar826]

this is very good effort for new biggners

[houba81]

i spent weeks, i buy a book but i didn't understand.

your way is fast, claire and with result.

thank you very much u help a lot

[annieplanet8]

Thank you Excel Master, Martin: Your lesson was extremely well explained and I liked the way you taught it. I am dyslexic and have a learning disability and flunked out of all me Excel classes because I am soooo slow. I repeat your lesson over 10 times and am able to absorb it very well. Please keep on making your Exel videos. From Annie in Los Angeles

[marjokate]

Thank you from Philippines...

[Man79ism]

Thank you from London

[HarrypotterHP7]

Thanks alot!

[taraandmike1]

Very helpful!! Thanks for taking the time to do this!

[taraandmike1]

Very helpful!! Thanks for taking the time to do this video!

[czannou]

Thanks so much!!!

[manolitomulat]

he coughed!!!!lol...anyway..thank­s for this video..

[somnolien]

kinda distracted by the cough. haha

[HalfLifeAMD]

Thanks you answered a question i had!

[dirtybone74]

Very helpful....Thanks

[CloverCATOREE]

thanks this is great! :P you had a pretty bad cold when you did this video though :P cute

[bigjim10011]

i want a formula where i can add a name like "linda" and every time that name is entered the box next to it is highlighted (or a special character appears). I need to do this for reminders of customers who have special requests.

[futureahmed87]

i need to learn from scratch so help out

[Mikelvnumber2]

Very nice help. I'm just getting into Excel and this was great. Thanks!

[fillspam]

thank you for the video, it explains a lot.

[Revolution2ful]

Thanks brilliant!!!!



[Ingridcont]

thanks man this was really helpfull! i looks like 14 people missed the like button!

[nectara77]

Thank you verry much ..kisses from Romania :)

[Gina0463]

I would please like it if you would do more on excel, powerpoint. You are very easy to follow. I took a class and droped out because I didn't understand one thing he was speaking of because he was A. a bad teacher and B. he was to fast. And if you have more on youtube please direct me in how to locate.

Thank You

Gina

[Gina0463]

I would please like it if you would do more on excel, powerpoint. You are very easy to follow. I took a class and droped out because I didn't understand one thing he was speaking of because he was A. a bad teacher and B. he was to fast.

Thank You

Gina

[leif29]

thanks

[Martin8567]

Thanks for the email buddy. really helpful. Martin

[shazdee]

Thanks for this video, I just bought Excel 2010 and have never used a spreadsheet of any kind before and it was doing my head in. This has been very infomative and made me reconsider tossing my pc through the wall.

[RaduBigGun]

Respect!

[Martin8567]

Very Helpful thank you.

Is there a video which shows how to delete the first coulmn withou affecting 2nd

I have converted from my cost price to my selling price and w

ant to email to my customer but i dont want them to see my cost, anything i try screws up my selling price. thanks again

[vhyndman]

@Martin8567 The easiest and safest thing to do is to select only the columns and rows you WANT to send to your customer, and print them to a PDF file.

Another way is to select the rows and columns, copy them (either control C or rightclick copy) and then open a new sheet and "paste special" and paste in the values, rasther than the formulas. Send THIS spreadsheet to him... it's way safer than most other methods.

[vhyndman]

@Martin8567 The easiest and safest thing to do is to select only the columns and rows you WANT to send to your customer, and print them to a PDF file.

Another way is to select the rows and columns, copy them (either control C or rightclick copy) and then open a new sheet and "paste special" and paste in the values, rather than the formulas. Send THIS spreadsheet to him... it's way safer than most other methods.

[Martin8567]

Very Helpful thank you.

Is there a video which shows how to delete the first coulmn.

I have converted from my cost price to my selling price and want to email to my customer but i dont want them to see my cost, anything i try screws up my selling price. thanks again

[spacemama]

You were making sense until the last 2-5 minutes when you got very caught up with copying/inserting and lost track of explaining yourself. That is a death sentence for anyone totally new to Excel trying to follow your thought/action processes. Otherwise, thanks for the illuminating lesson.

[Atgonzales03]

0:54-0:57 LOL

[aprilhobday]

thank you so much - very helpful and easily understood.

[advancedframing]

Thanks i never knew how to do formulas till you showed me.  Thanks Brian

[Genuina78]

Thank you so much for posting this..! It really helped me. So easy to understand! :)

[liveyliveb]

Yes Ill put the link up.. he has 15 videos I think

[liveyliveb]

Motion Training explains Excel much better and more clearly

[vhyndman]

@liveyliveb Might want to publish a link... Motion provides their training free of charge?

[vhyndman]

@liveyliveb Might want to publish a link... Motion provides their training free of charge?

[vhyndman]

@liveyliveb Might want to publish a link... Motion provides their training free of charge?

[fonsecafh]

@vhyndman some of the trainining is free but some are charged.Fernando /Brazil.

[darksideofthenation]

@liveyliveb

you are extreamly rude.

[JudgeJulieLit]

@liveyliveb Motion Training is good and clear (as is vhyndman's), but in UK English. Some of vhyndman's verbal shortcuts (as that we're adding "the two cells to the left") are easier to instantly grasp, less formal and stilted, more efficient. YouTube's various instructors each have their own unique helpful insights and teaching topics and techniques. The more the merrier. "All of the above" round a view of Excel, esp. in all its editions.

[TheLoFiction]

love it....has been very useful for me. doing an excel based assessment for uni and this was just what i needed. thank you!

[Diclety28]

pls have manners don't cough in microphone....

[szabo060990]

im trying to put together all available combinations of 48 dogs in virtual dog racing.. there are 8 races 6 dogs in each race.. so there for 48 dogs all together... the calculation i did to work out the number of combinations is 48 squared.. gives u a total of 2304 combinations over 8 races... but to write all these down is going to drive me insane i need some software that can organise this data for me and show me how to write them out.. hoping Excel can do this..Thanks

[vhyndman]

@szabo060990

OK... not exacty sure what you're trying to accomplish... although if you can help me a bit, I may be able to help you.

Is the purpose of the spreadsheet to record the races, or is it to somehow matrix out the possible matchings? I don't know how the race scenario works, so I'm a bit at a loss.

[crushonmika]

that's one hell of a cough you got there sir

[MrGazp77]

thanks for taking the time to explain many many thanks



[bazibaz100]

thank you

[zonebellond123]

cough sounds bad=/

[miketheblueeagle]

want some extra income watch my extra income video

[XGamerMadGirlX]

Im going to say COOOOOOOOOOOOOOOOOUUUUUUUUUUUU­GHHHHHHHHHHH too ;)

[bestofsevenrules]

must you cough into the fuckin mike.... rookie or what

[TheRobinD123]

coughing hurts my ears

[justadicu]

very nice explications, 10x man, you are great

[alimahadtheman]

God bless you

[turbokitty222]

Great  help Man I love u Have a great week

[chummybrooklyn]

AMAZING TEACH

[Doubleringer]

bless you

[aazanova]

Thanks so much you just saved me 87 hours of calculations

[suzan2khan]

thanks alot.

[elchamber]

LOL I just used excel for a Facebook game.

[bbhebe]

u sir shuld be my teacher... I CANT UNDERSTAND MY TEACHER 4 SHIITT

[sirrobotjesus]

Thanks alot!

[iflatland]

i like how he coughs to keep us awake. great tutorial!

[EscalanteFlyFlipper]

sweeeeeeet...saved me lots of study time on basics...cool

[sterling729]

Thank You Sir!!!

[brokenarrow2222]

i need an aspirin.

[ReebHound]

LOLOLLOL at 56!!!!!!!!!!!!!!

[sware454]

Cheers bud, saved me a lot of time!

[veryserioso]

What this shows is that intention and content is all important. The cough doesn't matter. Superb presentation.

[hunzukutz]

I am trying to have a cell empty if there is no value in another cell. I want to see if anyone can help me, if cell a3 is blank or empty I want g3 to show no value, just to let you you know that g3 has value in it. Thanks in advance

[vhyndman]

Use this formula in cell G3

=IF(A3,"YES","")

You can replace "YES" with any text string, or you could reference another cell. i.e. you coould put "YES" in cell H1, and replace "YES" with $H$1

[MrDongaaa]

ya its eay soloutionin formula write

iferror(b5*e5);0

its mean if it was irror or divo like when you substract any value at 0

then write 0 at solution at g3

[usermatt1]

Very simple, thank you.

[Hoosierdaddy32114]

Pretty comprehensive...

I myself would prepare 3 spreadsheets for a Camel! Next time, add a good hefty "THOO!!" after the cough, and some spittle effects on the screen afterwards...I WOULD!

[vhyndman]

I have had a special Windshield Wiper installed on my screen for the spittle. ;-)

[TheReincarnationFan]

hahaha great video to = great humor

[mazr2006]

THAAAAAAAANKK YOUUUU .. see how great is that ppl thanking you for your work. this is amazing and so humane.

[BabelaSweet]

THANKS...GREAT AND SIMPLE :)

[pixelshade]

Great tut! Your cough icw the sound quality sounds like a monster :D

[B1GMAC177]

Thanks Helped With My Homework!!!

[ouzodave]

Nice work. You need a cough formula though ;-)

[snaffalano23]

Long living Ledgend saved my ass from lots of work, thanks a lot for that and keep up the good work, greetings from

germany home of the Oktoberfest

[masterminekid90]

i still dont get it,can someone personally show me step by step.

[duskyhued476]

AMAZING!! THANK YOU,MAN!!!

[allain666]

Awsome man , lifesaver my homework needs to be given in tomorrow morning thnks you rock

[kga4real]

Sir you are best tutor for beginners like me. Thnx a lot

[chimpylove]

0:56 lol!!!

excorsist!!

[dodobear5]

lol also at 3:20

[kazla1776uk]

Cheers but do you have a cold?

NIce work tho

[peppinyostepp]

Your awesome thank u so much! Thanks for tutorial

[redfoxarts]

Can pls make an complicated formula?

That triggers another cell to do something or To Trigger another Formula something like that?

[vhyndman]

Yes... formulas can be "nested"...

ie this formula will add a column of numbers

=SUM(A1:A6)

but you can display 6% of the total in ONE STEP

=0.06*SUM(A1:A6)

You can nest MANY formulas in one step

[ThePathofHavoc]

Thanks for the info!! You just made my statistics class WAAAAY less time consuming.

[Schrodinger12345]

great video man !

[EccentricPeanut]

I LOVE YOU

[bernardolea]

nice job,..better than my professor,..

[14309981]

very nice videos for new to excel thanks

[Pester09]

Buen video gracias.

[mtallmen184]

Don't watch this, go watch USMSCI's videos nyu! THEY HAVE DEATH NOTE NYU!

[AznHeatOfDa617]

tyvm

[apsjr1]

sir,

thank you for everything i just made a grocery list formula to help me with my budget thank a lot man

[playstationowner]

THANK YOU, YOU ARE A LIFE SAVER.

[namanpotoh]

Wahahaha video failed cough wins!!

[adamnaughty]

thank you so much your such a great teacher you made it very basic n easy to learn .... you made it so easy

[FrankAdriana]

Thank you for the explanation!!!!!!!!!!

[mmasterp]

i like the video. but what the heck was the noise at :55? =p

[thirthyest]

easy&quick excel

it's a dream come true

:)

[tassop69]

Great Video, I am new to excel and this was an area that i was having trouble with but you have saved me a lot of stress.

ha ha

[volt678]

heyy thank u alot ..u really helped me !!

hope u get well u tired lol :P

[migintusr]

awsome easy to understand, Thank you

[m4cklove]

thank you very much sir

[heyloudawg]

thank you thank you thank you!!!!!!!!

[david7423]

thenk you so much, so clear and so to the point, you made up a very good teacher

[spearmintmonkey]

Very nice, Thanks..

[j1j11j]

Thank you - veryhandyman? I recently inherited the treasury duty of a group with a small budget. Though it would have been more simple and appropriate to have done it on paper it came to me as Excel. Your video has enabled me to set up a similar Excel book for a 6x more complicated job. Thank you recognizing the need for and implementing a fine presentation these basic skills.

[queenie0106]

hahahahahah your cough scared the shit out of me. but thanks, very helpful!

[Djslim46347]

ok in my SBA i have to do things like what u did in this video the next thing i want u do show me (if ur not busy) example lets say am typin a letter to u but i want to send it to more than one person how do i just change over the address and stuff in just one copy understand what i mean?

[Djslim46347]

Dude thanks man u just helped me with my SBA can u show me how to merge a file and the other things u do in information technology plz if its not too much