Excel spreadsheets can contain very large amounts of data. Individual items of data on the sheet are rarely as important as cumulative totals or broad trends. To summarize long sheets, businesses ...

Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest. This ...