Excel Is Fun

Excel Magic Trick 1173

October 29, 2015 0

Conditional Format Dates When they are 90 Days of Set Expiration Date DESCRIPTION See how to use Logical Formula to Conditionally Format Dates When they are 90 Days of Set Expiration Date

Dueling Excel

Dueling Excel 047

October 28, 2015 0

Unlink Chart DESCRIPTION See Mr Excel and excelisfun unlink a chart: 1.Paste Special Picture 2.F9 key to convert SERIES function to static numbers WORKBOOKS

Excel VBA

Excel VBA Text Files

October 27, 2015 0

Excel VBA Introduction Part 23 – Text Files DESCRIPTION The Scripting Runtime Object Library allows you to write VBA code to create, open, read from and write to text files using very simple methods. This […]

Excel Is Fun

Excel Magic Trick 1172

October 26, 2015 0

Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT DESCRIPTION See how to: (00:38) INDEX and MATCH functions to lookup a column (00:50) Highlight non-contiguous ranges using Ctrl (03:13)¬†Enter Formula into non-contiguous ranges using […]

Excel Is Fun

Excel Magic Trick 1171

October 22, 2015 0

SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead DESCRIPTION See how to add for Text Number Criteria such as 0500 and 00500 using SUMPRODUCT rather than SUMIFS or SUMIF: (00:08) Problem […]

Dueling Excel

Dueling Excel 046

October 21, 2015 0

Lookup a value and Retrieve the two items to the Right INDEX & MATCH DESCRIPTION See Mr Excel and excelisfun: lookup a value and the retrieve the values 1 and 2 to the right of […]