A Different Subtotal
The Intermediate Guide to Microsoft Excel 2013
demonstrated a series of formulas that calculated and formatted the
This lesson demonstrates how the sales subtotals were
1. Try This: Open a Sample Spreadsheet
The sample spreadsheet is still open:
Customer Sales 2013.xlsx
Go to the sheet called: Monthly Sales.
What Do You See? This is the Monthly Sales for Charlotte's
Website. The first row is BOLD: It is the Header Row. There are many
rows of data including the Category, Service, Product, Date, Sales Rep
Memo to Self: You do not have to MATCH the numbers shown on
these pages. It is more important that you begin with some data and
understand the options.