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
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
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.
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.
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.
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!
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.
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
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.
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 :)
I do get to be your lecturer!!! Here at RUclips : ) I am glad that you enjoy the videos, Sue Kz! Thanks for your support with your comment, thumbs up and your Sub : )
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
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! :)
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 : )
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 : )
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
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 :)
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?!
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?
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 :)
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 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.
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 RUclips. Thank you.....
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.
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!
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 RUclips teacher and very active by replying to everyone's query . Much respect
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 : )
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.
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 : )
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 :)
Am I at the start? Every ExcelIsFun RUclips 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!
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
I am glad that the videos helps!!!
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
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.
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!
I am glad that the videos help!
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!
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.
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.
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.
FINALLY!! someone who speaks quickly. So tired of having to set the speed to 2.0 because teachers speak so slowly. Love it!!
Glad the video helps : )
There is not a single person like you who explains so lucidly and that too step by step. Salute to you Sir from India.
You are welcome for the careful teaching, SANDIP!!!!
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.
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!
Great job. Clear instructions, re-caps provided, narration over live tutorial, PLUS you are upbeat. Thanks!
I love your videos and I think I'll Complete this Playlist.
This is a fun one!!!!
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.
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
Tuan duong anh You are welcome!!!
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.
+Aanon 1213 You are welcome!
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 :)
So glad I found this series. Thank you so much. The best part is the enthusiasm behind it.
+Damaso Rodriguez Glad you like it!
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.
I do get to be your lecturer!!! Here at RUclips : ) I am glad that you enjoy the videos, Sue Kz! Thanks for your support with your comment, thumbs up and your Sub : )
@@excelisfun Awwwhh thankyou! I am so happy to be your student. From Malaysia !
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
+KG Learning , You are welcome! I am glad that you and your classmates can benefit from the videos and Excel Files!
Thanks you very much. You are an excellent teacher. Your perfect english makes too easy the understanding for foreign people like me.
your excel lessons r so nice to me coz they have changed me indeed. God bless U
+taaka phionah Glad you like them!
Thank you so much for your enthusiasm and clear instructions! It helped so much when I cound't attend the lectures at my university!
Thank you for your kind words! Thanks for the support with your comment, Thumbs Up and Sub : )
Dang ! it is just 15 min into the video and i have already learned quite a new things .. amazed !! well done
Damn bro!! This guy motivates me to learn Excel faster than Im learning right now. how energetic he is!
Glad the video helps, thegreedy211!!! Thanks for your support with your comment, Thumbs Up and a Sub : )
You are amazing and so enthusiastic, super easy to learn with that energy. Many thanks from Mozambique.
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! :)
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 : )
2000% improvement is accessibility and navigation! Thanks, Mike!
i was really not expecting it to be this good.
Yes, this is the one-stop-shopping video for many of the Excel tricks needed in statistics. Glad you liked it, daniel!!!
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!
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 : )
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
You are welcome!!!! : )
Thank you very much for all this free excel learning stuff !!!! Love your enthousiasm !!
Mate, Thank you for doing this for us. This will help me too much in college. You're awesome man.
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 :)
I finally completed this 2:22 hour lesson. learnt a lot about MS Excel
Incredibly useful and amazingly explained video. Thank you so much!
You are welcome so much!!!!
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?!
matt96533 Glad the videos help!
thanks for making such great tutorial lessons! im more in love with excel now! you are the best!
You're a great teacher. Learning so much.
You are great person
Thank you, I am happy to help!!!!
Amey Dabholkar Your Google settings are blocking me from answer your comments directly. You should fix this since you are asking questions often.
I've never seen anyone so excited about Excel before. He probably dreams of spreadsheets. Sweet sweet spreadsheets.
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!!!
@@excelisfun You've certainly educated me, and I really appreciate it. You're doing the Lord's work out there.
Amey Dabholkar , just type a time, You/Google does it automatically!
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?
Excellent work! Very clear and lots of great tips for both beginner and more advanced users. I'm very impressed! Thanks a lot!!
Harumi Ohata You are welcome!
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 :)
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 : )
@@excelisfun yes!! , I was planning to see series before , but I was busy with great series too the MSPTDA series :)
THANKS
@@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.
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 RUclips. Thank you.....
It is available. Click on the link below the video. The start of the video explains how to do it.
Amey Dabholkar , just type a time in comment and You/Google does it automatically!
Your vedios are useful to daily activities of business, thanks
I am glad that they are useful for you, Olika!!!! Thank you for the support with your Comments, Thumbs Ups and Sub : )
!!What an amazing video! Now I'm totally crazy for Excel! Thx for your hardworking and sharing! It's a marvellous masterpiece! Big thx!!
Big Your Welcome!!!
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.
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!
Awesome Video!!
Glad it is awesome for you!!!
Finished the 2 hour video. Amazing!
Yes, there is A LOT in this video : )
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 RUclips teacher and very active by replying to everyone's query . Much respect
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 : )
ExcelIsFun thanks again :-)
thank u man , u are seriously an amazing teacher 😁😁😁
You are GOD! This helped me pass my exams!!!!! 🙌
Oh, I found out my mistake, Thank you. Incredibly excellent tutorials.
: )
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.
Thanks for being so smart! Glad you like the video!
Great Videos learning from you n ur website.
Rajesh Peter Glad the video helps!
Thank you for teaching me. I can't say nothing more than thank you
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 : )
BOOM....thanks for another epic series!
+Jon doe You are welcome!
This is still Gold ... well done !
Guruji, you are just great! Thanks for everything
You are welcome : )
Thank you so very much. You've got some lucky students and happy youtubers!
uspropbroker You are welcome!
These are all very useful. God Bless You for sharing your knowledge. Indeed, excel is fun :)
+Anthony Gramaje Glad you like them!
GREAT videos all around. What do you use to record your videos? I want to record videos for work for .Net development related stuff.
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 :)
Really good class
Glad it is good for you, Eliezer!!!
You are a legend on youtube
Thank you for this tutorial l learnt alot
You are welcome a lot, Abigail!!!
Just finish watching the first video, and... yes!! You right it was an epic video :)
Epic!!!!!!
Starting this series Mike, I think I will love this one as well! :)
I'm trying to like every video.
Thank you for all the lessons here!
this is GEM. thanks a lot!!!!
You are welcome a lot!!!
Your voice is like Ross Geller!.. Nice Video..
You`re a star. Thank you for your amazing video. Keep it plz.
You are welcome!
Thank you so much!!! I have learned so much with this :) Great work
You are welcome, Barbara!! I am glad that you learned so much. Thanks for your support with your comments, thumbs ups and Sub : )
great,, I am very happy,,this tutorial,,,it has help a lots,,
Great review!
This is quite an epic video... But, if you can call it a review, then you know A LOT about Excel, Doris : ) : )
You are AWESOME! Thanks!
you are simply awesome mike.
thankyou
very helpful tutorial
You are welcome!
Wow so good. Cannot thank you enough. You are a saviour!!
A new Statistical series with Excel 2013 !!!! O U T S T A N D I N G !
Yes, and this 100 example video is just the first video in a long series! It should be fun!
Muchas gracias, desde México. Thank you very much sir, you are DA teacher. regards
I am glad that the video helps!
Dude, thank you for your generosity in posting all this. Your passion is infectious. :)
EXCELLENT video!!! Truly helpful.
EXCELlent!!! I am glad that the video was helpful. Thanks for your support with comment, Thumbs Up and Sub : )
thank you! this is so helpful. And I love how excited you are to share all this knowledge))
You are welcome, Aigerim!!
Epic and impressive video!!!
Thanks :-))
Merry Christmas and a happy new year :-)))
Merry Christmas and a Happy New Year to you too, O Masterful Excel Guy Bill Szysz!!! :)
you are too good, salute to you :)
omg I wish I had found this earlier!! This is reaally good!
No more comprehensive Excel tutorial can be found
Thank you very much for epic video.
Thank you so much! These videos are simply AMAZING
Am I at the start? Every ExcelIsFun RUclips 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!
Wow. Thanks very much.
You are welcome so much, Tamara!!! Thanks so much for your support with your comment, Thumbs up and Sub : )
Very informative..
Your awesome.. thanks
You are welcome!
I would like to thank you very much
You are a legend.
Not really, just a guy having fun with Excel!!! :)