Dear All,
This has been a very helpful forum, and I've already learned a lot. Thanks!
I've created a rudimentary portfolio management tool for my client showing, among other things, charts regarding total budget, budget-by-fiscal-year, number of projects, etc.
It works now but my concern is that I need to pass it off to the client (our "transition plan") and from what I know of the person who will take it over for me, she's not very Excel savvy. No problem.
Here's the deal: I have a total universe of projects (on one Excel tab) of 35 projects. (This could grow in the future, though.) Every two weeks a group of executives review 2-3 projects, and when those projects are "approved," I have the go-ahead to include those "approved" projects in my stats (again, budget, etc.). That means that one month ago, my charts only included 6 projects (of the 35). Two weeks ago my charts only included 9 projects (of the 35). Two weeks from now my charts will include probably 13 projects (of the 35).
To manage this I create new Excel tabs with the subset of data that I want to calculate on. Probably not the smartest, but that's how I naively set it up.
As the person who will take this over from me will need something much simpler, my ultimate question is this: *When creating my charts and pivots pulling from the 35 projects, how can I pick-and-choose which projects get calculated into my calculations? (E.g., "This time I want to calculate stats from Project M, Project S, Project T, but not Project U, and not Project X.")
Confused? Probably!
Any assistance would be helpful.
Thanks,
Kelly
This has been a very helpful forum, and I've already learned a lot. Thanks!
I've created a rudimentary portfolio management tool for my client showing, among other things, charts regarding total budget, budget-by-fiscal-year, number of projects, etc.
It works now but my concern is that I need to pass it off to the client (our "transition plan") and from what I know of the person who will take it over for me, she's not very Excel savvy. No problem.
Here's the deal: I have a total universe of projects (on one Excel tab) of 35 projects. (This could grow in the future, though.) Every two weeks a group of executives review 2-3 projects, and when those projects are "approved," I have the go-ahead to include those "approved" projects in my stats (again, budget, etc.). That means that one month ago, my charts only included 6 projects (of the 35). Two weeks ago my charts only included 9 projects (of the 35). Two weeks from now my charts will include probably 13 projects (of the 35).
To manage this I create new Excel tabs with the subset of data that I want to calculate on. Probably not the smartest, but that's how I naively set it up.
As the person who will take this over from me will need something much simpler, my ultimate question is this: *When creating my charts and pivots pulling from the 35 projects, how can I pick-and-choose which projects get calculated into my calculations? (E.g., "This time I want to calculate stats from Project M, Project S, Project T, but not Project U, and not Project X.")
Confused? Probably!
Any assistance would be helpful.
Thanks,
Kelly