Microsoft Excel 2013: Data Analysis and Business Modeling

Chapter 51. Creating subtotals

Questions answered in this chapter:

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

• Can I also obtain a breakdown by salesperson of 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 questions such as those that are the focus of this chapter.

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