Today's podcast, Episode #1410, a direct message to all of our viewers, straight from Bill Jelen to you.

"I have some writing to get done, so I won't be in the office again until July 11, 2011. The podcast is going on hiatus until then."
  - Bill Jelen a.k.a. "MrExcel"

In lieu of new podcasts, we will be implementing reviews of previous podcast from Bill as well as some of the goings on in the MrExcel Universe. Be sure to catch us on Twitter (broadcasting the hashtag #excel and the @MrExcel profile) and Facebook during the hiatus! At the end of today's podcast check out the resource list of where you may view and or read more about Excel from MrExcel!

Thank you for viewing, following, subscribing, tweeting, posting, emailing and responding!! Your support is Most Excel-lent!!

Thank You! - The MrExcel Team

Finishing off the 'Learn Excel with MrExcel Podcast Series' on Charting Basics this week, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen look at The Title of the Chart we've created. Today, in Episode #1409, Bill shows us how to use Data from the Chart itself to Create a Dynamic Chart Title and Mike shows us two (2) variations on the theme. Also, in Episode #1409, you will learn a few Shortcuts and a few tips on better navigating the Excel 2010 User Interface while working with your Chart.

Dueling Excel Podcast #80…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

The Basics of Excel Charting: Part IV

This is the fourth of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously we'd set up our Data Set, Created our Chart and made adjustments to our Chart Axis. Today, in Episode #1408, Bill shows us how to Change our Chart Title, set up a comprehensive Legend and adjust the colors of our charted data.

…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

The Basics of Excel Charting: Part III

This is the third of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Previously, we'd set up our Data Set and proceeded into Creating our Chart; today we will look at changing our Chart Scale. Excel uses a setting called 'Auto' to figure out the low and high point along the edge of the chart. Many charting gurus suggest that you need to take more control over those settings. Today, in Episode #1407, Bill will show us how to change our Chart Scale or Chart Axis settings in Excel.

…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

The Basics of Excel Charting: Part II

This is the second of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Yesterday, we set up our Data Set to be used for the Chart. Today, in Episode #1406, Bill begins creating the Chart from the Data Set. Also, learn how to access your Charting Tools in Excel once your Chart is created.

…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

The Basics of Excel Charting: Part I

This is the first of a Four (4) Part series on the Basics of Charting with Microsoft Excel 2010. Today, in Episode #1405, Bill will begin by showing us the criteria for the Data Set we want to create our Chart with. By taking just words in a Microsoft Word Document, Bill will then proceed with the steps of Best Practice to get the Data from Word set up to create our Chart in Excel. Follow along to learn - from the ground up - how to proficiently Chart in Microsoft Excel 2010!

…This episode is the video podcast companion to the book, “Charts And Graphs: Microsoft Excel 2010“, by Bill Jelen a.k.a. MrExcel.

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Another Dueling Excel Podcast with Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen. Today, in Episode #1404, Mike and Bill look at finding the Percent of the Parent Row Total in Excel 2003, Excel 2007 and Excel 2010 using Formulas, PowerPivot and some easy to learn techniques.

Dueling Excel Podcast #79…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

The May 2011 MrExcel Challenge of the Month invites you to mash up some data from the Azure Data Market. This episode of the MrExcel Podcast demos getting data from ADM.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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

Today, in Episode #1402, Bill takes a look at Calculating a Weighted Average using two (2) SUMIF Functions. This Formula will need to reference Data on another worksheet as well. Learn about "SUMIF"!

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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

Today, In Episode #1400, Bill reviews "Change-Pro for Excel", by Litéra. This high-end tool will locate all of the changes between two versions of the same workbook. Follow along with Bill to see it work!

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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

Warren from Australia writes about choosing Lotto numbers, but =RANDBETWEEN(1,45) is giving him duplicates. Today, in Episode #1401, Bill shows us another way to solve the problem and further eliminate the probability of duplicates.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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

In Part I of "Top 2 by Industry", Episode #1394, Mike “ExcelIsFun” Girvin and Bill “MrExcel” Jelen showed us how to get the result. Today, in Episode #1399, Mike and Bill revisit the Top 2 method to compare formula methods for locating the top 2 amounts by industry.

Dueling Excel Podcast #78…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit MrExcel.com – Your One Stop for Excel Tips and Solutions.

Want to let others know that your Chart Data is current? Add a Live Title to that Chart to show that the Chart represents Data through the current date. In Episode #1398, Bill shows us how this is accomplished.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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

Most people know how to make a column wider...simple, right? Ok, so what happens when someone has turned off column headers? What can I do then? Today, in Episode #1397, Bill shows us what to do while discussing a variety of column width adjustment methods.

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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

The question many of us Excel users have asked at one time or another: "Why won't VLOOKUP add up all the matching results?" And the answer is simple: "Because it isn't supposed to."

Today, Episode #1396 will show us how to use the SUMIF function instead of VLOOKUP. Also included in today's episode... "Why it is important to lock the rows in your VLOOKUP table range."

…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!

For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.

“The Learn Excel from MrExcel Podcast Series”

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