MrExcel Excel Videos

Episode #1381, Michael asks, "How can I group a Pivot Table up to Quarter Hours?" There is no ideal way to do this in the Pivot Table or in PowerPivot. Bill shows us how to add a Formula to the original Data Set to solve the problem. Learn Excel!

In Episode #1380, Bill looks at =RANK. Excel 2010 makes it easy to Rank a Column in a Pivot Table. Although...the way that Pivot Tables handle ties is different than how the RANK function handles ties. Watch the podcast and learn a bit about =RANK.

Today's Dueling Podcast asks: "Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?" In Episode #1379, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at using Table Nomenclature in Validation and in VLOOKUP.

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!