Chapter 25. Tables
Questions answered in this chapter:
I have entered the number of units sold and total revenue for each salesperson in a worksheet, 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? In addition, is there an easy way to copy my formulas automatically when new data is added?
I have entered several years of natural gas prices in my worksheet, 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, ...
Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
