MrExcel Excel Videos

Shrikant needs to join the left 26 characters of column A with column B. But...even if A2 only has 10 characters, he needs it to fill with spaces so that the value from B starts in character position 27 each and every time. In Episode #1463, Bill shows us how to maintain this positioning of data. ...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!

Stefan from Sweden checks in with a much better way to do a word count of all the sentences [referring to the "Word Count from Sentences" Podcast, Episode #1460]. How? Using... a tiny little Add-In that most Excel Users already have! ...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!

1. Why can't we do a Pivot Table Template? 2. Why can't we turn off the annoying Compact Layout? 3. Why do I keep asking these questions when it is so easy to override them with a tiny add-in? The MrExcel Labs is coming out with a tiny add-in to solve Pivot Table Annoyances. This is your chance to weigh in with what 'Pivot Things' annoy you most and you can win a free copy of the add-in. Watch the podcast [Episode #1461] and find out all of the details! ...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...

Today on Learn Excel from MrExcel, Zac has 5000 phrases in column A. He wants to figure out which words are most popular in those phrases. With Episode #1460, Bill shows us a number of steps that will solve the problem in about six minutes. ...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!

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!