MrExcel Excel Videos

Learn Excel - Delete Hyperlinks: Podcast #1371

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.

View full article »

Learn Excel - MailTo Hyperlinks: Podcast #1370

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.

View full article »

Dueling Excel - Data Bars: Podcast #1369

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.

View full article »

Learn Excel - Formula Edit Fail: Podcast #1368

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.

View full article »

Learn Excel - Keep SmartArt in View: Podcast #1366

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.

View full article »

Learn Excel - Green Bay Packers: Podcast #1365

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.

View full article »

Learn Excel - Select and Concatenate: Podast #1364

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.

View full article »

Learn Excel- Insert Hyperlink vs =HYPERLINK: #1363

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.

View full article »

Learn Excel - Get Hyperlink Link Location: #1362

Today, in Episode #1362, Bill shows us how to paste links with the 'Friendly Name', and then extract the actual 'URL' from the link. Also learn how to easily remove unwanted buttons, and graphics that are inadvertently copied into your workbook.

View full article »