Chapter 24. Tables
I have entered into a worksheet the number of units sold and total revenue for each salesperson, and can easily compute average price for each salesperson. I have created a nice format for my data. However, when I add new data, it is really annoying to have to copy the formula down and extend the format. Is there an easy way to have my format and formulas automatically copy down when new data is added?
I have entered into my worksheet several years of natural gas prices, and have 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 ...
Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition 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.
