Excel Is Fun

Excel Magic Trick 1231

September 19, 2016 0

DESCRIPTION VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? Learn how to: (00:12) Introduction to problem we want to solve. (01:52) CHOOSE Function Solution, with VLOOKUP and MATCH functions and the asterisk wild […]

Excel Is Fun

Highline Excel 2016 Class 02

July 24, 2016 0

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) DESCRIPTION In this video learn about: (00:13) Introduction (01:09) Excel’s Golden Rule (04:31) Look at list of Formula Types and Formula Elements (06:29) Number Formula Examples (08:24) Text […]

Excel Is Fun

Excel Magic Trick 1214

July 18, 2016 0

How To Enter Text Criteria Into Excel Database Functions DESCRIPTION See how to Enter Text Criteria Into Excel Database Functions using a Text Formula with the Comparative Operator Equal Sign. See these Examples: (00:09) Text […]

Excel Is Fun

Highline Excel 2016 Class 01

July 16, 2016 0

Excel Fundamentals: Efficiency, Data, Data Sets, Formatting DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power […]

Dueling Excel

Dueling Excel 84

June 29, 2016 0

Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit DESCRIPTION See Mr Excel and excelisfun use two methods to count calls every 15 minutes: 1. a PivotTable and a Helper Column using […]

Excel Is Fun

Excel Magic Trick 1197

March 21, 2016 0

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

Excel Is Fun

Excel Magic Trick 1196

March 14, 2016 0

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

Dueling Excel

Dueling Excel 68

March 9, 2016 0

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS […]

Excel Is Fun

Excel Magic Trick 1193

February 22, 2016 0

Count Distinct Words As They Are Entered In Column: Formula or Excel Table? DESCRIPTION See how calculate a running count for each unique (distinct) text items entered in column using two methods: (00:10) Problem setup […]

Excel Is Fun

Excel Magic Trick 1182

December 7, 2015 0

COUNTIFS and Wildcards to Count When There are 4 or More Characters DESCRIPTION See how to use COUNTIFS and Wildcards to Count When There are 4 or More Characters with a formula from Bill Szysz […]