Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm
Learn how to build Discrete Probability Distributions, Expected Value and Standard Deviation with Worksheet Formulas.
Topics:
1. (00:00) Introduction
2. (00:20) Look at Data Sets from Video #6 and PivotTable Method to create Probability Distributions
3. (00:46) Example Continue reading “Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas”
Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about:
Topics:
1. (00:00) Introduction.
2. (00:40) Define: Random Variable.
3. (01:40) Define: Discrete and Continuous Random Variables.
4. (03:55) Define: Probability Distribution and Discrete Probability Distribution.
5. (04:36) Three ways to Continue reading “Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions”
Download Excel File: https://excelisfun.net/files/EMT1776.xlsx
Learn extract invoice that are past due 1 to 30 days using Power Query..
Learn how to.
1. (00:00) Introduction
2. (00:26) Bring Defined Name Parameter into Power Query with number of days.
3. (01:15) In Power Query, Continue reading “Power Query: Extract Records For Invoices 1 to 30 Days Past Due – EMT 1778”
Download Excel File: https://excelisfun.net/files/EMT1777.xlsx
Learn about the situations where you can spill results from SUMIFS, COUNTIFS, MINIFS, MAXIFS and AVERGAEIFS.
Learn how to.
1. (00:00) Introduction
2. (00:50) COUNTIFS function example that CANNOT Spill
3. (01:44) COUNTIFS function example that CAN Spill
4. Continue reading “COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777”
Antony in Toronto brings us two more Excel AutoSum Oddities.
This was part of my hour-long session on Excel Oddities, Curiousities and Mysterious Wonders for the Vancouver Modern Excel Users Group. Watch the entire hour here:
https://youtu.be/H7rSetB7IRo?t=277
Doug from Boston needs to calculate an age in Excel.
Two easy formulas today: YEARFRAC and DATEDIF.
Download Excel File: https://excelisfun.net/files/EMT1776.xlsx
Learn how to build a simple formula to automatically extract invoices that are 1 to 30 days past .
Topics:
1. (00:00) Introduction
2. (00:27) History about how to do it in Any Version of Excel.
3. (02:02) Continue reading “Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method – EMT 1776”
Today’s question from Ken: I’ve lost a slicer. I know it is somewhere on the worksheet, but how can I find it?
Thanks to Lou Pham, we have an answer. Use Home, Find & Select, Selection Pane. Select the object. Press Continue reading “F2 To Bring Selected Object Back Into View in Excel – 2471”
Download Excel File: https://excelisfun.net/files/EMT1775.xlsx
Learn 3 formula methods to add the top three values.
Learn how to.
1. (00:00) Introduction
2. (00:12) Look at the issues that make this problem difficult
3. (00:59) 1st solution: SUM, LARGE and SEQUENCE solution
4. (01:10) 1st Continue reading “Sum Top 3 Values When There Is Missing Data – 3 Unbelievable Solutions (LAMBDA too) EMT 1775”
Gagan has sales for three years. For each month in those three years, what is the first date that had a sale? For some reason, Gagan needs to do this without a helper column.
My first solution is a pivot table Continue reading “Excel – Find The Date Of The First Sale In Each Month – 2470”
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn about 6 different methods for calculating probabilities using Bayes Theorem.
Topics:
1. (00:00) Introduction
2. (00:16) Introduction to Baye’s Theorem with a CPA Test Score Example
3. (03:17) Probabilities from Table of Data using Worksheet Formulas and Continue reading “Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function”
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn about the Multiplication Law of Probability to calculate AND Logical Test Probabilities. Learn how to build a probability tree too.
Topics:
1. (00:00) Introduction
2. (00:17) Look back at Conditional Formatting Probability Rule and how it Continue reading “Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree”