Lydia works in Sales Support. Her job is to create and distribute various sales reports to each branch. The data she needs to work with is in Excel, but each branch manager needs to share a PowerPoint presentation with his sales people.
While all of the data is in Excel, I feel much more comfortable in PowerPoint and Word. What I have been doing is copying the data for each slide to a MS Graph table and working on the charts there. This worked well when we only sold a few products through a couple of branches.
The amount of data I process each month has grown as our product line has grown. It is now too difficult to continue manually updating the files. I need a new way to generate the graphs. I have started to learn Excel, but don't entirely understand how to make the links between the products.