Working with Multiple Excel workbooks

Now in my job here at NPower, I have to update statistics for the training program all the time. Usually this involves numbers that I keep track of in one sheet but have a total linked to another. And I want to see how it effects the rest of that sheet.

Well up til now, that meant I had to open both of those sheets. Well the folks over at the Contextures Bloghad a great post about using “Workspaces” in Excel. This is a handy way of saying, “I want to open all these files at the same time and have them displayed this way”. It then creates a shortcut, so to speak, that allows you to do just that. How cool is that? Check it out the post here.