### Excel Magic Trick 1203

2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change DESCRIPTION See how to: (00:08) Problem Setup: 2 Slicers Control 4 PivotTables: Sum, Running Total, Change and % Change (00:48) Create PivotTable (01:21) [Read More >>>]

WORKBOOKS

### Dueling Excel 75

Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS

### Excel Magic Trick 1202

Conditional Formatting For a Cross Tabulated PivotTable DESCRIPTION See how to add Conditional Formatting to a Cross Tabulated PivotTable: (00:08) Problem Setup (00:28) Set up PivotTable including Group by Year for Date column and Number [Read More >>>]

WORKBOOKS

### Dueling Excel 74

Dynamic Range For VLOOKUP & Data Validation List – Table Feature DESCRIPTION See Mr Excel and excelisfun use the Excel Table Feature to create dynamic ranges for Data Validation List and VLOOKUP function. WORKBOOKS

### Excel Magic Trick 1201

Conditional Format Product With No Sales (5 Examples) DESCRIPTION See how to: (00:08) Problem Setup (00:43) Format Product with NO Sales: COUNT & =0 (02:46) Format Product with NO Sales: COUNT & NOT (Any non-zero [Read More >>>]

WORKBOOKS

### Dueling Excel 73

Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time [Read More >>>]

### Excel Magic Trick 1200

Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) DESCRIPTION See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons [Read More >>>]