MrExcel Excel Videos

Someone in my Michigan seminar posed this question: "Can you get the pivot table grand total column to appear on the left side of the pivot table?" This is handy when you have so many columns that you're not able to see the Totals Column. In Episode #1459, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen come up with differing strategies for solving this problem. Dueling Excel Podcast #89...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle] and "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute...

Jil asks today's question. Jil used to be able to edit a Formula and use the Wheel Mouse to scroll the Spreadsheet while editing the formula. This apparently doesn't work any more, starting in Excel 2007. Today, in Episode #1458, Bill shows us a workaround to solve the scrolling issue. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Bob Umlas' new book just arrived from the printer - "Excel Outside the Box: Unbelievable Excel Techniques". Today, Bill takes a look at the new book, tells you where you can buy an advanced copy, and shows you a trick from the book in Episode #1457. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Two Pivot Table questions today from my 'Power Excel' Seminar in Detroit, MI yesterday. First, when you drill down on a pivot table in Excel 2007, you are getting the Table Format instead of just a Range. How can I just get the Range? Second, when you convert a Pivot Table to Values, you lose the Formatting and the Formulas. How do I mitigate this when trying to get back to the Data Field? Follow Bill in Episode #1456 to learn the solutions.

Frank asks if there is a way to rewrite a formula using a scrollbar. While we can't do it with a scrollbar, I do have a way to rewrite formula with a dragging technique. Following along with Bill in Episode #1455 to see how it's done. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today, Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin look at a question that asks: "How can I audit 70% of the book value, with samples based on the value?" Conditional Formatting produces 70% of the cells and not 70% of the value. Using a previous Dueling Excel Episode, Bill attempts Goal Seel, but that doesn't really get the result either. Mike, on the other hand goes in another direction based on some of the work Bill has set up. Watch the Duel, learn the method, get the result with Episode #1454. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the...

Kevin wants to clear out any data from yesterday's shift Worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added today, Bill shows us the solution. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Bill wants to know: "Did a new shift start between Time 1 and Time 2? It sounds like such an easy formula, and it probably is, but I sure had a tough time puzzling this formula out. Do you have something easier?" Today, in Episode #1452, MrExcel looks at working with time and day changes.

Mark this date: October 18th, 2011 - Bill "MrExcel" Jelen's first Podcast for MAC Users! Joe has Excel 2011 for Mac. He turned on the macro recorder and changed some colors in his worksheet. The Excel Mac Macro Recorder uses 'xlAutomatic' for all colors instead of recording the actual color. In this, my first-ever podcast directly focusing on Excel for Mac issues and those using Excel for the Mac, I will show you how to use the 'RGB Function' to fix you macro. Using Excel on your MAC? Bill wants to know. Drop him a note at * bill @ mrexcel.com * and tell him what version of Excel for Mac you use. As Bill mentioned in today's podcast, "...maybe it's time". ...This blog is the video podcast companion to the book, Learn Excel...