Excel Magic Trick

Поділитися
Вставка
  • Опубліковано 18 жов 2024

КОМЕНТАРІ • 83

  • @xXIggy93Xx
    @xXIggy93Xx 5 років тому +83

    PVC for survival situations, let's check it out.

  • @excelisfun
    @excelisfun  13 років тому +1

    No gangsta, just a guy having fun with Excel... LOL I am glad that the videos help!

  • @omad84
    @omad84 14 років тому

    this fella is a life saver for this. he actually sound so upbeat during it which really helps.
    cheers man!

  • @Scoobalu
    @Scoobalu 4 роки тому +40

    5Head I see PVC was here

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

    You are a lifesaver dude, had to rush an excel assignment tonight and have never used the program before. This helped tons :)

  • @epicpants2314
    @epicpants2314 4 роки тому +1

    I NEED MORE EXCEL MAGIC TRICKS

  • @tankpiggy
    @tankpiggy 4 роки тому +9

    5head, it is actually quite simple once you think about this logically

  • @rin_hat
    @rin_hat 4 роки тому +14

    5head of course, a classic

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

    El Goblinos favorite video monkaW

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

    PVC's liked videos are sure an interesting thing

  • @excelisfun
    @excelisfun  12 років тому +2

    I am glad that it helped!

  • @user-yt5mn1cd2s
    @user-yt5mn1cd2s 5 років тому +23

    XQCL

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

    Hi That is a great and easy understanding video. Thank you very much.I am so confused with STDEV.P and STDEV.S.... Hope to see you make one for explaining the differences.

  • @excelisfun
    @excelisfun  13 років тому +1

    You are welcome! What class are you in and at what university are you attending?

  • @excelisfun
    @excelisfun  13 років тому

    Cool, I am glad that you liked it!

  • @excelisfun
    @excelisfun  15 років тому

    Dear trantran183,
    Thanks for watching!
    --excelisfun

  • @perrierlol557
    @perrierlol557 3 роки тому +3

    xQc said this was informative so pog

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

    Simple and to the point, thank you! Very educational.

  • @yibro3360
    @yibro3360 5 років тому +45

    IF CHAT SEES THIS VI VON ZULUL

  • @conman24life
    @conman24life 13 років тому

    u are a true gangsta...love ur vid ive been skipping all my data classes but i manage to do my summatives with this vid..LOL

  • @connorhandforth814
    @connorhandforth814 5 років тому +43

    PepeLaugh oh no no no

  • @excelisfun
    @excelisfun  14 років тому

    I am glad that it helps!

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

    Great video! Do you have a video that shows how to calculate the mean, media, mode for likert scale responses? Also, what is the best way to calculate the average for this type of scale? Mean? Mode

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

    WOW, so you really master excel, congrats, if only i had seen your channel before doing my bachelor thesis....

  • @tina5514
    @tina5514 13 років тому +1

    Thank you for your work. It helps me a lot!!!

  • @alhaydarm1
    @alhaydarm1 4 роки тому +1

    Hi Ross, Thx for the great lesson :)

  • @excelisfun
    @excelisfun  12 років тому +2

    Hopefully moving forward, the videos will help in your endeavors.

  • @TheArtizan
    @TheArtizan 13 років тому +1

    Thanks a lot you helped me with my statistics GCSE =] Subbed

  • @light8214
    @light8214 3 роки тому +2

    Absolute classic.

    • @excelisfun
      @excelisfun  3 роки тому

      Glad you like it! 12 year old video, but still statistically useful : )

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

    This video was very easy to follow thank you. I have a table frequency distribution I am working on but can't figure out which of your videos would be fit my data values...help :D thanks!

  • @XerxesGammon200
    @XerxesGammon200 13 років тому +1

    how do we calculate the "standard error of the mean" or known as "standard error" assuming that we have the standard deviation? please :) SE=SD/SQRT(N)

  • @MaCherieMcAli
    @MaCherieMcAli 14 років тому +1

    Thank you for the excellency on your video I been struggling with my online class there is a lot to do and you have explain more int 11 minutes than the 4 weeks of class that I have already done. But question how do I handle a database with two characteristics and example
    How Do I handle that type of data analysis.
    125.91
    139.91
    147.41

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

    Hey man i have checked your channel and have subbed, however i am confused because there are so many vids, do you have vids on pretty much the basics (For Dummies) and then slowly advancing up? I need to learn this program for two crucial classes and i have never used the program prior to last night haha. And thanks for devoting so much time by uploading all those vids, whether you directly know or not, im sure your vids have helped thousands of people.

  • @excelisfun
    @excelisfun  14 років тому

    You are welcome!

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

    Just use MODE or MODE.SNGL (they do the same thing, that is to show the first mode). If you have multiple mode, use the MODE.MULT, but that means you will be doing an array formula so you might want to watch this:
    Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function
    and
    Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT

  • @oceileen
    @oceileen 13 років тому

    OK I figured out how to down load. This is a wonderful gift you given me! Thank you!

  • @vpg2daunit
    @vpg2daunit 14 років тому

    omg, u a genius man, thanks alot bro, nice video, excellent explanation, thank youu
    God bless

  • @solzy6495
    @solzy6495 5 років тому +4

    nice

  • @mooowlid9434
    @mooowlid9434 4 роки тому +7

    only hear to see xqc's peppega chat

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

    Yes, you should watch the playlists "Excel Basics" then "Highline Excel Class" then "Excel 2010 Statistics". Watch this video, it shows how to find playlists and use the excelisfun channel:
    youtube [dot] com/excelisfun
    This is an auto play video that shows how to use channel.

  • @neelnt1
    @neelnt1 13 років тому +1

    hi Excellsfun,
    how can we estimate mean, median and mode in case of continuous data series in excel ?

  • @excelisfun
    @excelisfun  14 років тому +1

    sure try this video title:
    Excel Statistics 37: PERCENTILE & QUARTILE

  • @flameguy3416
    @flameguy3416 4 роки тому +1

    Thank you.

    • @excelisfun
      @excelisfun  4 роки тому +2

      You are welcome, FlameGuy!!!! Thanks for your support on these videos that you learn from with your comments, thumbs up, and of course your Sub. It means a lot to me and helps grow the channel so that more people can find this free education : )

    • @flameguy3416
      @flameguy3416 4 роки тому +1

      @@excelisfun No problem man, keep doing what you do best and that's helping people 👍.

    • @excelisfun
      @excelisfun  4 роки тому +2

      @@flameguy3416 Yes!!!! Together we are a Team!!!! I make and post and you watch and support : ) : ) GO TEAM!

  • @excelisfun
    @excelisfun  15 років тому

    Dear gyaltsen6326194,
    These are the videos I have about Payroll:
    Excel Busn Math 07: When ROUND function Is Required
    Excel Magic Trick #68: How To Setup Complicated Formula
    Excel Magic Trick #69: Assumption Tables and ROUND function
    YTLE#77: INDEX INDIRECT MATCH functions for Payroll
    Excel Lookup Series #9: INDEX function 1st Example
    Excel Basics #15: Date & Time Format & Calculations
    --excelisfun

  • @excelisfun
    @excelisfun  13 років тому

    Try this video:
    Excel Statistics 75: Point Estimates & Sample Error

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

    xQc was here FeelsStrongMan

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

    Thanks for the help.

  • @excelisfun
    @excelisfun  14 років тому

    I do not understand your question.

  • @excelisfun
    @excelisfun  15 років тому

    Dear t3rm1nat0r999,
    Did you watch those videos? The two videos cover:
    Standard Deviation and Frequency Tables.
    --excelisfun

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

    Thank you so much for this video

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

    Thanks so much :) I will get to it.

  • @oceileen
    @oceileen 13 років тому

    How do i download the workbook? How do I find your youtue channel?

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

    is this for Excel 2007 or 2010?? I'm confused with the mean.. I can't get it to calculate the mean.. it says #Value instead... and when I press F4 the numbers disappear in my column... please help me .. I have an assignment due...

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

    :'3 thank u kind sir
    making my work so helpful u angel

  • @haloman12378
    @haloman12378 5 років тому +12

    CLASSIC LULW

  • @excelisfun
    @excelisfun  13 років тому

    MODE function.

  • @PaulaLisamusic
    @PaulaLisamusic 13 років тому

    THANKS!

  • @tharakadilansampath382
    @tharakadilansampath382 4 роки тому

    thanks

  • @alexp2864
    @alexp2864 5 років тому +6

    5Head easy

  • @karljk
    @karljk 13 років тому

    excell is fun....

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

    KEKW

  • @tntblast56
    @tntblast56 Рік тому

    Can you change my oil thanks in advance

    • @tntblast56
      @tntblast56 Рік тому

      Also cover yourself in the oil please and thank you

    • @tntblast56
      @tntblast56 Рік тому

      It can be oil you so desire. (I'd appreciate it more if it was 30cc small engine oil)

    • @tntblast56
      @tntblast56 Рік тому

      Thanks

  • @phillipec
    @phillipec 4 роки тому +2

    Great vid, it was shit, but good.

  • @drag_611
    @drag_611 5 років тому +1

    say typical louder

  • @easton5060
    @easton5060 3 роки тому

    151 thousand views and only 75 comment and 300 likes

    • @excelisfun
      @excelisfun  3 роки тому

      What does it mean to you, reeaston?

    • @easton5060
      @easton5060 3 роки тому

      @@excelisfun it means people who watch this either don't have a account or just watch it to learn something and then leave.

    • @excelisfun
      @excelisfun  3 роки тому +1

      @@easton5060 Ya, it is a bummer that there is not much support. But, hopefully the learn benefit still occurs. Thanks for your support! It is appreciated : )

  • @n4riko
    @n4riko 3 роки тому

    LOL

  • @excelisfun
    @excelisfun  14 років тому

    You are welcome!

  • @excelisfun
    @excelisfun  15 років тому

    You are welcome!

  • @excelisfun
    @excelisfun  13 років тому

    You are welcome!

  • @excelisfun
    @excelisfun  13 років тому

    You are welcome!

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

    You are welcome!