Tutorial - Excel 2010 - 10 Things you must know

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024

Комментарии • 994

  • @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!!!!!!!!!!

  • @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!

  • @wreckdizzle556
    @wreckdizzle556 10 лет назад +30

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

  • @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 8 лет назад +22

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

  • @TheMano03
    @TheMano03 10 лет назад +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!

  • @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.

  • @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 8 лет назад

      +Matt B did it go well?

    • @MattBCnR
      @MattBCnR 8 лет назад +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 8 лет назад

      Matt B well that is just freaking awesome

    • @MattBCnR
      @MattBCnR 8 лет назад

      ***** 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!!!!

  • @EasternUNO
    @EasternUNO 8 лет назад +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 8 лет назад +3

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

  • @k4titzu
    @k4titzu 11 лет назад

    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 :)

  • @tenodogblu
    @tenodogblu 10 лет назад +3

    thank you for your time, it is much appreciated.

  • @lavendergeisha1
    @lavendergeisha1 11 лет назад

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

  • @lisascurlock3463
    @lisascurlock3463 8 лет назад +8

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

  • @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!

  • @neilarora7919
    @neilarora7919 9 лет назад +9

    YOU HAVE A AMAZING VOICE

  • @4n6oracle
    @4n6oracle 10 лет назад

    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 :)

  • @TimmmTim
    @TimmmTim 7 лет назад +5

    good tips and man you have great voice!

  • @reginamaxey8524
    @reginamaxey8524 10 лет назад +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.

  • @jcast714
    @jcast714 8 лет назад +132

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

    • @Tamerlane619
      @Tamerlane619 8 лет назад +7

      Horny guy really

    • @dakesim
      @dakesim 7 лет назад +4

      :))) the comment I was looking for

    • @nossimrehema7114
      @nossimrehema7114 7 лет назад

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

  • @emeraldkatt4899
    @emeraldkatt4899 11 лет назад

    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.

  • @Tracy_negrete_art
    @Tracy_negrete_art 7 лет назад +4

    Very easy and helpful. Thank you!

  • @00tensonam
    @00tensonam 12 лет назад

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

  • @rachelhobw
    @rachelhobw 7 лет назад +3

    thanks a lot! appreciate your videos!!

  • @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!!

  • @stephenwatsonst101
    @stephenwatsonst101 10 лет назад +3

    Good help for a beginner like me.

  • @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.

  • @michael09s
    @michael09s 9 лет назад +10

    this was very informative

    • @Ninjapple232
      @Ninjapple232 9 лет назад

      I found your comment very helpful too

    • @applejacks1491
      @applejacks1491 9 лет назад +3

      thank you for this amazing comment.

    • @michael09s
      @michael09s 9 лет назад +3

      AJ Iorillo Thank you even more

    • @michael09s
      @michael09s 9 лет назад +3

      Ninjapple232 I found yours even more helpful

    • @jaolliroi3487
      @jaolliroi3487 9 лет назад +3

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

  • @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!!!

  • @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.

  • @HiroDaHero
    @HiroDaHero 9 лет назад +1

    The Aging Formula is really helpful. 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.

  • @spiritualistess6059
    @spiritualistess6059 6 лет назад

    Thank you. I am self taught in using excel. You did show me things I didn't know. Very informative. I appreciate you very much. I have a skills test tomorrow in Excel 2010 and Word 2010.

  • @LaLauraActress
    @LaLauraActress 8 лет назад +3

    Thank you very much|

  • @myclubwagon
    @myclubwagon 8 лет назад +5

    sound is too low!

  • @theresashaw3431
    @theresashaw3431 8 лет назад

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

  • @wallienewen3446
    @wallienewen3446 10 лет назад +5

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

  • @aliciac.b.311
    @aliciac.b.311 10 лет назад +1

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

  • @erogers999
    @erogers999 8 лет назад +12

    is he talking into a pillow lol

  • @BMT505
    @BMT505 12 лет назад

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

  • @Mrslykid1992
    @Mrslykid1992 10 лет назад +5

    Worth 25 mins

  • @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 :)

  • @ghsends1332
    @ghsends1332 7 лет назад +5

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

  • @anneswift3297
    @anneswift3297 10 лет назад +1

    Thank you, clearly explained without sounding boring

  • @FPrimeHD1618
    @FPrimeHD1618 8 лет назад +5

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

  • @comics7968
    @comics7968 9 лет назад

    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 9 лет назад

      good luck on the job

  • @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.

  • @rosielotfi9364
    @rosielotfi9364 11 лет назад

    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!!!!!!

  • @matthewscheiner9991
    @matthewscheiner9991 10 лет назад +4

    "sex"...;-)

  • @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.

  • @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 RUclips this afternoon.

  • @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.

  • @joedarvish70
    @joedarvish70 11 лет назад

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

  • @1934FOLKS
    @1934FOLKS 11 лет назад

    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!

  • @mstrong2099
    @mstrong2099 8 лет назад

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

  • @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! :-)

  • @latinafemm
    @latinafemm 11 лет назад

    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

  • @magaliiglesias4440
    @magaliiglesias4440 11 лет назад

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

  • @tankersmit
    @tankersmit 10 лет назад

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

  • @TrainedSniper12
    @TrainedSniper12 11 лет назад

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

  • @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 4 года назад

    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.

  • @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

  • @chicolatta2976
    @chicolatta2976 7 лет назад

    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

  • @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

  • @carabela125
    @carabela125 12 лет назад

    I like that you went through fast, so I did not get bored.

  • @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

  • @lindafelcone2326
    @lindafelcone2326 8 лет назад

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

  • @christysittig1200
    @christysittig1200 9 лет назад

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

  • @evelynagbasonu3096
    @evelynagbasonu3096 8 лет назад

    I love the way you make excel look so simple.

  • @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!

  • @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.

  • @im_out_of_mana
    @im_out_of_mana 10 лет назад

    to whoever made this video,
    I LOVE YOU!

  • @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!

  • @ProfYounge
    @ProfYounge 10 лет назад +1

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

  • @amyfrisbie9076
    @amyfrisbie9076 11 лет назад

    I learned something new. Didn't know about the aging thing and Ctrl Z. Thank you.

  • @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.

  • @trajvijay1984
    @trajvijay1984 11 лет назад

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

  • @the_secret_weapon
    @the_secret_weapon 9 лет назад

    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.

  • @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.

  • @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.

  • @trevelyan66
    @trevelyan66 11 лет назад

    The remove duplicates point was really helpful to me!

  • @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.

  • @moniquewright3378
    @moniquewright3378 10 лет назад

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

  • @ericgurley8444
    @ericgurley8444 11 лет назад

    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.

  • @sushilgurung4041
    @sushilgurung4041 8 лет назад +1

    Thank you for the video. Its amazing. Short and sweet.

  • @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 :)

  • @happy28121
    @happy28121 12 лет назад

    Thanks for the video going on a interview and being tested in Excel...very helpful.

  • @kenaula
    @kenaula 9 лет назад

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

  • @waterfall844
    @waterfall844 10 лет назад

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

  • @ESLteacher62
    @ESLteacher62 11 лет назад

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

  • @theravenberlin6642
    @theravenberlin6642 10 лет назад +1

    Thanx so much for this great tutorial, now i am not afraid anymore to use Excel....!

  • @emliberato
    @emliberato 4 года назад

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

  • @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.

  • @nancynieves6912
    @nancynieves6912 10 лет назад

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

  • @kartofawe
    @kartofawe 11 лет назад

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

  • @zhongemma763
    @zhongemma763 8 лет назад

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