Today's Learn Excel Podcast features a First for MrExcel! A Three-Level Side-to-Side Sort in Excel..."This is the first time that I've ever tried this, and it works!"
...This is the podcast companion to the book, Learn Excel 97-2007 from MrExcel.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
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.
