Tutorial Pivot Table Excel 2010. For example click the boxes next to salesperson and sales amounts. Use the topmost row or the topmost column to categorize your values by what they represent.
You have various options available in the pivot table pane. You can select fields for the generated pivot table. The options tab will appear on the ribbon.
Your data shouldn t have any empty rows or columns.
From the options tab click the pivotchart command. Insert the pivot table by going to the insert tab and then clicking the pivot table icon. Microsoft excel 2010 will summarize each salesperson s first and second quarter sales in one report. For example click the boxes next to salesperson and sales amounts.
