Excel Magic Trick 456: Add Only Integer Part SUM & INT functions
Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT453-457.xls See how to use
Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable
Download
Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)
Download Files: Start
Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template
Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT628-635.xlsx Great
Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell
Download
Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard
Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT615-622.xlsm See how to
Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array
Download
Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods
Download
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Download
Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula
Many Amazing Formulas:
Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)
Download
Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions
Download
Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable
Download
