Microsoft Excel Tutorial for Beginners #4 - Functions (Formulas)

[FocusResult]

Thank you so much. You saved me lots of money and time.

[Duskgale]

Soooo Great!!! thanks :)

[SirTripmeister]

MotionTraining for president!

[xristos1200]

thank you!!! :)



[somiomer]

very useful , thank u for uploading

[madil45860]

Thanks for uploading this very useful material for beginners. May God bless you dear live long.

[TheBananalolz]

5 dislikes? Nice try lotus123 :D

[TheBananalolz]

Thank you dudude! This toturialz helped me very much! :D

[71579musiclover]

Thank you so much. This tutorial helped me sooo much.

[Moshirobl45]

:D thanks !!

[abadchoice]

Thanks for this tutorial - really useful.

[sharp887]

TY I agree w/everyone else's comments. Thx so much for taking the time and sharing your knowledge with the world:)!

[edwardyoung2480]

I really love this series of tutorials. Is there a test at the end so that you move forward knowing you did ok? Val

[geologisteagle]

How can some one dislike this hardwork? Excellent teacher you are!

How can some one dislike this hardwork? Excellent teacher you are!

[azike1987]

thank you very much indeed! very useful!

[gamesforsho]

I wish all teachers would teach us like this instead of beating around the bushes @_@

[hdo697]

Thanks so much for uploads! you explain everything at my speed.

[nothinbutgreenlights]

you sir, are the king!

[zw0ecool]

@nothinbutgreenlights why don't you just give him a handjob and save us the stupid comment.

[nothinbutgreenlights]

@zw0ecool Im not sure if the guy would appreciate that, propably not, but, "stupid comments" that show my appreciation for someones effort of making and uploading a series of useful tutorials for the benefit of others, is what seperates me (and others like me, of which there are scores if not hundreds on his videos) from the asinine, vacuous, and needlessly insulting comments that clowns like you seem intent on passing on other people from behind the anonymity of youtube. Grow up.

[zw0ecool]

@nothinbutgreenlights Looks like someone has been reading his dictionary LOL. You called him king, you may as well just blow him, get off of his nuts.

[nothinbutgreenlights]

@zw0ecool I'd write this guy a sonnet if I was any way poetic.

[mtnbike256]

"I have no idea if that's right but I trust Excel." :)

[Heartaken]

you're really polite, i like that ^^ keep it up with ya detailed and excellent vids~

[morghath]

excellent thanks nice pace

[87namqul]

This is why I love Youtube. Learning for free.No contact with humans. Easy repetition.

Thank you very much to uploader.

[9iine]

thnx for teaching us excel .. !

[vkickasses]

Hi, just had a quick query - to see if I understood correctly. The video used the paste function feature to find out the average for number of rentals and incomes. Could it have been done by simply dragging the earlier calculated cell - average price? (from the bottom right of the cell). would appreciate the answer either by the video creator or a viewer..

[pyrozvanipile]

@vkickasses I think he's trying to show all posibilities for doing the same thing.

[Dmr2acorn]

omg tanks sooo much lolololololololololol nice teachings! now i know how to be smartz >:D

[Laohouzi100]

Thank you so much!!

People like you making the world wonderful!!

Thank you again!

[enriquecalleros]

OMG u saved mi ass

[mrtube1]

Hi, thank you very much for these tutorials! they are excellent and are really helping my understanding of Excel!!!

[swatiramesh]

Thanks for excellent tutorial guide...indeed best use of youtube,and thanks for your efforts to teach millions through this media. awesome! just went through 4 tutorial its very nice and easy to learn.

[papantera]

Hello,

How can I make the A section in alphabetical order??? I learn a lot thanks again!

[Iseeangels1]

You have just given this 56 year old, ready to reneter the job market, a true gift. You have the best tutorials and I am grateful you share with so many people. Much Cheer, Many Friends and a Calm Life to you.

[techraan]

I'm a high school comp tech teacher. I'm using your videos to prepare for each class. Many thank yous for doing this.

[amosnews]

A perfect teacher - A brain like Einstein, patients of Mother Teresa and a voice like the Geico Gecko.

[Iseeangels1]

@amosnews Yes to all of the above -- the accent is a caveat!!!

[7mazenaHenrija8mog]

awesome! thanks!

[rinaldiputra]

for the categorical data ie (yellow, red, green) is it possible to arrange it in alphabetical order without manually doing it by hand and thanks for the upload it was mighty helpful !

