Media Summary: (00:11) Introduction to problem we want to solve and look back to Download Files: See how to use Conditional Formatting ...

Excel Magic Trick 1136 Correlation - Detailed Analysis & Overview

(00:11) Introduction to problem we want to solve and look back to Download Files: See how to use Conditional Formatting ...

Photo Gallery

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match
Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123
Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples
Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method
Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel
Excel Magic Trick 1132: Extract and Sort Numbers Greater Than Zero with Formula
Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT
Sponsored
Sponsored
View Detailed Profile
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together

Download

Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples

Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples

Also see these related videos:

Sponsored
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally

... https://www.youtube.com/playlist?list=PLrRPvpgDmw0kjL4875H36yNhWBb0f-nci

Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function

Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function

(00:11) Introduction to problem we want to solve and look back to

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

Download

Sponsored
Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Download

Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123

Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123

Download

Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples

Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples

Download

Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method

Download

Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel

Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel

Download

Excel Magic Trick 1132: Extract and Sort Numbers Greater Than Zero with Formula

Excel Magic Trick 1132: Extract and Sort Numbers Greater Than Zero with Formula

Download

Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

Download

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Download

Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR

Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR

Download

Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range

Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range

Download

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable

Download

Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References

Excel Magic Trick 516: Conditional Formatting Duplicates In Each Row COUNTIF & Mixed Cell References

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT516-523.xls See how to use Conditional Formatting ...

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Download

Excel Magic Trick 1120: Is Item in All Three Lists?

Excel Magic Trick 1120: Is Item in All Three Lists?

Download

Related Video Content

Office 365 login information

Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents,...

Microsoft Excel - Download information

Feb 16, 2026 · Microsoft Excel is built for organizing data, running calculations, and turning tables into decisions....

Microsoft Excel: Spreadsheets - Apps on Google Play information

Spreadsheets & Calculations • Create charts, budgets, project plans, accounting & financial analysis with Excel's...

Microsoft Excel - App Store information

Download Microsoft Excel by Microsoft Corporation on the App Store. See screenshots, ratings and reviews, user tips,...

Download Microsoft Excel for Windows, macOS, Android, APK ... - Gizmodo information

2 days ago · Microsoft Excel is a spreadsheet program from Microsoft and one of the core applications in the...