Tutorial - Excel 2010 - 10 Things you must know

Поділитися
Вставка
  • Опубліковано 6 січ 2025

КОМЕНТАРІ • 993

  • @marinapacheco3858
    @marinapacheco3858 9 років тому +43

    Thank you so much for this video! I started a new job, and although I never said I knew excel they assumed I did.. I sorta just "winged it" got a spreadsheet done, and when I came home was stressing because of how little I knew. Thanks for making this video! I am now pretty confident I can handle it! Thank youuuuuu!!!!!!!!!!

    • @jeyrodgerzmiller9119
      @jeyrodgerzmiller9119 9 років тому +2

      same boat

    • @Falconbase1
      @Falconbase1 9 років тому

      +Marina Pacheco by Friday, three of us, BABY!! Thanks for this video..sex, six...yes, we are awake.

    • @joshuadarcy4520
      @joshuadarcy4520 9 років тому

      computer sciencr

  • @teenu6782
    @teenu6782 10 років тому +1

    Hey, this world needs Teachers like you. You explain everything so well-to the point and the best part is your sense of humor.....I am pregnant and learning excel and m loving the way u teach. THANK YOU.

  • @amandasousa2293
    @amandasousa2293 9 років тому +22

    Hi I am from Brazil and I want to say thank you!! It was really helpful:)

  • @TheMano03
    @TheMano03 11 років тому +1

    Ditto to Gina's comment -- I haven't used Excel extensively since college, when I took the Microsoft Office class and need to learn Excel in a hurry for a new job. This breaks down the basics in layman's terms that makes it easy for even me to understand. You're awesome, dude -- keep doing what you're doing as it's much appreciated!

  • @wreckdizzle556
    @wreckdizzle556 11 років тому +30

    Thanks much, i actually got a job because i learned through this video.

  • @saturnwonder
    @saturnwonder 12 років тому +1

    I am applying for a job that requires me to keep track of when what planes come in for service and when they leave, so knowing the basics of Excel is required and this has made learning it so much easier and simple as well. Thank you very much for this upload!

  • @MattBCnR
    @MattBCnR 9 років тому +9

    Very Well made, will test some of this out when I get a chance. Got a Collge- IT Intern position and start tomorrow. Excel was listed as something I was expected to have knowledge in, so this helped a lot. Hope it goes well

    • @AlexDonnett
      @AlexDonnett 9 років тому

      +Matt B did it go well?

    • @MattBCnR
      @MattBCnR 9 років тому +2

      ***** Yes, it's going great, been there about 5 months now. I'm now on one of the teams and sounds like I'll get hired in soon.

    • @AlexDonnett
      @AlexDonnett 9 років тому

      Matt B well that is just freaking awesome

    • @MattBCnR
      @MattBCnR 9 років тому

      ***** Still not hired in but I do a great job. So think it's just a matter of time.

    • @slougheton510
      @slougheton510 8 років тому

      +Matt B Any updates?

  • @YoursTrulySeng
    @YoursTrulySeng 11 років тому

    Thank youuuuu. I been to so many Excel classes and found that your 25 min video was way more helpful. I learned more than I have from any other class. Thanks!!!!

  • @Patiboke
    @Patiboke 8 років тому +50

    Nice tutorial, good voice and tone, only the recording volume is kind of low. Then a commercial comes and the loudspeakers explode. :-)

  • @michaelseansmith4174
    @michaelseansmith4174 11 років тому

    I learned more in your video than a $200 seminar. Thank you. People like you are why US small businesses are still going.

  • @EasternUNO
    @EasternUNO 9 років тому +3

    I found aging formula in your tutorial as the useful thing for me. I didn't know how to do it, but now I know thanks to you. Liked))

  • @time4sanity
    @time4sanity 11 років тому

    I have a basic working knowledge of Excel, but this GREAT TUTORIAL amplified for me how many great things I could be doing with it that I didn't even know. AWESOME! Thank you for the tutorial!

  • @roziegichohi1593
    @roziegichohi1593 9 років тому +3

    Thanks! I learned something new... The aging formula.

  • @lavendergeisha1
    @lavendergeisha1 11 років тому

    I've been looking at lots of Excel tutorial videos, and this is the best one I have seen.

  • @TimmmTim
    @TimmmTim 8 років тому +5

    good tips and man you have great voice!

  • @0irtgud
    @0irtgud 10 років тому

    Just got a summer job job as an AP assistant and going in I had 1-2 hours total on Excel... This helped me SOO much. Thank you!!

  • @tenodogblu
    @tenodogblu 10 років тому +3

    thank you for your time, it is much appreciated.

  • @I_Spy_Ing
    @I_Spy_Ing 10 років тому

    So happy I found this video! Went over just the right amount of information to successfully complete my interview today!!!

  • @neilarora7919
    @neilarora7919 9 років тому +9

    YOU HAVE A AMAZING VOICE

  • @k4titzu
    @k4titzu 12 років тому

    after 5 years of not using this program (since I've finished high school) .. honestly, I had no idea how to use it anymore!! but today,thanks to you .. I learned again these basics(must-know ) !! thank you x 1000 :)

  • @rachelhobw
    @rachelhobw 8 років тому +3

    thanks a lot! appreciate your videos!!

  • @00tensonam
    @00tensonam 12 років тому

    one of the best excel tutorial video on the net. will be watching all off your videos.
    great work thanks

  • @michael09s
    @michael09s 10 років тому +10

    this was very informative

    • @Ninjapple232
      @Ninjapple232 10 років тому

      I found your comment very helpful too

    • @applejacks1491
      @applejacks1491 10 років тому +3

      thank you for this amazing comment.

    • @michael09s
      @michael09s 10 років тому +3

      AJ Iorillo Thank you even more

    • @michael09s
      @michael09s 10 років тому +3

      Ninjapple232 I found yours even more helpful

    • @jaolliroi3487
      @jaolliroi3487 10 років тому +3

      ***** i wish i could grow up to be the commenter that you have become.. I am so proud of your accomplishments.

  • @SchizoNiko
    @SchizoNiko 9 років тому

    I have an interview next week for a job that relies heavily on Excel, and I haven't used it since high school so I desperately need this refresher! Thanks!

  • @lisascurlock3463
    @lisascurlock3463 8 років тому +8

    I almost feel like an expert lol but seriously thanks, very useful!!

  • @4n6oracle
    @4n6oracle 11 років тому

    Thank you for this video. My mother wanted me to teach her excel and I didn't know a good approach on how to teach her until this video. I was able to give her a very brief, yet, semi-indepth introduction to Excel through this video, thank you :)

  • @Tracy_negrete_art
    @Tracy_negrete_art 8 років тому +4

    Very easy and helpful. Thank you!

  • @theresashaw3431
    @theresashaw3431 9 років тому

    Thanks a lot for showing this to us, nice to have ppl like you helping society.

  • @stephenwatsonst101
    @stephenwatsonst101 11 років тому +3

    Good help for a beginner like me.

  • @courtneygabbert2158
    @courtneygabbert2158 10 років тому +8

    Luckily I am familar with all of these - but it would help if you would continue your thoughts and be more prepared... such as mentioning the 0 in zip codes and the 0 is missing - you never completed how to fix this...

    • @omarshaaban907
      @omarshaaban907 10 років тому +19

      Go make a video yourself if you are going to be this picky, instead of thanking him you can only think of ways to criticize. What a shame.... by the way, I was completely unprepared and found this lecture amazing.

  • @chicolatta2976
    @chicolatta2976 8 років тому

    i cant thank you enough , you really helped me save a lot of valuable time just with the " Basic math " , i did really complicated equations like ( =C2*G2*10%+A2*G2*10% ) , i used to do all that by hand and now i did it in 5 mins
    Thank You Thank You Thank You Thank You Thank You Thank You Thank You

  • @miguelguzman1610
    @miguelguzman1610 9 років тому +5

    Really liked the video, unfortunately, could not follow some of the clicks because too zoomed-in. Somewhat agravating...but thanks for the info.

  • @Mocorn
    @Mocorn 12 років тому

    I just had to log in to write this, excellent video man! probably one of the better Excel videos I've come across in my search on UA-cam this afternoon.

  • @LaLauraActress
    @LaLauraActress 9 років тому +3

    Thank you very much|

  • @dianacolon4142
    @dianacolon4142 7 років тому

    Thank you for your tutorial it means a lot to people like me that are new and are hesitant to taking that first step in learning Excel because of lack of knowledge.

  • @myclubwagon
    @myclubwagon 8 років тому +5

    sound is too low!

  • @emeraldkatt4899
    @emeraldkatt4899 12 років тому

    Loved the "opps" on the number six. Showed me even professional people make mistakes. I stammer if I am not careful and land knows what I say then! Loved the info, very simplistic and well defined. Even I was able to understand and use the points you taught and I have only used Excel 1-2 times.

  • @jcast714
    @jcast714 9 років тому +132

    one, three, four. two, four, sex. lol

    • @TamerlaneLM10
      @TamerlaneLM10 8 років тому +7

      Horny guy really

    • @dakesim
      @dakesim 8 років тому +4

      :))) the comment I was looking for

    • @nossimrehema7114
      @nossimrehema7114 7 років тому

      Excel was my best package in computer classes this chanel just taught me alot

  • @rosielotfi9364
    @rosielotfi9364 12 років тому

    AWESOME!!! Thanks so much for posting this video. Your step-by-step directions are wonderful. You have answered so many of my questions in this short video. THX!!!!!!

  • @wallienewen3446
    @wallienewen3446 10 років тому +5

    lolz.. "Remove Duplicate" I didn't know that.. thank you.

  • @joedarvish70
    @joedarvish70 12 років тому

    What a treat. This is so refined. It is the best video to get the kink out of Excel. Bravoo

  • @ghsends1332
    @ghsends1332 8 років тому +5

    so very very helpful now I can actually use exel without my mommy

  • @michaelg8305
    @michaelg8305 11 років тому

    Thank you! I just got a management promotion that involves me using excel a lot and I haven't used for years, your video was refreshing and great!

  • @erogers999
    @erogers999 8 років тому +11

    is he talking into a pillow lol

  • @mstrong2099
    @mstrong2099 8 років тому

    This video was a crash course before I interview for an entry-level accounting position! Thanks Ilan!

  • @Mrslykid1992
    @Mrslykid1992 11 років тому +5

    Worth 25 mins

  • @DareJOnadele
    @DareJOnadele 10 років тому +1

    This is really a helpful video. It's a really awesome one that can take you to the intermediate level for your day-to-day needs.

  • @FPrimeHD1618
    @FPrimeHD1618 8 років тому +5

    It's a sin that you call sine sin :D

  • @eher124037
    @eher124037 8 років тому

    Ilan Patao, this was a very useful tutorial. Thank you so much for taking the time for loading up this tutorial, you are the man.

  • @MrDenverlc
    @MrDenverlc 10 років тому +5

    This is great..Thank you for sharing your knowledge. But funny how you mistakenly said SEX instead of Six, I like the way you think.Hahaha

    • @bossomboss5828
      @bossomboss5828 6 років тому

      Don't worry still learning about sex and six.

  • @tankersmit
    @tankersmit 10 років тому

    Thanks Ilan! Very clear,simple and easy to listen to
    From the UK!

  • @matthewscheiner9991
    @matthewscheiner9991 11 років тому +4

    "sex"...;-)

  • @comics7968
    @comics7968 10 років тому

    I'm 65 and attempting to re-enter the job market. I have 2 weeks to learn the basics of Excel, and this video
    has been a huge help. But a few of the other comments ring true -- please slow down a little and allow us the extra
    few seconds to follow your directions. AND THANK YOU FOR THIS HELPFUL VIDEO!!!

    • @hellobear
      @hellobear 10 років тому

      good luck on the job

  • @1934FOLKS
    @1934FOLKS 12 років тому

    Thanks you for this.i am new to Excel and I know that Excel is very useful and important and there are a lot of things that can be done.So looking at this gives me a head up.Clear and understandable .Thanks!

  • @juanbeltran2232
    @juanbeltran2232 11 років тому

    Thank you so very much for making this tutorial available. Starting tomorrow, will be my second week working at my new job position in the office and I will start using Excel. You did a great job with this Excel video tutorial. I now feel more at ease and comfortable with the new task and job position ahead. Thank you! :-)

  • @HiroDaHero
    @HiroDaHero 10 років тому +1

    The Aging Formula is really helpful. Thank you!

  • @latinafemm
    @latinafemm 12 років тому

    Great demo on excel. I will be starting a new job and I was told I had to learn EXCEL and this helped me . WONDERFULLLL

  • @zacandmillie
    @zacandmillie 12 років тому

    Thank you for these tips. I have to keep details on a small vehicle fleet for servicing so being able to sort and filter will make it easier to highlight the vehicles when they will be due for service. I now know how to make these tasks easier to keep on top of.

  • @magaliiglesias4440
    @magaliiglesias4440 12 років тому

    Thank you so much! How nice of you to take the time to teach.

  • @reginamaxey8524
    @reginamaxey8524 11 років тому +2

    I needed this a long time ago, very informative. I will be going over this again a couple of times. It will help me a lot with my school work.

  • @yvonnepardo1046
    @yvonnepardo1046 9 років тому

    Thank you very much. I have a job interview in two days and will be tested on basic Excel skills. This was extremely helpful!

  • @iluvmickeymouse2
    @iluvmickeymouse2 11 років тому

    I used your video since I have a test for excel 2010 at a temp agency, I know excel, but some things I do use often, and needed a quick refresh. Surprised that I learned a thing or two. thanks

  • @246marisol
    @246marisol 12 років тому

    Great tutorial. I learned Excel, ClarisWorks etc by unravelling them piecemeal as and when I needed them. Naturally, I missed a lot of info here and there and probably took the long way round many times when a short cut could have been used. This info will help me a lot!

  • @lokiboricua
    @lokiboricua 10 років тому +1

    Excellent video. It helped me to review some skills I learned a while ago and learn new ones. Thanks for your tutorial.

  • @leonorgarcia9718
    @leonorgarcia9718 5 років тому

    Thank you for the tutorial! You have a fantastic voice! You keep one attentive to what you are teaching. Not boring, Lol! Only thing, the commercials? Yes, volume is loud.

  • @makisjeremiah288
    @makisjeremiah288 7 років тому

    It is very nice teaching with best teacher, I appreciate it. Congratulation to all who prepared these tutorials it's very helpfull.Thank u.

  • @BMT505
    @BMT505 12 років тому

    THANK YOU SO MUCH FOR THIS UPLOAD, ONLY GOD KNOWS HOW HELPFUL THIS WILL BE FOR ME

  • @nancynieves6912
    @nancynieves6912 10 років тому

    Thanks for taking the time to post these tips. Very helpful.

  • @chiedelilah8536
    @chiedelilah8536 9 років тому +1

    Having fun with it, esp. with the concatenate dups. this is great! My hubby's going to be happy once he learns that I have discovered some technics he uses himself at work. Thanks to you sir :)

  • @lindafelcone2326
    @lindafelcone2326 8 років тому

    This is great. Important highlights to avoid pitfalls. I love your accent.

  • @Gurmaw
    @Gurmaw 12 років тому

    Like every has said it, I really appreciate what you have uploaded.Its been really helpful and I hope this would encourage you to share more your thoughts again. Thank you.

  • @waterfall844
    @waterfall844 10 років тому

    Thank you very much. This video truly helped me. You did it patiently and with a very clear voice.

  • @evelynagbasonu3096
    @evelynagbasonu3096 8 років тому

    I love the way you make excel look so simple.

  • @perapractice
    @perapractice 9 років тому

    A very well presented video. Easy to understand some of the main functions within Excel. Excellent refresher. Thank-you

  • @kimberlycalderon234
    @kimberlycalderon234 12 років тому

    This was such an awesome video as I've dabbled in Excel but don't know the easier functions. In my new job which I start tomorrow I know this will benefit me a lot!. Thank you for making it easy to understand :)

  • @the_secret_weapon
    @the_secret_weapon 10 років тому

    Very good tutorial and teaching. You should upload more, you explain it pretty well and make it simple for those of us not familiar with Excel.

  • @HangwHwang
    @HangwHwang 12 років тому

    One of the best instructional videos I have seen. Thank you for the tutorial. I am a treasurer in a club for my college, and I hope to utilize what you have taught me to be more efficient in organizing the funds for the club I am in.
    -jason

  • @1485edgewood
    @1485edgewood 10 років тому

    This was fantastic. I am 58 so older than most and this gave clear instructions on how to do the most common things. I am now going to look for another video by this person....Thank you SO much.

  • @emliberato
    @emliberato 5 років тому

    Great study video. I have an excel assessment soon, so I'm brushing up! This rocks, so thank you!

  • @moniquewright3378
    @moniquewright3378 11 років тому

    Thanks for the help! I am now ready for my first day of work!

  • @annagarcia_esq
    @annagarcia_esq 8 років тому

    Thank you very much for the video!It is very helpful. I am also getting ready for the test in Excel for the job.

  • @michellesoo3106
    @michellesoo3106 10 років тому

    Clear and Candid presentation & very useful information ! Thank you

  • @kaylasmith2508
    @kaylasmith2508 8 років тому +1

    Thank you for making such a great tutorial on some of the basics, this is exactly what I needed. More than the intro, but not going in depth with financial options

  • @fcarreon0413
    @fcarreon0413 8 років тому

    That was really helpful, I really do appreciate it. The only thing I would sugguest is prepare what you are going to present (styling, ageing, math) within seperate sheets. I was close to going to a new video several times because you were fiddling, either way thank you.

  • @aliciac.b.311
    @aliciac.b.311 11 років тому +1

    Thank you so much for the quick tutorial. I have a job interview tomorrow and needed a quick review. Great job!

  • @anneswift3297
    @anneswift3297 11 років тому +1

    Thank you, clearly explained without sounding boring

  • @christysittig1200
    @christysittig1200 10 років тому

    Thank you for sharing your knowledge. I definitely keep learning... and I am 65 years old!

  • @pauls7056
    @pauls7056 11 років тому

    Thanks Iian. Some good lessons in there. And I am delighted to say that you solved my problem in the first few minutes.

  • @ESLteacher62
    @ESLteacher62 12 років тому

    Thanks for the great pointers and instruction! I hope to see lots more just like it. We appreciate the help a lot!

  • @zhongemma763
    @zhongemma763 8 років тому

    learnt a lot! i'm a total beginner. This tutorial is very helpful! Thank you!

  • @im_out_of_mana
    @im_out_of_mana 11 років тому

    to whoever made this video,
    I LOVE YOU!

  • @trajvijay1984
    @trajvijay1984 11 років тому

    this is one of the best video on youtube......to learn excel ....thanks.

  • @micahlarroque
    @micahlarroque 11 років тому

    First off let me say, thank you for making this video... Like me and I would say 90% of your viewer audience put this on our resume without actually knowing too much haha we all appreciate it. I actually think it's more helpful not having the data already in place then I can see everything you are doing. Start to finish. Anyways life saver for sure.

  • @ericgurley8444
    @ericgurley8444 12 років тому

    Thanks so much for this video. This was very user friendly and I learned quite a bit in such a short amount of time. Your skill and personality really helped in the teaching.

  • @elizabethwilburn2007
    @elizabethwilburn2007 8 років тому

    This was a great video! You explained everything so well. I got online to look for a refresher video and yours definitely did the trick. Thank you so much!

  • @yashididit
    @yashididit 9 років тому

    I worked along in my excel program at the same time. This was helpful to me. Thanks!

  • @VideoSouls
    @VideoSouls 9 років тому

    Thanks, you touched on a lot of stuff and summed it up efficiently. You saved me a lot of time :)

  • @kartofawe
    @kartofawe 11 років тому

    Was very helpful and well explained, thank you! That aging trick was quite interesting.

  • @TrainedSniper12
    @TrainedSniper12 12 років тому

    Thanks for a little crash course on Excel. I have not used in a long time.

  • @ProfYounge
    @ProfYounge 11 років тому +1

    Thank you! I agree with everyone else. This was an excellent training video, and you are a charming and personable teacher.