Microsoft Excel 2013 Tutorial For Beginners #2: Crash Course Data Entry, Formulas, Formats, Charts

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

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

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

    If my free tutorials have helped you in any way please repay by liking, commenting, sharing and saving the videos to your favorites. Your interaction improves the search ranking of my tutorials which motivates me to keep making more. Thanks for the support!

  • @JiuJitsuislife
    @JiuJitsuislife 9 лет назад +32

    Dude, i'm just about to start on a new job and i said on my resume that i had basic excell skills. YOU SAVED MY LIFE (And new job lol)
    Thank you so much

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

    Hey guys please comment on this video. Any interactions such as commenting, rating, sharing and adding to your favorites increases our ranking on RUclips

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

    Nice tute. The world needs more quick, straight to the point, crash courses like this. No wasting a lot of time with the crudest of beginnings.

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

    I'm super excited to be learning this stuff. This will help me so much at my job. I can't believe the amount of time that this ten minutes will save me! Thanks, again!

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

    Life saver, I have been trying to get my hands on a quick reference lamenated thing, most college bookstores have em for all subjects..EXCEPT EXCEL. One of the hardest, and its midterm time, my teacher has not done well breaking down excel for me so that i understand it. I am good at math. So thank you!! Very helpful

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

    I love how you present this info. The one thing I would say is that you sometimes do not say what you are clicking to make something happen.

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

    Excellent and well explained in a straightforward and friendly way. I have an Excel exam at work next week so watching these tutorials closely! Thanks for you help. I learn more quickly watching a demo than reading books.

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

    You explain this so well, I caught quick...Thank you so much for your tutorial...it will helps a lot!

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

    I don't know why you would unsubscribe. That wasn't me that commented but another viewer of this video. I'm glad I could help you out. Thanks for watching.

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

    Thank you for the Excel Tutorials 2013 ... great way to brush up & you make it simple! Thanks again ... you're awesome!

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

    I am very happy I can UNDERSTAND the instructor. Excellent.

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

    An Alebraic explanation for the problem below:
    A*B + A*C = A*(B + C)
    In the example below A would be 3000, B would be 1 (which is 100%) and C would be 0.15 (which is 15%).
    Hope this helps for those who are getting started. I found that I learned better when I understood rather than raw memorization.
    Have a great day!

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

    I really liked and appreciated this video and the ones before this one. I am going to try to get a job and they want you to have experience with Excel. This was very helpful and I want to look up the rest of your videos. I can understand the way that you explain. It doesn't seem difficult the way you explain it.

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

    Great job man, I know excel a little but I've learn so much from these videos....Thank You...I definitely keep watching....You are Awesome!

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

    So useful, starting an office job soon, so want to get a head-start. Cheers!

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

    I hate math and am totally intimidated by it. But this is easy enough for even a MathPhobe like me! I'm a subscriber and plan to watch every one of your tutorials! Thank you so much!

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

    Excellent video. I like the clear and concise manner of your teaching. Please keep it up!

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

    Thank you THANK YOU! I am a stay at home mom re entering the workforce and this is the only tutorial that has really clicked!

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

    Trying to write a business plan, thanks for the comprehensive video!

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

    This is really helpful.You have much patience. Thank you so much!

  • @mayhemwithmrs.m455
    @mayhemwithmrs.m455 8 лет назад

    This is helping my boss and I learn new tricks. Thanks!

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

    I appreciate your help in getting me ready to take an excel assessment test for a new job.

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

    thanks so much this helped me for my I.T end of term exam so much

  • @serdnax5433
    @serdnax5433 5 лет назад

    Saved my ass, new job, let them know I had excel skills and was okay with the format but never used excel before 💀 now I feel confident for my first day ty

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

    Excellent tutorial many thanks

  • @RG-dz9tx
    @RG-dz9tx 10 лет назад

    really made it easy, thank you

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

    Good video introduction...minus the typing errors your presentation is well done, but I wish you would cover all of the different ways of doing Excel tasks and include explanations of the all the tabs! (File, Home, Page Insert, Formulas, etc) So this way you get us working with a spreadsheet like your boat rentals, but at the same time, review the various options up top so it's more of a two-fold crash course covering more.

  • @Kevin-uz9ik
    @Kevin-uz9ik 10 лет назад

    Thank you for the informative video.

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

    Excellent tutorial!

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

    awesome tutorials. very helpful

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

    Very Very helpful, I will defiantly be using it a lot in my job as a property manager Thank You So Much For Sharing and For Your Time ;)

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

    thank you so much for these videos

  • @danielsuh2032
    @danielsuh2032 9 лет назад +2

    Thank you so much!!

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

    thank you , you made it very simple :)

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

    Good work man. This was really helpful. Continue the good work :)

  • @farahch.705
    @farahch.705 10 лет назад

    So useful! Even understandable to a cavewoman like me! Thank you so much for this!

  • @MdAbdullah-lz9dt
    @MdAbdullah-lz9dt 7 лет назад

    very nice lecture, thank you

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

    Subscribed. Good work guys.

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

    I love ur tutorial

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

    Very helpful thank you, It really helped.

  • @siyeducation
    @siyeducation 11 лет назад +1

    A brief explanation:
    A 15% increase means 15% (0.15) increase over the original 100% (1).
    Orig Statement: 3000 + 3000*(.15)
    [you can factor 3000 out of the original statement, which then becomes 3000 * (1 + .15) = 3000* (1.15) = 3450; Similarly, if someone said a 10% decrease, then you can do 100% - 10% = 90% of the original value; (1 - .1)=0.9 * 3000 = 2700].
    * means multiply in the computer world! We don't use "x" because that is a letter.
    Similarly " / " is used for division.

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

    Thnk you for these videos.

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

    great tutorial

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

    Very helpful.

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

    Thanks again!!!!!

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

    Thank you!

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

    Very helpful 💓❤️

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

    Good Job!

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

    I see! Thank you!

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

    easy to understand

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

    thank you so much

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

    excellent

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

    THANK YOU

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

    good job. thax

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

    very nice.....

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

    Thank you. :)

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

    Thanks

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

    yep...
    God for you

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

    I low tech.Thank for tutorial :)

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

    15% increased supposed to be *0.15 but anyway I think it's hard to focus while talking on utube. Ur tutorial is awesome.

    • @usernamephillip
      @usernamephillip 10 лет назад +2

      You're right. But in excel he wants it to show the total from the previous month. If you were to say 3000*0.15 the april cell would only show the increase of 450. So 3000*1.15 would show the initial amount of 3000 plus the 15% increase of 450. So 3450.

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

      He wants the original with 15% increase so it's *1.15
      If you do *0.15 you get 15% from the original.

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

      *****
      It is simple. Giving example, you have $30 in the bank. After one year, your money increased by 2%. Find the total money you have after one year in ur bank account. So the increase amount will be $30x0.02=$0.6. So you gained 0.6 plus the original money in ur bank = 30+0.6 = 30.6 is ur total money after one year. There is another way to calculate this in one calculation: Take the first amount and times 1.02 = 30x1.02= 30.6. It's a shortcut for finding total amount. If it gains 4%, take 30x1.04. If it is 20% take 20x1.2. Don't look at my comment, I'm just trying to point out what he says does not match what he does so that others won't confuse. But he did a pretty good damn job in the video there.

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

    nice video

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

    Looks like you need to brush up on your typing skills AND people skills. I said you were dishonest, you said I was an ass. Funny.
    Conversely, thank you Subjectmoney for taking the time for creating these tutorials and helping people out.

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

    If you multiplied 3000 by only .15 then you would get 450. If you multiplied 3000 by 1.15 you would get 3450 which is 3000 plus 15% of 3000.

  • @adool999
    @adool999 9 лет назад +36

    FOR THE LOVE OF GOD CLOSE THAT FLASHING UAC

    • @MegaCityOne
      @MegaCityOne 9 лет назад +2

      Adel adil Make it stop please! Ahhh!

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

      I can't unsee it!

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

    so if 15% is written as 1.15, would 26% be written as 1.26?.. what does the 1 represent?

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

    . Thank you

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

    good day everyone, question? if every two months the %15 increase. should i put 2.15 and so on? thank you. more power.. :)

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

    I still don't understand how to do this, but maybe if I get school to help me.

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

    That's fine, I'll subscribe to his channel then. You need to cool it.

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

    Hi, I'm a little confused...maths is not my strongest subject...but for a 15% increase would you not times 3000 by 0.15? :|

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

    sum doesn't work in my excel, i'm using the dutch version of it

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

    When you increased business by 15% - why 1.15 and not just 0.15? is it because excel doesn't recognize the latter?

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

      Kamron K Me too I thought the same!!But he is great THUMBS UP!!!

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

      +Tark Janis Great explanation...
      I just imagine the 1 as the 3000 and add the .15% to it...

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

    OH i think i figured it out...the increase would be 450 then that added onto the 3000...but how do you get the figure 1.15? oh this is so embarrassing lol

  • @adrianaguzman1907
    @adrianaguzman1907 7 лет назад +1

    Wouldn't 15% be .15? 😬

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

    correction: I caught on quickly

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

    Thank you!