so I have a set of sample data, attached. I need to to some analysis, i.e. calculate lag time between current Status & previous status(by status type), calc bonus hrs by mgr, etc.
I can easily accomplish some of this in a pivot, but unfortunately, the data set contains both statuses in each...
sorry if this was already posted somewhere else, but I found this Tool to be a great resource when converting from 2003 to 2007.
Graphically shows exactly where to find a command using Ribbon - just need to select using old (2003) method thru Excel Menus.
Interactive: Excel 2003 to Excel...