### Excel Magic Trick 1493 Part 2

DESCRIPTION In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so [Read More >>>]

### Excel Magic Trick 1482

DESCRIPTION In this video learn how to Count with an OR Logical Test based on Three Columns. See a Pharmacy Data Set with Patient Data with the goal of counting how many patients are eligible [Read More >>>]

### Excel Magic Trick 1472

DESCRIPTION Learn about how to Topics: (00:11) Introduction (01:58) Ex 1: Between Upper & Lower Limits: =COUNTIFS Function (04:45) Ex 2: Between Upper & Lower Limits: =DCOUNT Function (07:00) Ex 3: Between Upper & Lower [Read More >>>]

### Excel Magic Trick 1467

DESCRIPTION Learn about how to Count Open Projects by Day and Project Code, Including Empty Cells with the following Complex Criteria: 1) Start Date Less Than or Equal To Date AND 2) Start Date NOT [Read More >>>]

### Excel Magic Trick 1463

DESCRIPTION Learn about how to Show Formula in Cell With Excel Functions FORMULATEXT & ISFORMULA. Topics in Video: (00:11) Introduction (01:19) FORMULATEXT & ISFORMULA & IF Functions to create formula to show formula in cell [Read More >>>]

### Excel Magic Trick 1462

DESCRIPTION Learn about how to create a single cell Array Formula to calculate Total Sales from a Column of Units Sold and a column of Prices (5,000 transactions). See how to use SUMPRODUCT function to [Read More >>>]

### Excel Magic Trick 1459

DESCRIPTION Learn how to create use SUMIFS and SUMPRODUCT functions to add the costs for each dog based on whether the expense is for Food or it is an Accessory. This video shows how to [Read More >>>]

### Excel Magic Trick 1457 Part 1

DESCRIPTION Learn about how different functions in Excel and Direct Operations interact and interpret Date and Time Values with the different Data Types: Number or Text. Learn how the Functions: SUMIFS, COUNTIFS, COUNT, SUM, EOMONTH, [Read More >>>]

### Excel Magic Trick 1453

DESCRIPTION Count Customer Totals Between Upper & Lower Limits For Each Month using an Excel Array Formula and the functions SUMPRODUCT and SUMIFS. Create a Cross Tabulated Frequency Distribution that shows a count of Customer [Read More >>>]

### Excel Magic Trick 1438

DESCRIPTION See how to use SUMIFS and SUMPRODUCT Functions to create a Cross Tabulated Table to add Sales with Sales Channel Criteria as the Row Header Criteria and Product Group OR Criteria as the Column [Read More >>>]