Download Excel File: https://excelisfun.net/files/ETM1774.xlsm
Learn how stop references to PivotTable as showing up with GETPIVOTDATA Functions. Learn how to create formulas with cell references that refer to PivotTable.
Category: Excel
Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable?
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn what a Joint Probability Table is and how to create them with a PivotTable and Dynamic Spilled Array Formulas.
Topics:
1. (00:00) Introduction
2. (00:29) What is a Joint Probability Table
3. (01:58) Create Joint Probability Table Continue reading “Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable?”
Turn Off GETPIVOTDATA Function – EMT 1774
Download Excel File: https://excelisfun.net/files/ETM1774.xlsm
Learn how stop references to PivotTable as showing up with GETPIVOTDATA Functions. Learn how to create formulas with cell references that refer to PivotTable.
Excel Statistical Analysis 19: Conditional Probability 5 Examples
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn about:
Topics:
1. (00:00) Introduction
2. (00:40) Define Conditional Probability
3. (02:58) Calculate Conditional Probability From a Cross Tabulated Frequency Table using worksheet formulas
4. (05:38) Two ways to phrase a Conditional Probability statement.
5. (05:54) Key to understanding Continue reading “Excel Statistical Analysis 19: Conditional Probability 5 Examples”
Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn about Addition Law of Probability. See many examples of different situations where you use OR Logical tests and the Addition Law:
Topics:
1. (00:00) Introduction
2. (00:41) Look at formulas for Addition Law of Probability
3. (02:55) Continue reading “Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables”
Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm pdf notes: https://excelisfun.net/files/Ch04-ESA.pdf
Learn about the basics of Logical Tests: AND, OR and NOT. Lean how to count based on logical tests using COUNTIFS, FILTER and ROWS functions.
Topics:
1. (00:00) Introduction
2. (00:41) Continue reading “Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions”
Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm pdf notes: https://excelisfun.net/files/Ch04-ESA.pdf
Learn about the basics of probability:
Topics:
1. (00:00) Introduction
2. (00:58) Examples of Probability
3. (02:46) What is Probability? Define Probability.
4. (05:14) Types of Probabilities
5. (06:39) Define Random Experiment
6. (06:48) Define Continue reading “Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too”
Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468
TKH is using the new STOCKHISTORY function in Excel. He is looking for stock prices from 7, 14, 30, and 60 days ago. When you are asking for a single day, the STOCKHISTORY function returns a #VALUE error if the Continue reading “Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468”
Excel Doing Billions Of Calculations To Study Wordle
After my previous video showing AROSE as the best first guess in Wordle, I started doing some more cool Excel formulas to test all Wordle words. This is a long video for the weekend, mostly of me geeking out about Continue reading “Excel Doing Billions Of Calculations To Study Wordle”
New Excel Formula Editor Debuts – 2466
Big news today for Win / Mac / Online versions of Excel. A new Advanced Formula Editor will make LAMBDA and LET far easier. Among the highlights:
New Advanced Formula Editor (Windows, Mac, Online)
Share Lambda through GitHub
Better Recursion Limits (16x Continue reading “New Excel Formula Editor Debuts – 2466”
Highline College Advanced Excel – Busn 218 – Winter 2022 Quarter Introductory Video
Busn 218, Advanced Excel – Busn 218 (Spreadsheet Construction) class taught by Excel MVP Mike Girvin at Highline College. This is the intro video for matriculating students at Highline College in winter quarter, 2022.
This is the intro video for matriculating Continue reading “Highline College Advanced Excel – Busn 218 – Winter 2022 Quarter Introductory Video”
Excel Statistical Analysis for Business – Busn 210 – Winter 2022 Quarter Introductory Video
Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in winter quarter, 2022.
To watch at YouTube here is the playlist: rel=”nofollow”>https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
The videos for this class will be released each week over the next few months.