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 […]

Dueling Excel

Dueling Excel 005

January 6, 2015 0

DESCRIPTION See Mr Excel and excelisfun try and create Horizontal Subtotals for a data set. See the IF, SUM and SUMIF functions as they try to solve this very difficult problem. Also see Conditional Formatting […]

Dueling Excel

Dueling Excel 004

January 5, 2015 0

DESCRIPTION See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values WORKBOOKS

Dueling Excel

Dueling Excel 003

January 4, 2015 0

DESCRIPTION See Mr Excel and excelisfun demonstrate three methods to count words that contain the letter D: 1) Filter & SUBTOTAL 2) Table & SUBTOTAL 3) COUNTIF and criteria syntax Count with criteria conditions. Use […]

Dueling Excel

Dueling Excel 002

January 3, 2015 0

DESCRIPTION See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a column of values: Mr Excel: Create formula for remaining percentage (1 + decrease), copy remaining percentage, Paste Special, Operations Multiply, Values. […]