MrExcel Excel Videos

The Question: "Can you extract a person's initials from their name?" Today, in Episode #1344, Mike 'ExcelIsFun' Girvin and Bill 'MrExcel' Jelen offer two (2) methods [one using a formula and another using a VBA function] to solve this problem and answer the question.

Today, with Episode #1343, Bill continues to show us how to Compare our worksheets - side by side - using a more involved technique. With a few minor modifications and the use of a VLOOKUP, comparing data becomes a bit more permanent and efficient.

James asks if it is possible to compare two worksheets from the same workbook side by side. Today, in Episode #1342, Bill shows us a low-tech way to do this comparison. Tune in to The Learn Excel from MrExcel Podcast for Part 2, airing tomorrow.

Today, Bill takes a look at final formatting. If you are going to publish your finished report to Excel Server or to SharePoint, you'll want it to look good! Episode #1341 offers you several tips for making the report look less like Excel.

Today, in Episode #1340, Bill looks at Pivot Tables in Excel 2010. While reviewing new features in Excel 2010, learn how to fill in blanks in the row area, change a calculation to % of parent row, create Rank results, and learn about Slicers

Today, with Dueling Podcast #1339, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen take a look their Newly released book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun". Included in this episode are a few 'How-Tos' straight from the book! Learn a few tricks in Excel and take a look at Mike & Bill's new book!

Today's Podcast looks at Future Zeros. If your chart shows future months as a line at zero, replace the line with blanks. With Episode #1338, Bill shows us how to remove future zeros in to produce a sharp looking Chart for presenting our future Data.

Today, in Episode #1337, Bill talks about Time Intelligence Functions using PowerPivot and Excel 2010. Following up on Podcast #1327 [DAX Measures: Podcast #1327], Bill makes a few modifications to his file to calculate MTD Revenue.

Today, in Episode #1336, Bill discusses the new color themes in Excel 2010. The new themes come with six (6) accent colors - but today, Bill shows us how to take those six theme colors and turn them into 1200 colors using Tint and Shade.