MrExcel Excel Videos

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.

Today, Bill continues to look at Hyperlinks in Microsoft Excel - like when you paste a column of website addresses into Excel, none of them automatically turn into a hyperlink. Episode #1361 looks at a couple of solutions to make your hyperlinks hot.

Today's Question: "How can I select a cell that contains an active hyperlink without actually clicking and following the hyperlink?" Bill shows us two solutions in Episode #1360. Learn Excel 97-2007 from MrExcel.

Bill thinks he has a 'killer solution' for this Dueling Podcast - lets find out! Today, in Episode #1359, Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen find solutions that will Round Dollars to (2) decimals, but Round Crude to (4) Decimals.

In early November of 2010, Episode #1278 should have been broadcast. That particular Podcast was showing the use of the LINEST Function with NFL statistics to predict who would win the next super bowl! Unfortunately, this formula worked well, but...

On the heels of Bill's last Podcast ["Changing Case in Excel: Lower, Upper, Proper: Podcast #1356"] Episode #1357 shows us the methods for converting text to Upper Case, Lower Case, or Proper Case in Excel using a VBA [Visual Basic for Applications] Macro.

Microsoft Word gives you a command to convert text to Upper or Lower case. There is no such command in Excel. Today, in Episode #1356, Bill shows us one of two methods for converting text to Upper Case, Lower Case, or Proper Case in Excel. ...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! For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions.

Some actions in the Excel Interface cause an Alert to appear- such as the "Are you sure you want to delete this worksheet?" message. These alerts can be annoying when employing a Macro. Today, Episode #1355 takes a look at how to remove that alert.

In Today's Dueling Podcast Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen look at Counting The Number of Days Between Two Dates - not including Saturdays. The Duel becomes a Team Effort today as Mike and Bill work with a variety of Functions.