Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 26. Tables

Questions answered in this chapter:

• I have entered in a worksheet the number of units sold and total revenue for each salesperson, and I can easily compute average price for each salesperson. How can I create a nice format that is automatically copied if I enter new data? Also, is there an easy way to automatically copy my formulas when new data is added?

• I have entered in my worksheet several years of natural gas prices, and I created a nice line chart displaying the monthly variation in prices. Can I set things up so that when I add new gas price data, my chart automatically updates?

• For each sales transaction, I have the salesperson, date, product, location, and size of the transaction. Can I easily summarize, for example, total ...