Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)

Поділитися
Вставка
  • Опубліковано 4 вер 2024
  • Download File: people.highlin...
    Intro To Excel: Store Raw Data, Data Types, Data Analysis, Formulas, PivotTables, Charts, Keyboards, Number Formatting, Data Analysis & More:
    (00:08) Introduction to class
    (00:49) Cells, Worksheets, Workbooks, File Names
    (02:54) Navigating Worksheets & Workbook
    (03:58) Navigation Keys
    (04:15) Keyboard move Active Sheet
    (05:40) Ribbon Tabs
    (06:25) Add buttons to Quick Access Tool Bar
    (07:40) What Excel does: Store Raw Data, Make Calculations, Data Analysis & Charting
    (08:55) Introduction to Data Analysis
    (10:37) Data Types in Excel: Text, Numbers, Boolean, Errors, Empty Cells
    (11:16) Keyboard Enter puts content in cell and move selected cell down
    (13:00) Data Type DEFAULT Alignments
    (13:11) First Formula. Entering Cell References in formulas
    (13:35) Keyboard Ctrl + Enter puts content in cell & keep cell selected
    (14:45) Why we don’t override DEFAULT Alignments
    (15:05) Keyboard Ctrl + Z is Undo
    (17:05) Proper Data Sets & Raw Data
    (24:21) How To Enter Data & Data Labels
    (24:21) Stylistic Formatting
    (26:35) AVERAGE Function
    (27:31) Format Formulas Differently than Raw Data
    (28:30) Keyboard Ctrl + C is Copy. Keyboard Ctrl + V is Paste
    (29:59) Use Eraser remove Formatting Only
    (29:19) Keyboard Ctrl + B adds Bold
    (29:57) Excel’s Golden Rule
    (31:43) Keyboard F2 puts cell in Edit Mode
    (32:01) Violating Excel’s Golden Rule
    (34:12) Arrow Keys to put cell references in formulas
    (35:40) Full Discussion about Formulas & Formulas Elements
    (37:22) SUM function Keyboard is Alt + =
    (38:22) Aggregate functions
    (38:50) Why we use ranges in functions
    (40:56) COUNT & COUNTA functions
    (42:47) Edit Formula & change cell references
    (44:18) Absolute & Relative Cell References
    (45:52) Use Delete Key, Not Right-click Delete
    (46:40) Fill Handle & Angry Rabbit to copy formula
    (47:41) Keyboard F4 Locks Cell Reference (make Absolute)
    (49:45) Keyboard Tab puts content in Cell and move selected Cell to right
    (50:55) Order of Operation error
    (52:17) Range Finder to find formula errors
    (52:34) Lock Cell Reference after you put cell in Edit Mode
    (53:58) Quickly copy an edited formula down a column
    (53:07) F2 key in last cell to find formula errors
    (54:15) Fix incorrect range in function
    (54:55) SQRT function & Fractional Exponents
    (57:20) STDEV.P function
    (58:10) Navigate Large Data Sets
    (58:48) Keyboard Ctrl + Arrow jumps to bottom of data set
    (59:42) Keyboard Ctrl + Shift + Arrow selects to bottom of data set (Current Range)
    (01:01:41) Keyboard Shift + Enter puts content in Cell and move selected Cell up
    (01:02:55) Counting with conditions or criteria: COUNTIFS function
    (01:03:43) Keyboard Ctrl + Backspace jumps back to Active Cell
    (01:05:31) Counting between an upper & lower limit with COUNTIFS
    (01:07:36) COUNTIFS copied down column
    (01:10:08) Joining Comparative Operator with Cell Reference in formula
    (01:12:50) Data Analysis features in Excel
    (01:13:44) Sorting
    (01:16:59) Filtering
    (01:20:39) Introduction to PivotTables
    (01:23:39) Create PivotTable dialog box
    (01:24:33) Dragging & dropping Fields to create PivotTable
    (01:25:31) Dragging Field to Row area creates a Unique List
    (01:26:17) Outline/Tabular Layout
    (01:27:00) Value Field Settings dialog to change: Number Formatting, Function, Name
    (01:28:12) 2nd & 3rd PivotTable examples
    (01:31:23) What is a Cross Tabulated Report?
    (01:33:04) Create Cross Tabulated Report w PivotTable
    (01:35:05) Show PivotTable Field List
    (01:36:48) How to Pivot the Report
    (01:37:50) Summarize Survey Data with PivotTable.
    (01:38:34) Keyboard Alt, N, V opens PivotTable dialog box
    (01:41:38) PivotTable with 3 calculations: COUNT, MAX & MIN
    (01:43:25) Count & Count Number calculations in a PivotTable
    (01:45:30) Excel 2013 Charts to Visually Articulate Quantitative Data
    (01:47:00) #1 Rule for Charts: No Chart Junk!
    (01:47:30) Explain chart types: Column, Bar, Pie, Line and X-Y Scatter Chart
    (01:51:34) Create Column Chart using Recommended Chart feature
    (01:53:00) Remove Field Buttons from Pivot Chart
    (01:54:10) Chart Formatting Task Pane
    (01:54:45) Vary Fill Color by point
    (01:55:15) Format Axis with Numbers by Formatting Source Data in PivotTable
    (01:56:02) Add Data Labels to Chart
    (01:57:28) Copy Chart & Create Bar Chart
    (01:57:48) Change Chart Type
    (01:58:15) Change Gap Width.
    (01:59:17) Create Pie Chart
    (01:59:23) Do NOT use 3-D Pie
    (01:59:42) Add % Data Labels to Pie Chart
    (02:00:25) Create Line Chart From PivotTable
    (02:01:20) Link Chart Tile to Cell
    (02:02:20) Move a Chart
    (02:02:33) Create an X-Y Scatter Chart
    (02:03:35) Add Axis Labels
    (02:05:27) Number Formatting to help save time
    (02:07:24) Number Formatting is a Façade
    (02:10:27) General Number Format
    (02:10:52) Percentage Number Formatting
    (02:14:03) Don’t Multiply Relative Frequency by 100
    (02:17:27) Formula for % Change & End Amount

