Excel Is Fun

Excel Magic Trick 1404

DESCRIPTION See how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly: (00:10) Introduction [Read More >>>]

Excel Is Fun

Excel Magic Trick 1399

DESCRIPTION See how to Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula. WORKBOOKS

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

Excel Magic Trick 1390

DESCRIPTION See how to calculate Average Number of Days Between Dates in a Single Column: 1. Introduction 2. Helper Column and AVERAGE Function 3. AVERAGE Function Array Formula. Requires Ctrl + Shift + Enter 4. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1389

DESCRIPTION See how to create a Single Cell Non-Array Formula that does not need a Helper Column to calculate Average Number of Days Between Two Columns of Dates. This formula comes from Tejendra Purohit at [Read More >>>]

Excel Is Fun

Excel Magic Trick 1388

DESCRIPTION See how to calculate the Average Number of Days Between Order Date & Ship Date with three different methods: (00:10) Introduction (00:25) Helper Column Method & AVERAGE Function (02:22) Array Formula #1: AVERAGE Function [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

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