Excel VBA

Excel VBA File Dialogs

November 3, 2015 0

Excel VBA Introduction Part 24 – File Dialogs DESCRIPTION Using FileDialogs in VBA provides a convenient method for selecting files and folders and performing useful actions on them. This video covers how to use the […]

Excel Is Fun

Excel Magic Trick 1174

November 2, 2015 0

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]

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