КОМЕНТАРІ • 274

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

    Im not saying that all college education sucks, but you got things like this, comprehensive, spot on and the best part is FREE! Im actually learning more in youtube rather than in school

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

      I am glad that the videos helps!!!

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

    Excel 2013 Statistical Analysis #01: Using Excel Efficiently For Statistical Analysis (100 Examples)
    Download files: people.highline.edu/mgirvin/excelisfun.htm.
    Intro To Excel: Store Raw Data, Data Types, Data Analysis, Formulas, PivotTables, Charts, Keyboards, Number Formatting, Data Analysis & More:
    (00:08) Introduction to class
    (00:49) Cells, Worksheets, Sheet Tabs, Naming Sheets, Workbooks, File Names
    (02:54) Navigating Worksheets & Workbook
    (03:58) Navigation Keys
    (04:15) Keyboard Ctrl + PageUp/PageDown moves Active Sheet
    (05:40) Ribbon Tabs
    (06:25) Add buttons to Quick Access Tool Bar
    (07:40) What Excel does: Store Raw Data, Make Calculations, Data Analysis and Charting
    (08:55) Introduction to Data Analysis
    (10:37) Data Types in Excel: Text, Numbers, Boolean, Errors, Empty Cells
    (11:16) Keyboard Enter puts content in cell and move selected cell down
    (13:00) Data Type DEFAULT Alignments
    (13:11) First Formula. Entering Cell References in formulas
    (13:35) Keyboard Ctrl + Enter puts content in cell and keep cell selected
    (14:45) Why we don’t override DEFAULT Alignments
    (15:05) Keyboard Ctrl + Z is Undo
    (17:05) Proper Data Sets & Raw Data
    (24:21) How To Enter Data & Data Labels into an Excel Spreadsheet
    (24:21) Stylistic Formatting
    (26:35) AVERAGE Function
    (27:31) Format Formulas Differently than Raw Data
    (28:30) Keyboard Ctrl + C is Copy. Keyboard Ctrl + V is Paste
    (29:59) Use Eraser remove Formatting Only
    (29:19) Keyboard Ctrl + B adds Bold
    (29:57) Excel’s Golden Rule
    (31:43) Keyboard F2 puts cell in Edit Mode
    (32:01) Violating Excel’s Golden Rule
    (34:12) Use Arrow Keys to put cell references in formulas
    (35:40) Full Discussion about Formulas & Formulas Elements
    (37:22) SUM function Keyboard is Alt + =
    (38:22) Aggregate functions
    (38:50) Why we use ranges in functions
    (40:56) COUNT & COUNTA functions
    (42:47) Edit Formula & change cell references
    (44:18) Absolute & Relative Cell References
    (45:52) Use Delete Key, Not Right-click Delete
    (46:40) Use Fill Handle & Angry Rabbit to copy formula
    (47:41) Keyboard F4 Locks Cell Reference (make Absolute)
    (49:45) Keyboard Tab puts content in Cell and move selected Cell to right
    (50:55) Order of Operation error
    (52:17) Range Finder to find formula errors
    (52:34) Lock Cell Reference after you put cell in Edit Mode
    (53:58) Quickly copy an edited formula down a column
    (53:07) F2 key in last cell to find formula errors
    (54:15) Fix incorrect range in function
    (54:55) SQRT function & Fractional Exponents
    (57:20) STDEV.P function
    (58:10) Navigate Large Data Sets
    (58:48) Keyboard Ctrl + Arrow jumps to bottom of data set (Current Range)
    (59:42) Keyboard Ctrl + Shift + Enter selects to bottom of data set (Current Range)
    (01:01:41) Keyboard Shift + Enter puts content in Cell and move selected Cell up
    (01:02:55) Counting with conditions or criteria: COUNTIFS function
    (01:03:43) Keyboard Ctrl + Backspace jumps back to Active Cell
    (01:05:31) Counting between an upper & lower limit with COUNTIFS
    (01:07:36) COUNTIFS copied down column
    (01:10:08) Joining Comparative Operator with Cell Reference in formula
    (01:12:50) Data Analysis features in Excel
    (01:13:44) Sorting in Excel
    (01:16:59) Filtering in Excel
    (01:20:39) Introduction to PivotTables
    (01:23:39) Create PivotTable dialog box
    (01:24:33) Dragging & dropping Fields to create PivotTable
    (01:25:31) Dragging Field to Row area creates a Unique List
    (01:26:17) Outline/Tabular Layout
    (01:27:00) Value Field Settings dialog to change: Number Formatting, Function, Name
    (01:28:12) 2nd & 3rd PivotTable examples
    (01:31:23) What is a Cross Tabulated Report?
    (01:33:04) Create Cross Tabulated Report w PivotTable
    (01:35:05) Show PivotTable Field List
    (01:36:48) How to Pivot the Report
    (01:37:50) Summarize Survey Data with PivotTable.
    (01:38:34) Keyboard Alt, N, V opens PivotTable dialog box
    (01:41:38) PivotTable with 3 calculations: COUNT, MAX & MIN
    (01:43:25) Count & Count Number calculations in a PivotTable
    (01:45:30) Excel 2013 Charts to Visually Articulate Quantitative Data
    (01:47:00) #1 Rule for Charts: No Chart Junk!
    (01:47:30) Explain chart types: Column, Bar, Pie, Line and X-Y Scatter Chart
    (01:51:34) Create Column Chart using Recommended Chart feature
    (01:53:00) Remove Field Buttons from Pivot Chart
    (01:54:10) Chart Formatting Task Pane
    (01:54:45) Vary Fill Color by point
    (01:55:15) Format Axis with Numbers by Formatting Source Data in PivotTable
    (01:56:02) Add Data Labels to Chart
    (01:57:28) Copy Chart & Create Bar Chart
    (01:57:48) Change Chart Type
    (01:58:15) Change Gap Width.
    (01:59:17) Create Pie Chart
    (01:59:23) Do NOT use 3-D Pie
    (01:59:42) Add % Data Labels to Pie Chart
    (02:00:25) Create Line Chart From PivotTable
    (02:01:20) Link Chart Tile to Cell
    (02:02:20) Move a Chart
    (02:02:33) Create an X-Y Scatter Chart
    (02:03:35) Add Axis Labels
    (02:05:27) Number Formatting to help save time
    (02:07:24) Number Formatting is a Façade
    (02:10:27) General Number Format
    (02:10:52) Percentage Number Formatting
    (02:14:03) Don’t Multiply Relative Frequency by 100
    (02:17:27) Formula for % Change & End Amount

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

      Hi when i download through the link, Data analysis, pivot tables, and other functions are not seen in the file content or even in index file.

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

    FINALLY!! someone who speaks quickly. So tired of having to set the speed to 2.0 because teachers speak so slowly. Love it!!

  • @hs.6098
    @hs.6098 6 років тому +5

    Great job. I appreciate the fact that you are very animated in discussing the excel file. As a result, I don't feel boar and I find it very engaging!

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

    I have been working with Excel since 1984, long before most of your students were born. Still I learn something new in each of your videos. Thank you!

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

      I am glad that the videos help!

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

    Excel is not so fun, but this lecturer makes it so FUN! I smile every time he says '"BOOOM!" and I wish he is my lecturer.

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

      I do get to be your lecturer!!! Here at UA-cam : ) I am glad that you enjoy the videos, Sue Kz! Thanks for your support with your comment, thumbs up and your Sub : )

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

      @@excelisfun Awwwhh thankyou! I am so happy to be your student. From Malaysia !

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

    Basic , simple and long video , however ,not boring at all , even after more than 6 years , the rules mentioned in this video still helps a lot in today's work and small tricks still very useful , really wish I'v seen this years before. Hope more people can study the wonderful course.

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

      You got it! And in fact, the rules for efficient Excel have not changed much at all since the famous book in 1986, The Elements of Spreadsheet Style. In fact, I am currently writing a book about the new Microsoft 365 Excel that is very similar that that famous book.

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

    I just watched this video for 5 mins and I'd already got attracted by the content and the way you lecture. It is really easy to follow and understand for anyone. Even better than the Excel course I spent 20 dollars for at Udemy.

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

    There is not a single person like you who explains so lucidly and that too step by step. Salute to you Sir from India.

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

      You are welcome for the careful teaching, SANDIP!!!!

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

    Thank you for all the great efforts for guiding us in Excel and making us pro. Its so addicting watching it and then practicing afterwards.
    Thank you.

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

    Great job. Clear instructions, re-caps provided, narration over live tutorial, PLUS you are upbeat. Thanks!

  • @dannypazani
    @dannypazani Рік тому +1

    i was really not expecting it to be this good.

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

      Yes, this is the one-stop-shopping video for many of the Excel tricks needed in statistics. Glad you liked it, daniel!!!

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

    So glad I found this series. Thank you so much. The best part is the enthusiasm behind it.

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

      +Damaso Rodriguez Glad you like it!

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

    This is a great video, I have taken beginning and intermediate Excel @ my school and still learned quite a bit. Thanks for all of the keyboarding tips!

  • @AL-ei8oo
    @AL-ei8oo 8 років тому +1

    Thank you for providing such a comprehensive tutorial! This video was extremely helpful especially when you provide clear explanation of why you use certain shortcuts and make sense of shorter formulas. Very helpful for people who use Excel for the first time.

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

      +Aanon 1213 You are welcome!

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

    your excel lessons r so nice to me coz they have changed me indeed. God bless U

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

      +taaka phionah Glad you like them!

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

    Thank you, Mike, even though I have learned so much from your classes I still like to follow your classes video by video, your energy, and great delivery flows very cleary in your videos, you should consider teaching other teachers h0w to teach because you master the art of teaching indeed.

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

    after finishing videos for CFA lvl 1, your videos are my top 1 priority to watch,
    cheers man, hope you very best wishes, be healthy and thank you for what u have done for society

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

      Tuan duong anh You are welcome!!!

  • @sachisavla7742
    @sachisavla7742 Рік тому +1

    my humbles thank you as the effort here is um-imaginable and its all for free. We students need gems like you and I am sure i speak for all when i say, we are so so so thankfull

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

    Damn bro!! This guy motivates me to learn Excel faster than Im learning right now. how energetic he is!

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

      Glad the video helps, thegreedy211!!! Thanks for your support with your comment, Thumbs Up and a Sub : )

  • @Patrixxist
    @Patrixxist 6 років тому +2

    Thank you so much for your enthusiasm and clear instructions! It helped so much when I cound't attend the lectures at my university!

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

      Thank you for your kind words! Thanks for the support with your comment, Thumbs Up and Sub : )

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

    2000% improvement is accessibility and navigation! Thanks, Mike!

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

    I love these videos (great for reviews, sharing with others, and problem-solving in my job). I also see Will Farrell, in his 'full-on' Buddy costume, sitting at the keyboard teaching us as I listen to Mike's enthusiastic voice. "Wow!" BOOM! :)

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

      Something like that : ) Glad you love the videos, mlzorb!! Thanks for your support of the excelisfun channel with your comments, thumbs ups and of course your Sub : )

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

    Thank you very much for all this free excel learning stuff !!!! Love your enthousiasm !!

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

    Dang ! it is just 15 min into the video and i have already learned quite a new things .. amazed !! well done

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

    I was so bored for few hours with others similar videos... but hearing your passionate and motivated voice made me so happy to learn new things! Thanks :)

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

    Thanks you very much. You are an excellent teacher. Your perfect english makes too easy the understanding for foreign people like me.

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

    Thank you for creating these videos I am currently taking a Stats class with a prof that speaks polish and class is painful.... you are the man thank you! I have told all of my classmates. I cried when I got the AHA moment

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

      +KG Learning , You are welcome! I am glad that you and your classmates can benefit from the videos and Excel Files!

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

    You are amazing and so enthusiastic, super easy to learn with that energy. Many thanks from Mozambique.

  • @PaoloCondo
    @PaoloCondo Рік тому +1

    Incredibly useful and amazingly explained video. Thank you so much!

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

    thanks for making such great tutorial lessons! im more in love with excel now! you are the best!

  • @priyaangadi1213
    @priyaangadi1213 2 роки тому

    I finally completed this 2:22 hour lesson. learnt a lot about MS Excel

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

    Mate, Thank you for doing this for us. This will help me too much in college. You're awesome man.

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

    Man! I love your video, your way of teaching, your tone of voice and everything else there is. Keep doing the amazing work you are doing!

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

      Yes, sir!!! You are welcome! Thanks for helping me to continue with your Thumbs Up on every video that you watch, comments when you are inspired, a Sub, and tell all your friends : )

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

    I've never seen anyone so excited about Excel before. He probably dreams of spreadsheets. Sweet sweet spreadsheets.

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

      Yes, sir!!!! And my dreams come out as these videos so I can help provide Excel Education to the world !!!! Thanks for your support, Drake!!!

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

      ​@@excelisfun You've certainly educated me, and I really appreciate it. You're doing the Lord's work out there.

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

    You're a great teacher. Learning so much.

  • @playawesome8484
    @playawesome8484 4 місяці тому +1

    I love your videos and I think I'll Complete this Playlist.

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

    Finished the 2 hour video. Amazing!

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

      Yes, there is A LOT in this video : )

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

    You know what! , when I talk with people still studying I always tell them to learn excel , it's the best why to solid the theories and practice them with the best software for the businesse
    I wished someone told me this before :)

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

      All of us who go through school have the same compliant because virtually no teachers in the world teach with Excel. Back in 1990s when I was in graduate school, I remember how mad I was that no one was teaching with Excel. This is the reason I became a teacher... Wow, DIGITAL COOKING, I am excited for you to go through this class. You will see how much different it is when a topic like statistics is taught with Excel!!! Get ready for an amazing journey : ) AND... Thanks for your support : )

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

      @@excelisfun yes!! , I was planning to see series before , but I was busy with great series too the MSPTDA series :)
      THANKS

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

      @@DIGITAL_COOKING This class gets pretty hard core with statistical distributions and hypothesis testing. Although I use these techniques sometimes, the techniques in MSPTDA and E-DAB are the techniques I use much more often.

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

    WoW - I am hooked already. These videos are amazing and you are truly an inspirational teacher. I hope that many young (and old) learners see what you have to offer and use it! Quick Question - any major (or minor) differences in Excel 2016 that I should watch out for? or be aware of?Thanks again!! This is not going to be good for my addictive personality...on the other hand...there are 2500 videos :)

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

    Amey Dabholkar , just type a time, You/Google does it automatically!

  • @shakhrizakurbanova4614
    @shakhrizakurbanova4614 7 років тому +1

    Oh, I found out my mistake, Thank you. Incredibly excellent tutorials.

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

    Your videos are amazing. Been watching your pivot table and vlookup beginner to advanced videos alongside this video and they are very helpful. I'm a chemistry graduate looking to supplement my excel knowledge in hope of getting an interview for a graduate analyst job! Even if I don't get a job it's very interesting and fun to learn because you teach in a very helpful and interesting manner. Also, I love your favourite phrase, "you're not going to believe this!" Do your family find it funny that you say this phrase so often or is it just contained in the workplace?!

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

      matt96533 Glad the videos help!

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

    Your vedios are useful to daily activities of business, thanks

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

      I am glad that they are useful for you, Olika!!!! Thank you for the support with your Comments, Thumbs Ups and Sub : )

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

    Excellent work! Very clear and lots of great tips for both beginner and more advanced users. I'm very impressed! Thanks a lot!!

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

      Harumi Ohata You are welcome!

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

    thanks for taking time out of your daily life to do this I really appreciate it you've helped me learned a lot BTW by the way I watch this and I'm only 10 I know shocking.

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

      Thanks for being so smart! Glad you like the video!

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

    Thank you for teaching me. I can't say nothing more than thank you

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

      You are welcome, Vinay! I appreciate your support and it helps me when you comment and thumbs ups on the videos that you learn from, and of course your Sub too : )

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

    You are GOD! This helped me pass my exams!!!!! 🙌

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

    BOOM....thanks for another epic series!

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

      +Jon doe You are welcome!

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

    !!What an amazing video! Now I'm totally crazy for Excel! Thx for your hardworking and sharing! It's a marvellous masterpiece! Big thx!!

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

    It's very good video to understand excel. The way you stress while explaining makes one's attention. Really wonderful. It would be a great help, if you can make this excel file available to download, to practice while watching you on UA-cam. Thank you.....

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

      It is available. Click on the link below the video. The start of the video explains how to do it.

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

    You lecture with so much passion. Thanks for this amazing tutorial.
    I have a question: is slaying excel coursebook available as virtual tutorial like this one?

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

    Great Videos learning from you n ur website.

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

      Rajesh Peter Glad the video helps!

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

    sorry if this is a lame query but is this tutorial a data science using Excel tutorial or it's statistical analysis tutorial , I know very little of all this. And man you are the best UA-cam teacher and very active by replying to everyone's query . Much respect

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

      It is a Statistic and Data Analysis video. But the terms may chnage. Thanks for the respect and Thanks for the support, Sagar, with your comments, Thumbs Ups and Sub : )

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

      ExcelIsFun thanks again :-)

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

    Thank you so very much. You've got some lucky students and happy youtubers!

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

      uspropbroker You are welcome!

  • @vishal-sr5et
    @vishal-sr5et 3 роки тому

    thank u man , u are seriously an amazing teacher 😁😁😁

  • @monjurulaminanik599
    @monjurulaminanik599 2 роки тому

    I can't Praise too well but I hope Allah Give you the "Hidayat" so that you don't have to be in Jahannam After your hereafter , Besides You will be the great amongst the all MVP in Microsoft. if Allah wishes. I pray for you buddy :)

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

    These are all very useful. God Bless You for sharing your knowledge. Indeed, excel is fun :)

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

      +Anthony Gramaje Glad you like them!

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

    Guruji, you are just great! Thanks for everything

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

    This is really so helpful....
    I have a question for you. I want to know how to calculate the mean, mode, median, ....etc per category. The exact two questions are: 1- By transaction, show the mean, mode, ....etc --- 2- By day of the week, show the mean, mode, ....etc.
    How can we do this using excel 2016? Thanks a lot.

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

    You`re a star. Thank you for your amazing video. Keep it plz.

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

    This is still Gold ... well done !

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

    thankyou
    very helpful tutorial

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

    This is super awesome. I'd definitely recommend it to my colleagues and students.
    By the way, this is using Excel 2013. Will you also update the course to 365 version? Thanks!

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

    A new Statistical series with Excel 2013 !!!! O U T S T A N D I N G !

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

      Yes, and this 100 example video is just the first video in a long series! It should be fun!

  • @mohitgehlot6582
    @mohitgehlot6582 Рік тому +1

    You are great person

    • @excelisfun
      @excelisfun  Рік тому +1

      Thank you, I am happy to help!!!!

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

    this is GEM. thanks a lot!!!!

  • @johng-qh8yz
    @johng-qh8yz 8 років тому +1

    Am I at the start? Every ExcelIsFun UA-cam neatly numbered from 1 to .... for the works. Need it. Then he'd be Harvard! (I saw a 00, some other videos by Mike, so it's not perfectly clear.) I think this guy created Excel; Gates just tags along in some backfield!

  • @abigailhak-gwembe5639
    @abigailhak-gwembe5639 4 роки тому +1

    Thank you for this tutorial l learnt alot

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

      You are welcome a lot, Abigail!!!

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

    Thank you so much!!! I have learned so much with this :) Great work

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

      You are welcome, Barbara!! I am glad that you learned so much. Thanks for your support with your comments, thumbs ups and Sub : )

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

    Your voice is like Ross Geller!.. Nice Video..

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

    Really good class

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

      Glad it is good for you, Eliezer!!!

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

    omg I wish I had found this earlier!! This is reaally good!

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

      No more comprehensive Excel tutorial can be found

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

    Amey Dabholkar Your Google settings are blocking me from answer your comments directly. You should fix this since you are asking questions often.

  • @dorissweanapo9860
    @dorissweanapo9860 6 років тому +1

    Great review!

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

      This is quite an epic video... But, if you can call it a review, then you know A LOT about Excel, Doris : ) : )

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

    Thank you for all the lessons here!

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

    Thank you so much! These videos are simply AMAZING

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

    Starting this series Mike, I think I will love this one as well! :)
    I'm trying to like every video.

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

    Just finish watching the first video, and... yes!! You right it was an epic video :)

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

    You are a legend on youtube

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

    Muchas gracias, desde México. Thank you very much sir, you are DA teacher. regards

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

      I am glad that the video helps!

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

    Wow so good. Cannot thank you enough. You are a saviour!!

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

    great,, I am very happy,,this tutorial,,,it has help a lots,,

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

    You are AWESOME! Thanks!

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

    Wow. Thanks very much.

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

      You are welcome so much, Tamara!!! Thanks so much for your support with your comment, Thumbs up and Sub : )

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

    Amazing! This is exactly what I needed. Thank you som much!!

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

    EXCELLENT video!!! Truly helpful.

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

      EXCELlent!!! I am glad that the video was helpful. Thanks for your support with comment, Thumbs Up and Sub : )

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

    hi thank you for the video that is amazing well I can improve my excel level abf I also can improve my english gracias.

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

    thank you! this is so helpful. And I love how excited you are to share all this knowledge))

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

      You are welcome, Aigerim!!

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

    You are a legend.

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

      Not really, just a guy having fun with Excel!!! :)

  • @charlenewolford2887
    @charlenewolford2887 2 роки тому +1

    Awesome Video!!

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

      Glad it is awesome for you!!!

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

    Thank you very much for epic video.

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

    you are simply awesome mike.

  • @anarakberov7173
    @anarakberov7173 6 років тому +1

    I would like to thank you very much

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

    you are too good, salute to you :)

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

    Amey Dabholkar , just type a time in comment and You/Google does it automatically!

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

    GREAT videos all around. What do you use to record your videos? I want to record videos for work for .Net development related stuff.

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

    Your awesome.. thanks

  • @vishal-sr5et
    @vishal-sr5et 3 роки тому +1

    happy teachers day