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

Excel Is Fun

Excel Magic Trick 1399

DESCRIPTION See how to Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1391

DESCRIPTION See how to create a formula to perform Case Sensitive Lookup: (00:10) Introduction (00:16) VLOOKUP by itself will NOT work. (01:19) Formula #1: SUMPRODUCT & EXACT functions to lookup Numbers based on a Case [Read More >>>]

Excel Is Fun

Excel Magic Trick 1390

DESCRIPTION See how to calculate Average Number of Days Between Dates in a Single Column: 1. Introduction 2. Helper Column and AVERAGE Function 3. AVERAGE Function Array Formula. Requires Ctrl + Shift + Enter 4. [Read More >>>]