MrExcel Excel Videos

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.

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

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.