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”
The F4 key in Excel has a dual life. Most people know F4 as the way to put dollar signs in a formula reference. But when you are not editing a formula, F4 will repeat the last command.
Some of you Continue reading “The F4 Key To Repeat Is My Favorite Excel Shortcut – 2460”
An update on video 2458. There is a setting about how Excel interprets a two-digit year. Microsoft changed this setting from 2029 to 2049. But Excel refuses to accept the 2049 setting. Unless you change the setting in Control Continue reading “The Two Digit Year Setting Does Not Work If You Never Change It – 2458B”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about how to use measures of variations to make decisions. Learn about variation visually, then learn how to calculate these measures of variation: Range, Variance, Standard Deviation, Coefficient of Variation.
Topics:
1. (00:00) Introduction
2. (00:51) Continue reading “Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation”
Download Excel File: https://excelisfun.net/files/EMT1772.xlsx
Learn how to perform Case Sensitive Lookup in Excel.
1. (00:00) Introduction
2. (00:05) Microsoft 365 Method with FILTER and EXACT functions.
3. (01:04) Any of the older versions of Excel: See Five Different formulas, including LOOKUP Continue reading “Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772”