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 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!

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. Preview the new book with Bill, in Episode #1457.

Think that you know everything that there is to know about Microsoft Excel? Guess again. If you’re ready for the next level of Excel, then “Excel Outside the Box” is for you! ‘Outside the Box’ is an in-depth look at 54 amazing techniques from Excel MVP Bob Umlas. To learn more about “Excel Outside The Box” click here to go to the information page.

…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.

…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!

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 [based on Mike's New Book], Bill attempts Goal Seel, but that doesn’t really get the result either. Mike 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.

Dueling Excel Podcast #85…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

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

Kevin wants to clear out data for yesterday’s shift worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added he has added,  Bill shows us the solution today in Episode #1453.

…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.

…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!

Mark this date: October 18th, 2011 – Bill “MrExcel” Jelen’s First-Ever Podcast for MAC Users! [The Title of this Blog Post is NOT a typo.]

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 people using Excel for the Mac, I will show you how to use the ‘RGB Function’ to fix you macro. Follow along with Bill in Episode #1451 and learn a simple method that allows you to use the colors that you want!

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 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!

What is ‘Alt+DEF’ good for? Today, in Episode #1450, Christopher and Sheila both wrote in with different problems that required the same solution. Both had formulas that were not working. Both happened to have numbers or dates stored as text. The beloved Alt+DEF shortcut came to the rescue both times – And Bill shows us how it works!

…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, in Episode #1449, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen address different methods to answer the question: “Is there a way that the Grand Totals and Subtotals would omit the Negative Subtotals?”

Dueling Excel Podcast #85…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

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

Today, in Episode #1448, Bill re-addresses a few past podcasts with alternate solutions. Follow along, make note and improve your effectiveness with Microsoft Excel!

1. A Non-VBA Solution to get Misplaced Excel Windows back into view (improving upon Episode #1437).
2. A VBA Solution to Center Across Selection (as discussed in Episode #1443).
3. A Mouse Click Solution to navigate to the edge of your Data quickly (as discussed in several previous podcasts).

…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!

Want to see immediate results? Set an area to the bottom and right of a massive spreadsheet where you can add totals and see them at a glance. In Episode #1447 Bill shows us how to do this with only a few keystrokes.

…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!

In today’s Dueling Excel Podcast, with Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen, Mike and Bill look at methods to calculate the MODE and MEDIAN from data that is arranged in a Frequency Table. Follow along with Episode #1446 to see how it all works out!

Dueling Excel Podcast #85…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

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

In a spreadsheet that keeps track of expenses, we want to mark the cell in one color if the expenses are within 25% of the budget and in another color if they are within 10% of the budget. In Episode #1445, Bill shows us how to do this.

…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!