Dueling Excel

Dueling Excel 77

May 11, 2016 0

Top Two Customers In Each Industry PivotTable or Sort Filter Formula DESCRIPTION See Mr Excel and excelisfun extract Top Two Customers In Each Industry using a Pivot Table or Sort Filter & Formula with COUNTIF […]

Excel Is Fun

Excel Magic Trick 1204

May 9, 2016 1

Conditional Formatting For Day’s Change: Up & Down Icon Arrows DESCRIPTION See how to: Add conditionally format the change in error rate from day to day using the Green, Red and Yellow Arrow Icon Set […]

Dueling Excel

Dueling Excel 76

May 4, 2016 0

Worksheet With Hyperlinks That Jump To Each Sheet In The Workbook DESCRIPTION Another Dueling Excel week for Mr Excel & Excelisfun WORKBOOKS

Excel Is Fun

Excel Magic Trick 1203

May 2, 2016 1

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

Dueling Excel

Dueling Excel 75

April 27, 2016 0

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

April 25, 2016 0

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

Dueling Excel

Dueling Excel 74

April 20, 2016 0

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