### Excel Magic Trick 1345

December 19, 2017

DESCRIPTION See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods: (00:11) Introduction to Using Logical Formulas to Apply Conditional […]

### Excel Magic Trick 1327

October 3, 2017

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

### Highline Excel 2013 Class Video 40

June 16, 2017

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

### Highline Excel 2016 Class 03-03 PivotTables

September 24, 2016

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 105

September 21, 2016

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 Magic Trick 1201

April 18, 2016

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

### ROMAN, ARABIC Functions

November 22, 2015

WORKBOOKS

### AGGREGATE Function

November 21, 2015

WORKBOOKS

### CONVERT Function

November 20, 2015

WORKBOOKS

### RAND, RANDBETWEEN Functions

November 15, 2015

WORKBOOKS