2013

Learn Excel – “VLOOKUP into Subtotaled Data”: Podcast #1882

               

On Sheet 1, you have Customer Data with Subtotals added by the Subtotal command. On Sheet 2, you have a list of

Dueling Excel – “When Project Finished, Mark All Green”: – Podcast #1877

               

Today in Duel 157, Mike and Bill look at completed project records. If any record for the project is marked Back

Learn Excel “=INFO(“Directory”) to find Path”: Podcast #1876

               

Suppose that you want to use some VBA to save a file to the Desktop. But what is the real Path to the desktop? Back

Learn Excel – “Launch Rockets with Excel (Rapid Prototyping)”: Podcast #1875

               

Bill serves up an ‘Out of This World‘ treat today! In Episode #1875, NASA’s Steven Cox explains how he used Excel’s Shapes and Hyperlinks to Prototype a Rocket Launch System in Excel.  Back

Learn Excel – “200 Checkboxes in Excel”: Podcast #1871

               

Catherine is building a risk assessment tool in Excel. She needs to add 200 checkboxes to a worksheet, but this is Back

Learn Excel from MrExcel