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

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

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

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

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

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

Excel Is Fun

Excel Magic Trick 1161

September 17, 2015 0

F4 Key To Repeat Last Action DESCRIPTION See how to use the F4 Key To Repeat Last Action

Excel Is Fun

Excel Magic Trick 1160

September 14, 2015 0

Jump To Next Change In Column: Go To Special, Column Difference DESCRIPTION See how to use Jump To Next Change In Column: Go To Special, Column Difference. Learn the keyboards to do this quickly