MrExcel Excel Videos

Given a start date and an end date, how do you produce a list of all the day numbers? For example, between Feb 28 and March 5, you would want the list 29,1,2,3,4,5. Mike and Bill show several different ways to solve this question.

James T asks if the Ctrl+G Dialog Box provides a way to jump 3000 columns to the right. (After all, Column E + 3000 columns is what? AAA? AAB? How would you know?) R1C1 style referencing is one ugly option, but Bill has something easier.

Chuck from Florida asks how to require a password to open an Excel file. Using Protect Workbook does NOT solve this. Learn where Microsoft has hidden this setting.

Latasha asks how to VLOOKUP to three worksheets. Her product number might be found on the master product list, but it might be on the old product list, or it might be on the rare product list. She needs a formula that will get the country code from one of those three sheets. Today's episode shows one way to solve this problem. There might be others - post your alternative in the YouTube Comments.

Rich wants to know how to allocate a contract amount of N months, where N is a value shown in column A. Rich is looking for a formula, no VBA. Today's Duel shows a few solutions.

All of a sudden, Excel starts out completely grey. But as you enter data, those cells change to white. Episode 1859 shows how to correct this problem.

You have a formula doing a calculation. If both input cells are 0, the formula needs to use an override. Bill and Mike offer alternatives using AND, CHOOSE, and more in this Dueling Excel podcast.

Stephen wants a bar of pie chart and a slicer. If you choose the west region, the column chart will show the states that make up that region, and the remaining regions will appear as regions in the main pie. This episode uses many rarities, including GetPivotData, Remove Duplicates, Slicers, ISNA, Bar of Pie Charts, a tiny bit of VBA, and an example where Pivot Table Compact Layout is actually useful! For more of a write-up, see the corresponding blog post at http://www.mrexcel.com/learnexcel/2014/02/11/using-slicers-to-zoom-in/

Today's podcast shows how to animate a scatter chart using just regular Excel. The subject is the first four free flights of the prototype moon lander Project Morpheus. The Project Morpheus team is attempting to fly the lander 465 feet up and 636 feet down range today, significantly higher and farther than the last 4 free flights. Check out videos of Project Morpheus at Morpheus Lander