Excel Is Fun

Excel Magic Trick 1292

May 1, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas based on a proper lookup table created with Power Query (Excel 2016 Get and Transform): (00:12) Problem Introduction (00:50) Use Power Query […]

Excel Is Fun

Excel Magic Trick 1291

April 27, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas: (00:13) Problem Introduction (01:50) Formula 1: Lookup correct letter for each answer. An array Operation, COLUMN function, SUMPRODUCT function and INDEX Function. […]

Excel Is Fun

Excel Magic Trick 1290

April 24, 2017 0

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database […]

Excel Is Fun

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

Excel Is Fun

Excel Magic Trick 1271

February 16, 2017 0

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]

Excel Is Fun

Excel Magic Trick 1238

October 13, 2016 0

DESCRIPTION Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples Learn how to check whether the content of multiple cells is the same for each cell: (00:11) Problem Introduction (00:40) […]

Excel Is Fun

Excel Magic Trick 1236

October 6, 2016 0

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and […]

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