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

Learn how to Create Sparklines in Excel 2010

Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples in Excel 2010. This blog is the...

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

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 917 - Chart Background

Add a picture as a background for a chart in Excel 2007. Episode 917 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 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....