Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn how to create a Cross Tabulated Report using a PivotTable and the appropriate visualizations. Lean about in the internal calculation in a cross tab report: AND Logical Test. Learn about how a hidden Continue reading “Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about creating frequency distributions and visualizations for quantitative data, including Column Charts for Discrete Data, Line and Clustered Column charts for Date Data and Column Chart Histograms for Continuous Data.
Topics:
1. (00:00) Introduction
2. (00:35) Continue reading “Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about creating Frequency Distributions & Column and Bar Chart Visualizations for Categorical Data. See an Epic Summary of EVERYTHING you need to know about Column and Bar Charts.
Topics:
1. (00:00)
2. (00:22) Download Excel
3. Continue reading “Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data”
ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Download CSV File: https://excelisfun.net/files/Ch01-ESA-AutoData.csv
Learn about how to use Power Query to import and transform CSV File data Continue reading “Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions”
You have a column of data in Excel. You need to reverse the column, bottom to top.
How can you do this? Can you do it without a helper column?
Bill Jelen and Mike Girvin compare six ways
Table of Contents
(0:00) Description Continue reading “Reverse A Column In Excel – With Mike Girvin – Duel 196”
Download Excel File: http://excelisfun.net/files/Flip_A_Column_In_Excel_Duel_196.xlsx
Learn how to flip on column in Excel. See Microsoft 365 Excel formulas, Worksheet Formulas that work in any version of Excel, Spilled Array with Old School functions, Custom List and Secret Sort Trick, Continue reading “Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun”
There is a classic Financial Modeling problem in Excel. You are checking values in each month and you end up with a row of zero and one values. How can you find the last month where you have a one?
Dan Continue reading “Find The Last One In A Series Of 1s And Zeroes With Dan Mayoh – 2445”
Download Excel File: https://excelisfun.net/files/EMT1765.xlsx
Learn how to convert a horizontal range of labels to a vertical numbered list of labels. Learn how to do it with a formula in Microsoft 365 Excel and an “Old School” method that Continue reading “Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765”
Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad at Lake Stevens BMX Skatepark on Sunday November 21, 2021. No big tricks, just Old Guy BMX fun!
Washington BMX Old Guy Adventure 13.
ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Download CSV File: https://excelisfun.net/files/Ch01-ESA-AutoData.csv
Learn about how to use Power Query to import and transform CSV File data Continue reading “Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions”
How can you reverse text in Excel? There is not a REVERSE function. You’ve recently seen me do this with a VBA loop. Lianna Gerrish from the Financial Modeling World Cup Semi-Finals would flip it and reverse it with strREVERSE Continue reading “Excel Search In Reverse (Jenny) – feat. Tommy Tutone – 2444”
Matching data between two Excel worksheets where you need to match both the city and the tax rate in order to find the match. This video shows three different methods.
Table of Contents
(0:00) Welcome
(1:01) Using XLOOKUP for two-way match
(2:15) Using VLOOKUP Continue reading “Excel Two Way Lookup Three Ways – 2443”