Chapter 26. Tables

Questions answered in this chapter:

Image I have entered in a worksheet the number of units sold and total revenue for each salesperson, and I can easily compute the average price per unit 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?

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

Get Microsoft Excel 2016 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.