Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Thursday, September 24, 2009

VBA Popup Pictures - 1108 - Learn Excel from MrExcel Podcast

John asks if there is a way to automate the process from Episode 322 of adding pop-up pictures to a cell. Today's Episode 1108 takes a look at the VBA code to add pop-up pictures to many cells.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Wednesday, August 26, 2009

2010 Picture Tools - 1088 - Learn Excel from MrExcel Podcast

Excel 2010 adds some new picture tools. Episode 1088 shows off some of the cool tricks in Excel 2010.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Tuesday, August 25, 2009

2010 Screen Clipping - 1087 - Learn Excel from MrExcel

New in Excel 2010, stolen from OneNote 2007 - the ability to insert a screen clipping into your worksheet. Episode 1087 shows you the two ways to use this new functionality.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Tuesday, July 21, 2009

Picture on Hover - 1062 - Learn Excel from MrExcel Podcast

Xiao asks how to have a picture appear when you hover over a cell. Episode 1062 shows how to solve this problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Wednesday, May 27, 2009

WIIW: Printable Background - 1023 - Learn Excel from MrExcel Podcast

Add a background picture to a worksheet that is printable and semi-transparent. Episode 1023 will show you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels:

Friday, January 30, 2009

MrExcel's Learn Excel #940 - Sort Pictures with Data

Steve wants to know how to sort pictures with the associated data. There is an obscure setting that controls if pictures sort with the cells or not. Episode 940 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,