Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 25

Excel tables and table slicers

Questions answered in this chapter:

• I have entered in a worksheet the number of units sold and the 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?

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