Excel Is Fun

Excel Magic Trick 1487

DESCRIPTION In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1483

DESCRIPTION In this video learn how to Lookup the correct product price based on the latest Effective Date. The Lookup table has multiple listings of the product, each with a different effective date and price. [Read More >>>]

Excel Is Fun

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 Is Fun

Excel Magic Trick 1471

DESCRIPTION In this video learn how to use Array Formulas to automate the reporting process for Rain Totals where the staring time for a day period changes. Topics: (00:01) Introduction and description of reporting requirements [Read More >>>]

Excel Is Fun

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 Is Fun

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 Is Fun

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 Is Fun

Excel Magic Trick 1452

DESCRIPTION See two methods: 1) PivotTable Method, 2) Array Formula Method. The PivotTable Method is the easy way to accomplish this. The Array Formula method is a difficult Array Formula, but it can make all [Read More >>>]

Excel Is Fun

Excel Magic Trick 1445

DESCRIPTION See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to create a single cell Array Formula that counts how many [Read More >>>]

Excel Is Fun

Excel Magic Trick 1444 Part 2

DESCRIPTION See how to use Excel Formulas to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight [Read More >>>]