Dueling Excel

Dueling Excel 043

September 30, 2015 0

End Inventory Value From Transactional Records SUMPRODUCT SUMIF DESCRIPTION Mr Excel is on hiatus to finish his new Excel 2010 books. Excelisfun shows how to calculate Weighted Average Cost Ending Inventory Value from Transactional Records […]

Excel VBA

Excel VBA Error Handling

September 29, 2015 0

Excel VBA Introduction Part 19 – Error Handling DESCRIPTION Almost every procedure you write in VBA has the potential to go wrong at some point! Writing error handling code allows your procedures to fail gracefully […]

Excel Is Fun

Excel Magic Trick 1164

September 28, 2015 0

Average Score After Subtracting Two Lowest: SMALL & Array or AVERAGEIF? DESCRIPTION See how to calculated the average for quiz scores after subtracting the two lowest (00:08) Problem Setup (00:22) Status Bar Trick (00:50) Convert […]

Excel Is Fun

Excel Magic Trick 1163

September 24, 2015 0

COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. DESCRIPTION See how to: (00:10) COUNTIFS with Date Criteria that is matched up against a column with Data Times will not work. (00:55) Examine […]

Dueling Excel

Dueling Excel 042

September 23, 2015 0

Lookup Picture In Excel Formula or VBA? DESCRIPTION See Mr Excel and excelisfun lookup a picture in Excel. See a VBA solution and a Formula Solution using the INDIRECT function and named ranges. See many […]

Excel VBA

Excel VBA Creating Functions

September 22, 2015 0

Excel VBA Introduction Part 18 – Creating Functions DESCRIPTION A VBA function is a procedure that can return a value and this video teaches you how to create them. You’ll learn how to declare a […]

Excel Is Fun

Excel Magic Trick 1162

September 21, 2015 0

Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick DESCRIPTION For a column with Dates or Empty Cells, see how to run an inventory balance formula when a date is entered, […]

Formulas & Functions

AutoSum

September 19, 2015 0

WORKBOOKS