Excel Is Fun

Excel Magic Trick 1327

October 3, 2017 0

DESCRIPTION See how to create a Formula to Count Words in a Column with Mixed Data: Not COUNTA, but with COUNTIFS with the criteria “*?” (Count Text with One or More Characters) and NOT a […]

Excel Is Fun

Highline Excel 2013 Class Video 40

June 16, 2017 0

DESCRIPTION Topics in this video: 1. Built-in Conditional Formatting. Conditional Formatting to cells: A logical test that comes out TRUE or FALSE. TRUE = get Formatting. FALSE = Not get Formatting. 2. Highlight Cell Rules: […]

Excel Is Fun

Highline Excel 2016 Class 03-03 PivotTables

September 24, 2016 0

PivotTables What does a PivotTable do? PivotTables create summary reports that contain aggregate calculations with conditions/criteria. The words “Conditions”, “Criteria” and “Filter” are all synonyms for adding criteria to the calculations in a PivotTable. Example: […]

Dueling Excel

Dueling Excel 105

September 21, 2016 0

Count Between Words DESCRIPTION See Mr Excel and excelisfun use two methods to count between words using formulas and VBA. INDEX and MATCH and COUNTA functions to count between words WORKBOOKS

Excel Is Fun

Excel Magic Trick 1201

April 18, 2016 0

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