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

Monday, November 16, 2009

Splitting Names - 1145 - Learn Excel from MrExcel Podcast

Diane from Michigan wants to split a column of names into two columns. Episode 1145 shows two approaches and the problems with each.

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: , , ,

Monday, September 07, 2009

VBA Sheet Name - 1096 - Learn Excel from MrExcel Podcast

Your recorded macros might not work if someone renames a worksheet. Rather than use the worksheet name, use the code name for the worksheet. This name can never be changed and is more reliable. Episode 1096 shows you how.

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: , ,

Monday, March 16, 2009

MrExcel's Learn Excel #971 - Insert Name Woes

Jennifer is relatively new to Excel and asks about using the Insert Name dialog. Any time that you are in the RefEdit field and hit a left or right arrow key to move within the formula, Excel starts inserting cell addresses. Episode 971 shows you how to turn off that annoying behavior.

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: