O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required