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

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

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

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

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

Excel Is Fun

Excel Magic Trick 1250

DESCRIPTION Add Times to Get Total Minutes & Seconds From Downloaded Music Data Learn how to add times to show total minutes and seconds for copy and pasted downloaded music data. Learn about Time Math, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1236

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and [Read More >>>]

Dueling Excel

Dueling Excel 011

DESCRIPTION See Mr Excel and excelisfun create a formula that will randomly select a name from a list of names without having the list of names sitting in cells. See the functions INDEX, RANDBETWEEN, INT, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1168

Get Time Value From Date Time Value (2 Formula Examples) DESCRIPTION See how to Get the Time Value from a Date Time Value: (00:08) What is a Date Time? What is a Time in Excel? [Read More >>>]