MrExcel Excel Videos

Last week, in Episode #1411, Bill Challenged the audience to figure out how he was using the Pivot Table Slicer to update images in a Workbook. Today, with Episode #1416, we learn how to employ this technique. Learn Excel 2010 from MrExcel

Adam liked my Filter/Sort by color trick on the recent CFO Magazine webcast. He asks if there is any way to sum by color. In Episode #1415, Bill shows us a macro to do this. "Learn Excel 2007 through Excel 2010 From MrExcel" - by Bill Jelen.

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.

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. Learn Excel 2010 by Bill Jelen

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.

Bill returns from a writing hiatus with a new book, one less car, and a good story to tell. Also, how is he using that pivot table slicer to show pictures on a screen? Figure it out and you can win the new book.

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...

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...

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.