### 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 Magic Trick 1469

DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period. Topics: (00:11) [Read More >>>]

### Excel Magic Trick 1373

DESCRIPTION See how to Conditionally Format Every 5th Value and Extract Every 5th Value: 1. Introduction 2. Formula 1 for counting how many values will be extracted. ROWS & ROUNDDOWN Functions. 3. Formula 1 for [Read More >>>]

### Excel Magic Trick 1359

DESCRIPTION Learn about the basics of the VLOOKUP Function and about Time Values in Excel. Topics in this video: (00:12) Introduction to goal of video (01:08) Build Lookup Table with Time Values/Time Categories (8 Equal [Read More >>>]

### Dueling Excel 134

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to [Read More >>>]

### Dueling Excel 132

DESCRIPTION See Mr Excel and excelisfun use two methods to convert from the numbers 10.1 and 10.2 to 10.333 and 10.667, and the reverse using two methods: 1. DOLLARDE and DOLLARFR functions 2. MOD and [Read More >>>]