Excel Is Fun

Excel Magic Trick 1190

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for [Read More >>>]

Dueling Excel

Dueling Excel 57

Extract Many Years from Just Two Years DESCRIPTION See Mr Excel and excelisfun take the text string “1997-2000” and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, [Read More >>>]

Dueling Excel

Dueling Excel 046

Lookup a value and Retrieve the two items to the Right INDEX & MATCH DESCRIPTION See Mr Excel and excelisfun: lookup a value and the retrieve the values 1 and 2 to the right of [Read More >>>]

Excel Is Fun

Excel Magic Trick 1170

VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions DESCRIPTION See how to: (00:09) Problem Setup (01:40) COLUMNS Function with expandable range to get Sequential Numbers across the columns (02:17) CHOOSE Function to [Read More >>>]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name [Read More >>>]

Excel Is Fun

Excel Magic Trick 1113

DESCRIPTION 1. Text To Columns using Fixed Width, One Time Event 2. Formula that will update when data changes. Formula uses MID and COLUMNS functions and Mixed Cell References. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 20

DESCRIPTION Topics in this video: (00:15) VLOOKUP to retrieve whole record change columns manually. (02:20) VLOOKUP to retrieve whole record column number in cell. (03:43) VLOOKUP & MATCH to retrieve whole record — more dynamic [Read More >>>]