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

Friday, May 15, 2009

Dueling: Invert a Range - 1015 - Learn Excel from MrExcel Podcast

In today's dueling podcast, how to turn a range upside down. Episode #1015 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: , ,

Wednesday, May 13, 2009

Rolling Dynamic Charting - 1013 - Learn Excel from MrExcel Podcast

Andre provides a set of formulas to chart the last rolling six months of data. Episode 1013 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:

Wednesday, April 15, 2009

MrExcel's Learn Excel #993 - Dynamic Charting 1

Ally asks how to have a chart automatically extend as you type new data. The classic solution is to use a pair of dynamic named ranges using OFFSET. While this can be painful, Episode 993 shows how to set it up. Be sure to watch Episode 994 tomorrow for an easier way in Excel 2003-2007.

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, August 15, 2008

Episode 825 - Dynamic Pivot

Joe sends in a tip about converting your pivot table source data to a dynamic range. While this used to mean using the OFFSET function, now it simply means using Ctrl+L (in Excel 2003) or Ctrl+T (in Excel 2007). Episode 825 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: , , ,

Friday, March 21, 2008

Episode 720 - Dynamic Validation

Jonathan is frustrated that his validation scrollbars start in the midst of several blank cells that he set up in his validation list. He was doing this to allow room for future growth in the list.

Instead, Episode 720 will show you how to set up a dynamic named list using the OFFSET function.

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