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”
Highline College Busn 210 Statistical Analysis with Excel Intro Video, Winter 2021
Highline College Busn 135 Winter 2021 Intro Video
Download Excel File: https://excelisfun.net/files/EMT1709.xlsx
Learn how to list off ASCII and Unicode characters in Excel. Why? To help to understand sorting and to make useful Text Formulas. See how to make a professional Text Formula to Document Formulas Continue reading “Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709”
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about the Measures of Central Location: Mean, Median, Mode and Moving Average. Learn about Skew. See how to use Power Query to import covid 19 data, calculate the 7-day moving average and plot Continue reading “Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!”
Download Excel File: https://excelisfun.net/files/EMT1770.xlsx
Learn how the basics of how to use the LET function and define variables within the formulas with repeating formula elements more efficient. Learn how to use LET and six other functions to create Continue reading “Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770”
Tina C asks if there is a better way to add a page break every 35 rows. Way back in episode 360, I showed a few methods. But today, one line of VBA in the Immediate Window seems much easier. Continue reading “Excel Page Break by Rows with VBA”
Download Excel File: https://excelisfun.net/files/EMT1769.xlsx
Learn Accounting and Financial Spilled Array Formulas when the formula uses a Relative Cell Reference, One Cell Above, as an Accumulator like in investment value from period to period (multiplicative) or a checkbook balance Continue reading “SCAN & LAMBDA to Simulate Relative Cell Reference, One Cell Above in Spilled Array Formula. EMT 1769”
Evil Angel on YouTube asks if you can do a VLOOKUP in a Pivot Table Calculated Field. I am fairly sure this won’t work in a regular pivot table based on the pivot table cache. But if you build a Continue reading “Excel VLOOKUP In Pivot Table Calculated Field? – 2456”