How to do a 2 Way Lookup in Excel

Video Description: Mike & Bill take a look at various ways to do a 2-way lookup in this dueling Excel Episode 1124. How to do a 2 Way Lookup in Excel

Play

How to Add a Watermark Behind an Excel Spreadsheet

How can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of...

Play

How to Use 56 Colors in the Number Format in Excel

You can specify up to eight colors in the custom number format box. But wait...you can actually do all 56 colors from the Excel 2003 color palette! Episode 1142 shows you...

Play

How to Create 10 Year Stock Chart Using Excel

John asks how to take 10 years worth of stock data and convert it to a chart showing months across the bottom and a different line for each...

Play

SUBSTITUTE and REPLACE Excel Functions Tutorial

Shift-Del sends in some alternative formulas to solve the problem from episode 1043. To see uses of SUBSTITUTE and REPLACE in Excel, check out Episode...

Play

How to Consolidate Data - MrExcel's Learn Excel #929

Yet another solution to matching data from two different worksheets, the Data Consolidate command. Episode 929 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new...

Play

Learn Excel from MrExcel Episode 904 - Deleting Names

Mike from OK City asks how to delete all names in a workbook. In Episode 904, I will show you a way to delete all names or to delete only the invalid names. This video is...

Play

Learn Excel from MrExcel Episode 905 - Shade Half a Cell

an asks if it is possible to shade half of a cell. Episode 905 shows one cumbersome way to do it . This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel....