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”
Wyn Hopkins built an Excel-based Wordle game. He saw my video on my Wordle Helper tool and challenged me to solve his game with my Excel file. The results are in.
Wyn’s video challenging me to play:
https://www.youtube.com/watch?v=D4uBZ8gdCTE
Wyn’s Continue reading “Answering Wyn Hopkins Wordle Challenge”
Download Excel File: https://excelisfun.net/files/EMT1773.xlsx
Learn how to create a searchable data validation dropdown list in Microsoft 365 Excel. Learn how to use the XLOOKUP function to lookup a price from a Product Price Lookup Table.
Learn how to.
1. (00:00) Continue reading “Searchable Data Validation Dropdown List & XLOOKUP function ā M365 Excel Magic Trick 1773”
Everyone has their theories on the best starting word for the Wordle game. A lot of people suggest ADIEU. But when you look at the frequency of each letter in the 8000 possible words, a better start word has Continue reading “Wordle Best Starting Words is AROSE not ADIEU – Episode 2463”
I love the Wordle game. One game a day. Three minutes. As I played for the first week, I wondered if Excel could help. It can!
Note that this workbook requires a recent Excel version due to the FILTER formula. You Continue reading “WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about how to use Power Query to import and transform data, use array formulas to create a 5-Number Summary, and who to create a Box & Whiskers Chart from a 5-column Improper Data Continue reading “Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas”
Sheet view in Excel is useful if multiple people are editing the same workbook. Say that one person wants to filter to Open orders and the other wants to see closed orders. One wants the data sorted descending and the Continue reading “How To Effectively Use Sheet View While Collaborating In Excel 2461”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about the z-score (number of standard deviations) and how to calculate it and use it in the Empirical Rule and Chebyshev’s Theorem.
Topics:
1. (00:00) Introduction to Z-Score
2. (01:23) Basics of Z-Score Calculations using math Continue reading “Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations”
I know of nine ways in Excel to Paste Values.
One of these is about to be wiped out by Microsoft and the Excel team.
I think all nine of them are important!
Here are the nine ways that I know of to Continue reading “Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values”