MrExcel Excel Videos

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.

The Question Ed asks is: "How can I add new months to an existing XY Chart?" Today, in Episode #1353, Bill shows us the answer. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.

In today's "Learn Excel from MrExcel Podcast" David needs a formula that will set up live formulas that turn Data sideways. Episode #1352 provides the solution as Bill shows us a more efficient method for achieving the desired results. Learn Excel!

Ricardo has a Spreadsheet where active projects include live Formulas. Once a project is complete, he converts the Formulas to Values. He wants a way to mark all of the Cells which are still live Formulas by changing the color of the Cell's Data. Today, in Episode #1351, Bill shows us how to use a UDF [User Defined Function] to accomplish the task - using one (1) line of VBA [Visual Basic for Applications] to keep the process dynamic and reflect future changes in the Data Set. ...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...