MrExcel Excel Videos

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.

When should you use the Insert Hyperlink compared to the =HYPERLINK() function? In Episode #1363, Bill compares the two methods. Also learn how to build 100's of hyperlinks by concatenating together some text in quotes with values in a column.