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

Excel Is Fun

Excel Magic Trick 1167

October 8, 2015 0

Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functions DESCRIPTION See how to Substitute Final Score If Greater Than Low Score using the MAX, MIN & SUM Functions. Adam Goodrich From […]

Dueling Excel

Dueling Excel 044

October 7, 2015 0

Count Mondays Between 2 Dates WEEKDAY or TEXT? DESCRIPTION See Mr Excel and excelisfun count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and […]

Excel VBA

Excel VBA Event Procedures

October 6, 2015 0

Excel VBA Introduction Part 20 – Event Procedures DESCRIPTION Writing Event Procedures allows you to create subroutines which run automatically in response to events in a workbook. This video teaches you how to access the […]

Excel Is Fun

Excel Magic Trick 1166

October 5, 2015 0

Count Dates From Date-Time Values: COUNTIFS or PivotTable? DESCRIPTION See how to Count Dates From Date-Time Values: COUNTIFS or PivotTable: (00:00) Look back to EMT 1163 to look at SUMPRODUCT and INT formula (00:45) COUNTIFS […]