Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition

Chapter 53 Creating subtotals

Questions answered in this chapter:

• Is there an easy way to set up a worksheet to calculate the total revenue and units sold by region?

• Can I also obtain a breakdown by salesperson of the sales in each region?

Joolas is a small company that manufactures makeup. For each transaction, it tracks the name of the salesperson, the location of the transaction, the product sold, the units sold, and the revenue. The managers want answers to the questions above.

PivotTables can be used to slice and dice data in Microsoft Excel. Often, however, you’d like an easier way to summarize a list or a database within a list. In a sales database, for example, you might want to create a summary of sales revenue by region, a summary ...