Excel VBA

Excel VBA Files and Folders

October 20, 2015 0

Excel VBA Introduction Part 22 – Files and Folders DESCRIPTION The Scripting Runtime Object Library allows you to easily write code in an Excel VBA project which can manipulate the file and folder structure of […]

Excel Is Fun

Excel Magic Trick 1170

October 19, 2015 0

VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions DESCRIPTION See how to: (00:09) Problem Setup (01:40) COLUMNS Function with expandable range to get Sequential Numbers across the columns (02:17) CHOOSE Function to […]

Excel Is Fun

Excel Magic Trick 1169

October 15, 2015 0

Are Items In Row In Master List? Filter & Conditionally Format To Highlight DESCRIPTION See how to Match Ingredients for a Drink with the data base for all drink ingregients: (00:13) Problem Setup (00:35) MATCH […]

Dueling Excel

Dueling Excel 045

October 14, 2015 0

+ or with Formula or Custom Number Formatting Math Plus or Minus DESCRIPTION See Mr Excel and excelisfun: 1) create a formula to extract a number from a text string that can be used for […]

Excel VBA

Excel VBA User Forms

October 13, 2015 0

Excel VBA Introduction Part 21 – User Forms DESCRIPTION Designing a User Form in VBA is a great way to allow you users to interact with your workbook. This video teaches you how to create […]

Excel Is Fun

Excel Magic Trick 1168

October 12, 2015 0

Get Time Value From Date Time Value (2 Formula Examples) DESCRIPTION See how to Get the Time Value from a Date Time Value: (00:08) What is a Date Time? What is a Time in Excel? […]