Preliminary Setup As I mentioned in my post on how to format tables in Excel, before I do anything with raw data, I format it as a table.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.