MrExcel Excel Videos

The Excel Web App now offers a cool little trick that regular Excel can't do; you can embed a portion of your spreadsheet in a blog or other web page. Here is a challenge to try it out.

Jordan from MinusDesign sends in today's question: "How can you mix two icon sets in the same range?" Jordan wants to combined the green, yellow, red traffic lights with the pink, grey, and black traffic lights. Today, in Episode #1377, I harken way back to a Feb 2006 blog posting by David Gainer to solve this one. ...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 today's podcast, Tyler asks the easiest way to produce a report that contains the top 3 values for the most popular names - per each letter of the alphabet in alpha order. In Episode #1376, Bill shows us one method for solving the problem.

Today, in Episode #1375, Why doesn't the =CONCATENATE function accept a range? Why can't you specify a separator character? It is not that hard. Today's episode shows a simple macro using a defined function that would solve the problem.

Thomas asks if there is a better way to calculate Hours Worked. Thomas' data is imported from a web application, as Text. Today, in Episode #1374, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen try alternate formulas to solve the problem.

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.