How can I use data consolidation in excel in the career field of retail? or would A what-If analysis be better fit?

Here's a good place to begin:

(Broken Link Removed)

Sra