File -> Open


A Different Subtotal

The Intermediate Guide to Microsoft Excel 2013 demonstrated a series of formulas that calculated and formatted the sales subtotals.


This lesson demonstrates how the sales subtotals were created.

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

Keep going...

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.