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”
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”
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”
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”
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”
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”
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”
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.
Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad racing at SeaTac BMX Track with Aaron “Trickster” Edwards and Eric “The Professor” Altendorf.
Then Nick Roth and Magic hit Burien BMX Park for some park fun!
Washington BMX Continue reading “Old Guy BMX Racing, then Park Riding: SeaTac BMX Track and Burien Park BMX: Rad Fun!”
Isaac “Iceman” Girvin, Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad at Tulalip BMX Skatepark on Sunday Sep 19, 2021. Not Big Air. No Big Tricks. Just Old Guys having fun! Old Guys Just Wanna Continue reading “Tulalip Skate-BMX Park Sunday Rad: Two Old Guys and a Kid!”
You wrote some IF functions to assign a score based on numerical ranges. You want to combine those formulas into a single long Excel formula. This video will show you how to do it and how to avoid some pitfalls.
Along Continue reading “How To Combine Multiple IF Formulas In Excel – 2465”
Your co-worker has an Excel formula and when you press Enter, you get “You’ve entered too many arguments for this function.” You can’t even get out of the formula.
Today, I show how the lowly Function Arguments Continue reading “Excel Will Not Let Me Enter This Formula – 2464”