Learn Excel

Learn Excel – “Mysterious Leading Space”: Podcast #1884


DRM-Free Day, Mystery Spaces in Excel and Free Stuff Today! Read On!

Dueling Excel – “Working on the Railroad”: Podcast #1883


Today’s question for Duel 158: “You have to rent rail tank car #123 for a 3 month period. The daily rate changes twice ; once in

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

Learn Excel – “AutoFill by Double Clicking”: Podcast #1881


I love doing Power Excel Seminars!  I was in Fort Wayne, doing a Seminar at a Baseball Stadium, when a question popped up: “If I Double-Click

Learn Excel – “Extract Suffix After Dash”: Podcast #1880


Michael has Data in Column A. He needs to extract everything after the dash to Column B. The Episode #1880  podcast shows four different methods.

Learn Excel from MrExcel