MrExcel Excel Videos

Shaun has a beautiful spreadsheet to calculate staffing levels and expense.He needs to multiply shift length by the number of staff and the answer that he is getting is . . . immaterial to the task at hand. With a few changes in the Formula and Cell Formats, Bill shows us in Episode #1468 how to get the real resulting Total Hours and Cost. ...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!

Every few months Bill receives a call or an email from someone stating that their Formulas are 'changed' and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? "R1C1" is the answer. Follow along with Bill in Episode #1467 to find out what happened and how to correct it. ...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!

Can you embed a PDF in a worksheet? Yes - Using the 'Insert Object' Menu Tab. Follow along with Bill, in Episode #1466, as he shows us how to embed a PDF in our Worksheet. ...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!

Gary points out that the TRIM Function in VBA isn't working like =TRIM() Function in the worksheet; the spaces in the middle remain after running the Macro. Bill shows us, In episode #1465, how to solve this issue with the 'Application.WorksheetFunction' to remove those spaces in the middle. ...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!

Tony needs to keep the last duplicate record and throw out the earlier ones. In Episode #1464 Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen demonstrate competing methods to get this issue solved. Dueling Excel Podcast #90...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"

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!