MrExcel's Learn Excel #950

Video Description: A big car company offered a boat load of money to put an annoying ad in this podcast for the next two months. Rather than sell out, a reminder that the podcast is sponsored by the MrExcel.com store. Then; a fast way to group age data using a pivot table. Episode #950 shows you how.

Play

MrExcel's Learn Excel #952 - Mouse to End

Laura from Wisconsin provides today's cool Excel trick: Double click any edge of the active cell and Excel will jump to the edge of the data. Episode 952 shows you how. This video is the podcast...

Play

MrExcel's Learn Excel #951 - EOMonth Sorting Word

Jamie shows how to use EOMonth to find the first of next month and Melanie shows how to sort paragraphs in Word. Episode 951 shows you...

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 921 - Workbook Sheets

Change the default number of worksheets in a new workbook using Excel 2007. Episode 921 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two...

Play

Learn Excel from MrExcel Episode 919 - Hiding Data

Jamie from Hampshire UK offers a better way for hiding data in cells. Rather than changing the font color to white, you can use this custom number format. Episode 919 shows you how. This video is...

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