[Piperslover]

Absoultely Awsome! I'm something of a novice computer guru.I'm the one all my friends come to with their computer issues begging for help, but for some reason Excel was always my Kryptonite. No longer after watching through your guides a few times and commiting this to memory. Thank you so much. I even tried Excel for Dummies and it can't hold a candle to your guides.

[MidgetMyers]

I have just watched 4 of your videos, and found them really helpful, thankyou very much. I will be using them in my new Job

[ShahrazadOFbaghdad]

Thanks alot ... your videos saved my life !!

[moonmasterShake]

Excel made easy baby, I just scored a new job out of watching these tutorials thank you so much my friend Subscribed.

[CheriesBling2009]

I am presently job searching and have not used excel in several years, The job I'm trying to land uses this program. I am presently unable to take courses on it to refresh my memory so I am watching all your videos today. I go on my 2nd interview tomorrow for this company . I feel I will be more confident due to your wonderful videos, thank you in advance for taking the time to help so many people.

[Yumi78227]

Thanks for the info. sir . This Video is very helpful . . . 

[HeatherEV]

Thank you so much for these! They're SO informative!

[iljimae71]

I agree..the best excel tutorial on yuotube..it helps me a lot!

[SuperRASPOTIN]

WELL,. i am agree with tramietyzed,. that who performed or orgnized the

tutoral excell or teaching thses lession,. so nice i am so happy and i am learning

everyday new lession verygood i hope so it very useful for everyone,.

once again thanks( you are so nice and good teacher)

YOUSEF RAJA UK.......

[somnolien]

thanks!!!

[manolitomulat]

you are a very good teacher

[fonsecafh]

Thanks for all these videos...i am getting used with this program.I have to be ready for a excel test in two months...i mean...i will apply for a job.Please pray for me .

[jchb48]

You sound thirsty...which is a little distracting. Other than that. This video was very helpful and informative!

[t4c4]

very good turorial, thanks!

[darknessdel454]

666 Lmao!

[avugar]

this video isnt working getting paused automatically

[573733]

You are the best!!! Thank you so much. From Russia with love )

[alreet76]

Great tutorial, many thanks.

[donquixote76]

very nice way of teaching

[ilovemangos70]

I love the accent. Makes it sound so proffesional. ;)

[ViviLaLovesMusic]

What does count mean? I don't understand how 6 was developed.

[NYCEmpire]

@ViviLaLovesMusic If you COUNT all the movies you get 6.

[ZeroTheNinja]

Thank you so much for posting these videos. You are very thorough in your explanations, and I really needed to learn this for one of my college classes. I appreciate the time you take to help people like me out :)

[youtubfather]

great video but your gum chewing is bit distracting

[NYCEmpire]

@youtubfather I was wondering lol

[jemak4123]

great tutorial and the accent, it's priceless.

[sasha1025]

This helps me a lot! thanks so much!

[BlushingMocha741]

Is there any other way to do the average because the feature on your tutorial don't work for me? Can't find the paste function or the statistical.

[MotionTraining]

@BlushingMocha741 Hi. Which version of Excel do you have? The features in this video should work in all versions. There are other spreadsheets that don't work the same way - like the one in Microsoft Works. For example, the Average function in MS Works is entered as =Avg instead of Excel's =Average.

[BlushingMocha741]

@MotionTraining I have MS Works. I'm going to try it again and see what happens. But what about the other functions that I have to find. I only have one toolbar going straight across..no (fx) or center etc....

[MotionTraining]

@BlushingMocha741 Hi. For help on using the MS Works spreadsheet just Google 'MS Works Spreadsheet' and look for zisman on the first search results page. I'm not a user of MS Works so I can't be much more help. Hope you get it working OK.

[MidgetMyers]

@MotionTraining I have just watched 4 of your videos, and found them really helpful, thankyou very much. I will be using them in my new Job. And I strongly agree you are the best excel tutorial on you tube. Excellent will reccomend.

[sharonree2008]

THANK YOU so much for this...I'm a MAC user and haven't used excel in over 5 years...this is excellent.

[Femicide09]

MotionTraining, when finding the max, average,and minimum, I use the "Autosum" feature instead of doing it manually or using the auto paste feature. Are there any flaws when using the autosum feature? Such as any miscalculations? I'm just curious why anyone would use the autopaste/manual feature if the autosum feature is so easy. Thanks!

[MotionTraining]

@Femicide09 Hi. In Excel 2003 & 2007 there is a drop down menu on the Autosum button that gives you quick access to the main functions (average, max, min etc) which I'm guessing is what you refer to. This tutorial uses Excel 2000 which does not have that feature, so I show the other ways of creating functions. But the main thing is that they all work just the same and they all give correct results! Thanks for the question.

[Femicide09]

@MotionTraining Oh I see, I was a little confused why you didn't use that feature. But thanks a bunch, your videos have helped so much.

[meherreena]

best of all the other tutorials.. Thanks a lot..

[SuperMrsnina]

You re the best ! Thank u very much !

[CelticSong]

I do not have much computer experience. This tutorial is a God send. I'm greatful for your time and expertise! :)

[raredunks]

forget school lol this guys is man

[Slayvemast0r]

You win at Excel

[666pikachupikachu]

Excellent, thank you very much !

[spy27us]

thank you

[missholly1981]

Thank you so much for these tutorials. :D

[richardhamilton250]

you're an Excel god ! ...

[BlackRoseOrder]

I never focused when i had that in school,looks like it wasnt too much of a mistake since i can become a master in 1 hour xD

Big thanks to the author, doesnt seem like i'll have any problems with excel anymore :]

[Cxeri93]

gets harder and harder for each tutorial.. :D

like it,, XD

[weiwei6969]

very good, keep up your good work!

[ibrarrafi]

execlent.. u dnt know how u help me.. GOD bless u.. execlent..

[sobawear]

BRILLIANT!!!!

[Miggo15]

lol here in sweden we learn this in school :P

[lunteren2007]

@Miggo15 I think a lot of countries teach this at school, but most people forget this after a while.....

Anyway I thank this teacher.

[Miggo15]

@lunteren2007 I still have it in my head..

[MrUhuhunautifyify]

That,and only that...LOL

[Miggo15]

huh.. you gotta be very smart if u wanna lern this.

[zombarak]

thank you so much...so useful

[wictro]

heh, the short version of chapter name in the right column was "Microsoft Excel Tutorial for Beginners #4 - Fun.."

but nice lessons !

.wic

[Paolo7219]

Well learning Excel IS fun, isn't it? Heh.

[elghtk]

Your tutorials are the best I can find on Youtube!

Thank you so much! This is very useful for all excel beginners like me.

You are a brilliant excel teacher. Thank you again!

[jacquelineashlie21]

Very Helpful indeed.

[didprice]

I rashly applied for a job earlier which requires a knowledge of Excel. I had never even heard of it before then.

No problem, I thought, I'll look it up on Wikipedia. I couldn't really grasp what it was for there.

Then I had a lightbulb moment - YouTube!!!

I've watched your tutorial up to #4 and I think I am now an Excel expert. You are an excellent tutor - everything is explained in crystal clear terms at a nice pace and recapped.

Brilliant work - thank you very much.

[ggefh]

Nice One Squirrel

[DahakaGR8]

Very useful and comprehensive sir

[fahadsaeed50]

What a great video

really help me

thanks for uploading

[SingHouse]

Episode IV of Excel Tutorials - A New Hope.

[sar1428]

Love that formula copy / drag feature! The best! ;D Love these tutorials too!

[ALUtoo]

Thank you again. I have found your tutorials most effective and will refer to them from here on in.

[ImpactPCF]

Great work! Thanks alot for this :d Keep up the good work!

[TheAppleOrchard]

Yes, you have been great with these tutorials. I have a career opp. this week and you have greatly refresh my thoughts. Thankyou!!!

[yoyolove63]

btw,,you sound like jason staham

[ociana]

This stops at 4:42 for me. Wonder why?

[ImpactPCF]

You probably lost internet connection... :s

[tramietyzed]

you are the best excel tutorial on youtube. thank you for your diligence.

[ewanq0h]

can you help me with this?????

i want to compute 5 numbers from c3 to g3 then i want to divide it to 100 and multiply it to 25%.....

how can i do that computation?????

[colinstienke]

hell ya you rock man thanks an lot

[lowersky123]

thanks man!! its been a great help and blessings. you doing a good job. bless you.

[elpajaro21]

thank you very much to you.

[Jewellery023]

tanks a lot. this is very helpfull..

[ernestomck]

AWESOME. This is a great tutorial, thanks for taking your time to share your knowledge worldwide. God Bless u

