How Do You Use Excel Pivot Tables?
Excel pivot tables help you organize and sort data easier than a simple spreadsheet. By using data you have already input into an Excel spreadsheet, you can create customizable pivot tables. With a pivot table, you can better sort and view your data. This is especially useful with large spreadsheets. Open the spreadsheet you’d like to use to make a pivot table. Highlight the data you want included in your pivot table. Be sure to include headings. You can also specify the range during the pivot table wizard. Choose the source of the data you want to analyze. You have four options: Microsoft Office Excel list or Database, External Data Source, Multiple Consolidation Range or Another Pivot Table report. Normally, you will use the first option. Choose Pivot Table in the section Type of Report to Create and choose Next. Input the range or check to be sure the range you selected in Step 2 is still highlighted. Choose Next. Choose where to store the pivot table. “New worksheet” creates a comp
