Excel

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 – “Keep Leading Zeroes During Data Entry”: Podcast #1878

               

Darvaish asks how to keep ‘Leading Zeroes’ during Data Entry. If you type 0523 in Excel, Back

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 from MrExcel