Excel Is Fun

Excel Magic Trick 1162

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, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1161

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

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

Excel Is Fun

Excel Magic Trick 1159

Extract Unique List For Data Validation List with Power Query DESCRIPTION See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown: (00:08) Problem Set, including showing how complicated Array Formula [Read More >>>]

Excel Is Fun

Excel Magic Trick 1158

Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013 DESCRIPTION See how to Get Millions of Rows of Data into Excel 2013 for a PivotTable without PowerPivot: (00:10) Problem Setup for Excel [Read More >>>]

Excel Is Fun

Excel Magic Trick 1157

Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula DESCRIPTION See how to use MEDAIN Function to calculate Mileage Costs at $0.40 Under or Equal to 10,000 Miles and $0.25 Over [Read More >>>]

Excel Is Fun

Excel Magic Trick 1156

Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods) DESCRIPTION See how to Count the “N” (New) and “U” (Used) for Each Sale (00:08) Problem Setup (01:08) Two COUNTIFS functions with Mixed [Read More >>>]

Excel Is Fun

Excel Magic Trick 1155

IF Function: Checking For Empty Cells (5 Methods) DESCRIPTION IF Function: Checking For Empty Cell & Zero Length Text Strings: (00:08) Problem Setup (00:56) IF function logical test using Zero Length Text String (checks for [Read More >>>]

Excel Is Fun

Excel Magic Trick 1154

Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) DESCRIPTION See how to Unique Count For Name & Date & Criteria From 3rd Column: (00:08) Problem Setup (00:50) Array Formula. Learn about IF [Read More >>>]

Excel Is Fun

Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove [Read More >>>]