Excel Magic Trick 1448

DESCRIPTION See how to create Conditional Formatting for Truck Arrival Dates that shows Blue when truck in unloaded, green when it less than 2 days since arrival, yellow when it is 2 days since arrival [Read More >>>]

Excel Magic Trick 1425

DESCRIPTION See how to use INDEX function & Number Increments to Convert 2-Way Table to Single Column Table: (00:11) Introduction (00:52) Copy Paste Trick to Convert 2-Way Table to Single Column Table (01:46) Number Increment [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 >>>]

Highline Excel 2016 Class 01

DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power Pivot (02:54) Examples of Effective and Efficient [Read More >>>]

Excel Magic Trick 1370

DESCRIPTION See how to Create Formula to Extract Each Item In List & Display In Every Third Column. Topics: (00:15) Introduction to Problem (01:03) Formula Element Number Incrementor to create pattern like: 1,1,1,2,2,2,3,3,3… See functions [Read More >>>]

Excel Magic Trick 1333

DESCRIPTION Learn about Banker’s Rounding or Gaussian Rounding: (00:15) What is Banker’s Rounding? (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding) (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and [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 >>>]

Dueling Excel 127

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings [Read More >>>]