MrExcel Excel Videos

In Today's Podcast, Episode #1373, Ram is using =CLEAN to get rid of the hard-return in a cell, but when he does this, he is losing the space between the words in that cell. Bill shows us how to use the =SUBSTITUTE function instead to yield a better result. ...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!

Today, Greg asks how to line up two reports that don't have similar column widths. Though this can be difficult, in Episode #1372 Bill shows us how to use the Paste Picture Link to solve this particular problem. "The Learn Excel from MrExcel Podcast Series" - from Bill Jelen ...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! Watch for announcements concerning the release of Bill's "Learn Excel 97 - 2010" - coming late spring 2010!

Hyperlink haters Episode #1371 is for you! I cover the following topics: Deleting one hyperlink; Deleting a range of hyperlinks with Excel 2010 new features; Deleting all hyperlinks with a 1-line macro; How to stop Excel from creating the hyperlinks.

Dave R shared a great hyperlink tip with Bill. Today, in Episode #1370, Build a Hyperlink with an email address; Use the =HYPERLINK Function, Concatenate your information and then click the link! It's simple and Bill shows us how to do it.

Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. in Excel 2010 and earlier versions of Excel. Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.

The Scenaro? Brendan created a cool Formula about six (6) months ago. He edited that Formula today and it won't work anymore. In Episode #1368, Bill shows you why and how to correct the issue.

Wyatt asks if there is a way to have SmartArt float above a worksheet and always stay in view. Today, in Episode #1366, Bill shows us how to create a short macro to solve the problem, although not perfectly. ...Learn Excel 97-2007 from MrExcel.

Today we look at a question posed in Episode #1358 "How did Mike and Bill predict the Super Bowl winner?" Bill gives us the answer in Episode #1365 - and announces the winner of the contest.

Today's Dueling Excel, with Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen [Episode #1364]looks at selecting specific entries in a row and then concatenating those entries in one cell.