Excel Is Fun

Excel Magic Trick 1400

DESCRIPTION See how to Conditionally Format the row in an Enrollment Table when the following conditions are met: 1. Enrollment less than or equal to 15, then format row 2. Name Column can NOT contain: [Read More >>>]

Excel Is Fun

Excel Magic Trick 1394

DESCRIPTION See how to use formulas to calculate “PivotTable Show Values As: Calculations: (00:14) Introduction to unusual formulas for standard PivotTable Show Values As Calculations (01:29) Total Revenue Formula for either Product or Manufacturer in [Read More >>>]

Excel Is Fun

Excel Magic Trick 1391

DESCRIPTION See how to create a formula to perform Case Sensitive Lookup: (00:10) Introduction (00:16) VLOOKUP by itself will NOT work. (01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1383

DESCRIPTION See how to Conditionally Format each row in a Data Set that has a Job Title that contains any text item from within a list. Learn about “Contains Criteria” in an OR Logical Test: [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 12

DESCRIPTION In this video learn about: (00:13) Introduction (00:30) Helper Column Solution with Join Operator and VLOOKUP (03:31) Array Formula with: INDEX and MATCH functions and a Join Array Operations. This formula requires Ctrl + [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 11

DESCRIPTION In this video learn about: (00:12) Introduction (00:51) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice. (09:43) HLOOKUP with Exact Match Lookup. Goal: Lookup Tyrone’s Phone Number. Horizontal Lookup [Read More >>>]

Excel Is Fun

Excel Magic Trick 1377

DESCRIPTION See how to create a formula to list incomplete / missing student assignments: (00:11) Introduction (01:14) Formula to count missing assignments for a particular student using: 1) INDEX & MATCH functions to lookup a [Read More >>>]

Excel Is Fun

Excel Magic Trick 1376

DESCRIPTION See an amazing formula from Bill Szysz at YouTube to create a Description Column for a transaction table. Thanks to Michale Diamond for the good question. See the formula elements: Shirking Range (Contracting Range), [Read More >>>]

Excel Is Fun

Excel Magic Trick 1372

DESCRIPTION See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]