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

Excel Is Fun

Excel Magic Trick 1426

DESCRIPTION See how to: (00:11) Introduction (00:51) Count Columns with COLUMNS Function (01:08) Count Rows with ROWS function (01:30) Count Unique Numbers using FREQUENCY and SUM Functions (04:41) Create Data Validation Drop Down List of [Read More >>>]

Excel Is Fun

Excel Magic Trick 1424

DESCRIPTION See how to calculate Average, Moving Average at Different Granularity in both DAX and Excel Formulas: (00:14) Introduction (00:27) What is Granularity? (02:15) Look at Data Model and Hide Columns from Client Tool (03:29) [Read More >>>]

Excel Is Fun

Excel Magic Trick 1404

DESCRIPTION See how to create a three-year Sales per Working Day by Month Report Where the Date Table lists the Working Days and the Sales Table will be updated with new data regularly: (00:10) Introduction [Read More >>>]