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

Lookup & Reference Functions

VLOOKUP and HLOOKUP

October 2, 2015 0

VLOOKUP function VLOOKUP is one of the lookup and reference functions you can use when you need to find things in a table or a range by row. For example, look up an employee’s last […]

Excel Is Fun

Excel Magic Trick 1165

October 1, 2015 0

Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Functions DESCRIPTION See how to Add 4 Tests Scores, But Substitute Final Score If Greater Than Low Test Score using the IF, MIN […]