Excel Is Fun

Excel Magic Trick 1426

DESCRIPTION See how to: (00:11) Introduction (00:51) Count Columns with COLUMNS Function (01:08) Count Rows with ROWS function (01:30) Count Unique Numbers using FREQUENCY and SUM Functions (04:41) Create Data Validation Drop Down List of [Read More >>>]

Excel Is Fun

Excel Magic Trick 1425

DESCRIPTION See how to use INDEX function & Number Increments to Convert 2-Way Table to Single Column Table: (00:11) Introduction (00:52) Copy Paste Trick to Convert 2-Way Table to Single Column Table (01:46) Number Increment [Read More >>>]

Excel Is Fun

Excel Magic Trick 1382

DESCRIPTION See how to: (00:15) Introduction to Contains Criteria (Partial Text Criteria) in an OR Logical Test, when search for records with Multiple Contains Criteria. (02:00) #1 Filter & Helper Column with Formula that uses [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 13

DESCRIPTION In this video learn about how to create a formula that can take One Lookup Value and Return Multiple Items. Learn about the INDEX and AGGREGATE Array Formula. See the functions: with INDEX, AGGREGATE, [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 1373

DESCRIPTION See how to Conditionally Format Every 5th Value and Extract Every 5th Value: 1. Introduction 2. Formula 1 for counting how many values will be extracted. ROWS & ROUNDDOWN Functions. 3. Formula 1 for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1355

DESCRIPTION See how to extract records from a vertical column that contains Parent Names in Bold and Children Names in “Not Bold” and display parent and children records horizontally. Learn about the GET.CELL Excel 4 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1346

DESCRIPTION See how to use formulas to extract records from a Master Table to Sub Tables on Each Excel Worksheets for each product in the Master Table: (00:17) Introduction. Look at Dynamic End Result Solution. [Read More >>>]