MrExcel Excel Videos

Episodes #1488 and #1489 of the "Learn Excel from MrExcel Podcasts" generated a lot of email from viewers. Today, in Episode #1497, Bill revisits those episodes [that were dealing with making copies of worksheets]. Looking at several methods emailed in over the last week, Bill demonstates even more Copy Worksheet methods - including a VBA Macro routine! ...This episode 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!

When you need Excel help, go to the MrExcel Message Board. Today, in Episode #1496, Bill looks at how to post your worksheet to the MrExcel Message Board using the free HTML Maker Utility. Follow along with Episode #1496 to learn how to get and use this handy utility! ...This episode 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! *Kindle is Coming to 'The MrExcel Excel Store'! Stay Tuned!* "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today, Bill offers a quick tip on getting aclimated to your new iPad! Check out QUE Publishing. QUE is offering a free enhanced eBook sampler. This is a great way to show off your new iPad! See Episode #1495 for details!

MrExcel on Word for The Holidays!? Running short of gift tag labels? They are available for Free, inside Microsoft Word 2007 or newer. Today, in Episode #1494, Bill "MrExcel" Jelen reminds you of the Office Online Templates that are available to you! ...This episode 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! *Kindle is Coming to 'The MrExcel Excel Store'! Stay Tuned!* "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today, in Episode #1493, Mike from Athens, Greece asks how to create a control that would change a chart to show either units or revenue. Bill presents a borrowed solution from Mike Alexander at DataPigTechnologies.com, but when you see the solution, you will realize that the trick is barely a trick at all. ...This episode 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! *Kindle is Coming to 'The MrExcel Excel Store'! Stay Tuned!* "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and...

Today's Dueling Excel comes from France... Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen are looking for the words 'Top laod' or 'Front load', and then Cubic Feet. also need to change the decimal to a comma to make the value appropriate in French. Using Formulas, a little VBA and some creativity, Mike and Bill offer a few different solutions to the challenge in Episode #1492.

A small company has decided to start doing random drug testing. They want to randomly select two employees each month. In episode 1491, Bill builds a handy workbook. Enter the employee names in B2:B101, then press F9 to select two employees, all with formulas, no VBA. Some people asked about downloading this workbook. It is here: Podcast1491RandomDrugTest.xlsx

All this week, Bill has been dealing with a Workbook with 31 sheets - one Worksheet per day. Today, in Episode #1490, Bill presents a bizarre Formula to put the Sheet Name in a Cell. Actually, today, I use a MID of the Sheet Name to fill in the correct Date in a Cell.

Yesterday, in Podcast Episode #1488, Bill showed us a cool way to make 30 copies of a worksheet. However, after creating the worksheets we were left with strange names like Sheet1 (2), Sheet1 (3) and so on. Horrible! Today, in Episode #1489, Bill shows us how - with one line of code in the VBA Immediate Window - to solve the remaining issue of renaming the new Worksheets. ...This episode 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! *Kindle is Coming to 'The MrExcel Excel Store'! Stay Tuned!* "The Learn Excel from MrExcel...