[ernestomck]

Thank you Fred, the tutorial has been very helpful.

[danceotheart]

What a pleasure it is to view this video. It is concise, well-formatted and presented in a clear and logical fashion. Thank you very much. You really know your material and you have a gift for instruction!

[lady2342002]

Thank you so much, it is easy to understand.

The best Excel tutorial.

[abbuahya]

thanks a lot it help Godbless

[catwis1]

thank you so much this is so helpful and easy to follow! :)

[rajthakker]

u just gave me an erection with these formuleas

[janebakken]

Valuable for refresher on Excel; appreciate increasing size for easy follow, and of course, accent increases learning 10x's!

[droid4u]

Thanks for uploading all this. your the best.

[Rossbert777]

For the past 15 years I thought I knew Excel and you have already taught me many things I never knew were possible. I hope to breeze through the Temp Agency tests now.

[MsBrittbratt]

yes those temp agency tests are tough lol

[Deepmotion2633]

Thx 4 the Tutorial

[anil129]

Thanks for the video.

[ta1mno]

thank you. I can have computer degree thru your piece

[jakho19]

straight forward, good pace, easy to understand. Volume is a bit low though

[MsWarren12]

Great stuff the best thank you

[MsWarren12]

Great Tutorial

Clear easy to understand when are we going to get the next set of tutorials please

[heartbeatscience]

The Best Tutorial!! Thank you!!

[irisaccord]

I also want to thank you. This is the best

[gogoasacenusie]

This is great 10 dude!

[sheyshey071085]

thanks a lot

[Underxman]

THX a lot

[Ganeimama]

Thank you...you make it sound do easy!!!!

[wulfgang66]

Bravo! Informative, concise and very well presented.

Tip of the hat to you, good Sir!

[elfinlore]

i <3 you motion training person! =D

im only on tutorial 3 but i already made my own spreadythingy. haha! perhaps other questions would be answered as i view the other vids. hopefully *crosses fingers*

[Metrofabelectric]

This is a very helpful tutorial to many excel users specialy for beginners like me. Thanks a lot. More power.

[DangeRadidas]

GREAT !!! THX A LOT ! Tomorow i have an exam

[glengibson1973]

Hope you are paid well.

Glen Hull England

Great Tutorials

[00206666]

Just wanted to stop by and say thanks for the helpful tutorial videos.

Simple

Easy to Learn

Very Handy

Thanks Alot!!

Houston Texas

[filipinoincanada]

tnk u

[scrowl92]

Oh My Goodness!!! These were sooooo helpful! im actually taking a computer test tomorrow and excel stuff is on the test so thanks!!!!!

[mlpcah]

GR8 JOB

[dontask01]

thankx, you have been a great help for preparing for my interview. luv you for that........

[WatchMovies24]

thanks for the docs and accent

[DevenMin]

Love your videos. It helps that you have my favorite accent in the world :)

[lankasss]

Thank you so much!!! this is so good. God bless!

[fijoan]

THANKS ALOT!!! I've found your tutorials to be the most informative and easy to understand.

[redpacman45]

thanks man.. you helped me a lot..

[kytanokyle]

U could drag the cell from B11 to D11 at Max,Min,Average and Count(movies)it's much easier :D)) ...Thks u very much for tutorial, cheers

[shadowspeeding7]

this is really awesome of you. thanks.

[statoilx]

thank you

[coolheardted]

Really appreciate the help!!!

[allsinginganddancing]

Really good and really helpful :)

[Covayes]

thanx a lot.

[hornets87]

you're my hero

[BigOldDirtyBastard]

Thank you zillion times

[nukaba08]

Very helpful!..Thank you very much you're helping so many people

[jopeachez]

You are a wonderful teacher! Thank you! With your help, I am going pass my exam!

[Tonty53]

Al più presto cercherò di mettere in pratica quanto appena visto.

Ben fatto.

[canadaonly2]

great, thanks

[javi026]

Thanks man really appreciate the help!!!

[bumtrouble]

Thank you. You're a great teacher. (from Australia)

[diesinuebe]

thanks

[betapinedo]

Thank you. I will be ready for my interview. Thank you thank you

[amcon168]

Thank You!!!

[alizulfuqar86]

superb! please keep going to explain how to do

[115apollo]

TOP MAN!!!!!!!!!!!

[eyadvi]

thank you so much

[much2many]

thank you so much!