Answering Wyn Hopkins Wordle Challenge

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”

Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773

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”

Wordle Best Starting Words is AROSE not ADIEU – Episode 2463

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”

WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462

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”

Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas

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”

How To Effectively Use Sheet View While Collaborating In Excel 2461

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”

Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations

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”

Urgent Need To Protect Paste Values! Survey: How Do YOU Paste Values

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 To Repeat Is My Favorite Excel Shortcut – 2460

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”

The Two Digit Year Setting Does Not Work If You Never Change It – 2458B

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”

Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation

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”

Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772

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”