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”
Duel 195 is scheduled for next Friday. For those of you who don’t want to go a week without a Dueling Excel podcast, Bill tries a reaction video to Duel 58 – Excel Sort by Formula – from December 2010.
Download Continue reading “Reaction Video To Duel 58 Sort With A Formula – 2373”
Three ways to filter a pivot table and two of them you might not have known about. Daniel Bula asks if the trick from episode # 2359 can be used in a pivot table. Here is a great pivot table Continue reading “Excel Illegal Filter Hack – South Region Over $5K – 2372”
Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: http://mrx.cl/spinwheel20
Rob had an idea of Continue reading “Download a Free Excel Macro to Spin The Wheel – 2371”
Download Excel File: https://excelisfun.net/files/EMT1710.xlsx
Learn how lookup the last invoice payment date from a data set based on an invoice number. See 5 examples that can work in any version.
Topics:
1. (00:00) Introduction.
2. (00:20) MAXIFS function solution. Excel 2016 Continue reading “Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710”