Open a blank Excel spreadsheet. Type a header in one of the columns in the worksheet. This is your first independent variable. Type the appropriate data in the rows below the column. Type a header ...

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