MrExcel Excel Videos

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

Damia from YouYube has to create 31 copies of a worksheet; one for each day of the month. Right now, Damia is using 'Insert Worksheet' 30 times, copying Sheet1 contents and pasting 30 times; then changing the zoom, changing the column widths and changing the print settings. Today, in Episode #1488, Bill introduces the 'Move or Copy' dialog and shows us how to knock out 30 copies of the worksheet in just a few seconds! Awesome! ...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...

In today's Dueling Excel, Episode #1488, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen team up to defend Excel's honor, showing two different methods to create a Watch Box in Excel. Dueling Excel Podcast #92...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"...