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”
Download Excel File: https://excelisfun.net/files/ETM1771-Ch03-ESA.xlsm
Learn how calculate the Mode in the First Quartile of Data. Then see a formula to calculate the Mode for each quartile of data. Learn about the functions: FILTER, QUARTILE.INC, MODE.MULT, TRANSPOSE and LET.
Learn Continue reading “FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771”
It is a little-known feature that you can automatically break the text in an Excel Textbox into multiple columns. Here is how to find the setting.
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about calculating percentiles, quartiles, percentile rank and rank. Lean about two different algorithms for the percentile calculation. Learn about how to use eight different Excel built-in functions: ROWS, PERCENTILE.EXC, PERCENTILE.INC, MEDIAN, QUARTILE.EXC, QUARTILE.INC, Continue reading “Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms”
If you type a date with a two digit year, Excel treats anything up to 29 as being 2029. Once you get to 30, though, they assume you mean 1930. With 2030 only eight years away, it might be time Continue reading “Excel Fix 2029 Rule for 2-Digit Year – 2458”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about what the geometric mean is and how to use it. Great Historical Microsoft Stock Price Example.
Topics:
1. (00:00) Introduction
2. (00:37) Define Geometric Mean
3. (01:09) Look at variable in the formulas for calculating Geometric Continue reading “Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about how to calculate the weighted mean, or weighted average, a calculation done often in business and accounting. Learn all about the SUMPRODUCT function.
Topics:
1. (00:00) Introduction
2. () Weighted Mean Formula is just a Continue reading “Excel Statistical Analysis 10: Weighted Mean. Awesome Accounting Example!!”
Exploring the Microsoft/NASA Day of Data Dataset from https://techcommunity.microsoft.com/t5/day-of-data/bd-p/DayofData
Today (November 1, 2020) marks 20 continuous years of having a human on the International Space Station (ISS). For today’s video, I explore the NASA data set to see: Continue reading “Have There Really Been Someone On The ISS For The Last 20 Years – Episode 2377”
To play along, read the trivia questions and download the data set here: https://techcommunity.microsoft.com/t5/day-of-data/space-trivia/m-p/1781544
In case you have problems solving any of the trivia questions, I’ve created a video showing the answers. Jump to the section for any Continue reading “Answers to Day Of Data Space Trivia Questions”