WORKBOOKS & WORKSHEETS

Worksheet Basics

March 2, 2017 0

INTRODUCTION There are two types of worksheets. The standard worksheets that contains cells. Chart sheets which contain only graphs. ROWS AND COLUMNS Every standard worksheet layout consists of Rows and Columns. Rows numbered from 1 […]

Excel Is Fun

Excel Magic Trick 1260

January 9, 2017 0

DESCRIPTION VLOOKUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. Learn how to prevent VLOOKUP from returning a zero when it sees an empty cell in the lookup table: (00:12) Problem setup. (00:49) […]

Excel Is Fun

Excel Magic Trick 1238

October 13, 2016 0

DESCRIPTION Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples Learn how to check whether the content of multiple cells is the same for each cell: (00:11) Problem Introduction (00:40) […]

Dueling Excel

Dueling Excel 81

June 8, 2016 0

Extract Multiple Records Based on Two Criteria VBA or Formula DESCRIPTION See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS […]

Dueling Excel

Dueling Excel 78

May 18, 2016 0

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, […]

Excel Is Fun

Excel Magic Trick 1190

February 1, 2016 0

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

Dueling Excel

Dueling Excel 57

December 30, 2015 0

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, […]

Dueling Excel

Dueling Excel 046

October 21, 2015 0

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

Excel Is Fun

Excel Magic Trick 1170

October 19, 2015 0

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

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 07

April 7, 2015 0

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