Last week, in Episode #1411, Bill showed us how to use Pivot Table Slicers to display images. Today, in Episode #1417, Bill shows us how to set up the Dynamic Images in Excel Using Paste Picture Link with an OFFSET named range [to dynamically change the picture displayed].

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

Last week, in Episode #1411, Bill Challenged the audience to figure out how he was using the Pivot Table Slicer to update images in the Workbook he was using in the broadcast. Today, the question is answered and explained. Follow along with the Learn Excel from MrExcel Episode #1416 to learn how to employ this technique.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

As some of you know, Bill Jelen conducts ‘Learn Excel’ Webcasts for CFO Magazine. During a recent CFO Magazine webcast, Bill performed a Filter/Sort by color trick. Adam – one of the Webcast Audience members – liked the concept of filtering/sorting by color and now asks if there is any way to sum by color. In Episode #1415, Bill shows us a macro to do this.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

Today, Nick asks how to get the word ‘August’ in cell B1 from a date in cell A1. In Episode #1414, Bill shows us how to convert a date to a month name or to a weekday name using the TEXT function.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

Shawn has to do a four-way lookup: Worksheet, Row, Set of Columns, Column within the Set. To get the correct LOOKUP result, Bill shows a method using INDEX and INDIRECT to solve the problem posed in Episode #1413.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

David sends in today’s question…

David gets data from SAP that he loads into Excel. Some part numbers in the import data  just happen to look like dates and end up being converted to dates by Excel. Today, in Episode #1412, Bill discusses two ways to solve this problem.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions

Bill has returned from a long and productive writing hiatus with a new book, one less car, and a good story to tell. So today, in Episode #1411, Bill offers an opportunity… how is he using that Pivot Table Slicer to show pictures on a screen?? Figure it out and you can win the new book!

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel by Bill Jelen. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions