Media Summary: Download Files: Replace your IF function with a shorter ... Download Files: Start File: Finish File: ... Download Files: See how to extract records from a data ...

Excel Magic Trick 653 Boolean - Detailed Analysis & Overview

Download Files: Replace your IF function with a shorter ... Download Files: Start File: Finish File: ... Download Files: See how to extract records from a data ...

Photo Gallery

Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function
Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas
Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding
Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)
Excel Magic Trick #90: Consolidation
Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!
Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table
Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work
Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
View Detailed Profile
Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function

Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT648-660.xlsx Replace your IF function with a shorter ...

Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas

Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT648-660.xlsx See how to create

Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding

Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding

Download Files: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1333Start.xlsx Finish File: ...

Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

Download

Excel Magic Trick #90: Consolidation

Excel Magic Trick #90: Consolidation

Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTricks90.xls Finished File: ...

Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!

Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!

Download

Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table

Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table

Download

Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math

Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT458-465.xls See how to extract records from a data ...

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates

Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates

Download

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work

Download

Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)

Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods)

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 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Download