Excel Is Fun

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

Dueling Excel

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 Is Fun

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

Dueling Excel

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 Is Fun

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

Dueling Excel

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 Is Fun

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