Excel Is Fun

Excel Magic Trick 1090

January 14, 2015 0

DESCRIPTION See how to use the MEDIAN function is unusual ways that allow you to shorten the formula (for last two examples): (00:09) Deliver an OR Criteria Logical Value. (02:15) Payroll Tax calculation where there […]

Excel Is Fun

Excel Magic Trick 1089

January 13, 2015 0

DESCRIPTION Mr Excel did Month, Year To Date and Variances from data set with GETPIVOTDATA function. See excelisfun do it with Formulas Advanced Filter/Unique List. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1088

January 12, 2015 0

DESCRIPTION Show All B7 values From Across Sheets that are Named 01, 02, 03, …10, 11… using the functions: INDIRECT, TEXT and ROWS WORKBOOKS

Excel Is Fun

Excel Magic Trick 1087

January 11, 2015 0

DESCRIPTION (08:00) Number Outside range with lower and upper hurdle. Numbers below the lower hurdle OR above the upper hurdle. (01:25) OR function. OR Criteria: only one TRUE is necessary for OR function to deliver […]

Excel Is Fun

Excel Magic Trick 1086

January 10, 2015 0

DESCRIPTION 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble See how to:  (00:11 min) Create formula to lookup a value from a table with three criteria: INDEX and MATCH and […]

Excel Is Fun

Excel Magic Trick 1085

January 9, 2015 0

DESCRIPTION What if you are not allowed to have a helper columns to lookup Price and Region with VLOOKUP? And you need to calculate Total Revenue by Region? This video shows how to create a […]

Excel Is Fun

Excel Magic Trick 1084

January 8, 2015 0

DESCRIPTION See how to add every other column with the help of ISODD and the ISEVEN functions. Also SUMPRODUCT and COLUMN functions. Array Formula that does not require Ctrl + Shift + Enter because we […]

Excel Is Fun

Excel Magic Trick 1083

January 7, 2015 0

Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data DESCRIPTION See how to Add Invoice Amounts Between Start and End Dates using the SUMIFS function, a start and end date […]

Excel Is Fun

Excel Magic Trick 1082

January 1, 2015 2

Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data DESCRIPTION See how to add every other column using 1 or 4 formulas: (00:08 min) Manual method using SUM. See how […]