Excel Is Fun

Excel Magic Trick 1204

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 [Read More >>>]

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

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

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

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

Excel Is Fun

Excel Magic Trick 1199

Formula to Extract Everything After Last Space: Two Formula Solutions DESCRIPTION See how to use Formula to Extract Everything After Last Space: (00:08) Problem Setup (01:05) Formula with TRIM, RIGHT, SUBSTITUTE, REPT, LEN and LEN [Read More >>>]

Excel Is Fun

Excel Magic Trick 1198

Median for Each Quarter Using AGGREGATE Function DESCRIPTION See how to calculate Median for Each Quarter Using AGGREGATE Function (00:08) Problem Setup (00:49) Defined Names for ranges using keyboard for Create Names From Selection: Ctrl [Read More >>>]

Excel Is Fun

Excel Magic Trick 1197

OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT? DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1196

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then [Read More >>>]

Excel Is Fun

Excel Magic Trick 1195

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some [Read More >>>]