Excel Is Fun

Excel Magic Trick 1149

August 6, 2015 0

Dynamically Sum by Category without VLOOKUP Helper Column (2 methods) DESCRIPTION See how to: Dynamically Sum Costs by Category without VLOOKUP Helper Column: (00:47) VLOOKUP helper Column and SUMIFS function (03:10) Array Formula using SUMPRODUCT […]

Excel Is Fun

Excel Magic Trick 1148

August 3, 2015 0

Calculate Retirement Year Based On 80 Rule DESCRIPTION See how to: Formula To Calculate Retirement Year Based On 80 Rule: (00:55) DATEDIF function (02:44) Goal Seek (04:19) Destiny Williams Formula WORKBOOKS

Excel Is Fun

Excel Magic Trick 1147

July 30, 2015 0

Incorrect Formula To Calculate Retirement Year DESCRIPTION See how to: (00:07) 80 Rule For Retirement Age (00:48) Formula for Year of Retirement using YEAR function. (01:09) Wipe away Date Number Format by applying the General […]

Excel Is Fun

Excel Magic Trick 1146

July 27, 2015 0

Create ISO Dates using TEXT function and Custom Number Format DESCRIPTION See how to: 1. Create ISO Dates using TEXT function and Custom Number Format. Like; =TEXT(A5,”yyyymmdd”) 2. Compare two columns of formulas to check […]

Excel Is Fun

Excel Magic Trick 1145

July 23, 2015 0

Create Random Data Set with Formulas: 4 Unusual Formulas DESCRIPTION See how to: (00:08) Overview of Different data Types (01:02) FORMULA 1: Create Random Serial Number Dates with RANDBETWEEN and actual Serial Numbers (02:10) Keyboards […]

Excel Is Fun

Excel Magic Trick 1144

July 20, 2015 0

Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month DESCRIPTION See how to: (00:07) Text Function and Custom Number Formatting (01:08) Convert Serial Number Date To […]

Excel Is Fun

Excel Magic Trick 1143

July 16, 2015 0

Extract Content From Non-Empty Cells: Filter or Array Formula? DESCRIPTION See how to use Filter and Array Formulas to Extract Content From Non-Empty Cells: (00:39) Filter, Copy, Paste (01:26) Excel 2010 or later formula with […]

Excel Is Fun

Excel Magic Trick 1142

July 13, 2015 0

Get Every Other Row with Formula: INDEX and ROWS*2 DESCRIPTION See how to create a formula to Get Every Other Row with Formula using INDEX function and ROWS function. See how to increment the numbers […]

Excel Is Fun

Excel Magic Trick 1141

July 9, 2015 0

Link Access Table To Excel Data Source DESCRIPTION See how to Link Access Table To Excel Data Source. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1140

July 6, 2015 0

VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels DESCRIPTION See how to Create Text Formulas For Finance Tests where you can change the variables PV, APR, Years and compounding periods per […]