Tips and Tricks for Using Pivot Tables Like a Pro in Excel. To use pivot tables like a pro, you need to know a few tips and tricks. For starters, always keep your data organized and clean. Ensure that the data is correctly labeled and that there are no missing or duplicate values. You create the pivot table by defining which fields to view and how the information should display. Then, based on your field selections, Excel organizes the data to see a different view of your data. For example, I’ve uploaded a data file with information on 4000 fictitious voters that include the following data fields: Voter ID. With the pivot table, I just need to clean up my data and update my pivot table's data source. This way I could drag and drop more items with ease to display whatever I need, wherever. The 'calculated field' is also an excellent function that you could use to get more computations e.g. % of A vs B. the possibilities doesn't end there. Steps. Create a pivot table. Add City field to the rows area. Add City field to theValues area. Summarize by count. Rename "Count". Filter on Cities where count > 1. Sort in descending order by count. Step-by-Step Guide to Creating a Pivot Table in Excel. Creating a pivot table in Excel is easy. Simply select your data, go to the "Insert" menu, and click on "Pivot Table." From there, you'll be asked to select the range of your data, and choose whether you want your pivot table to be on a new or existing worksheet. . To add a Pivot Table to your spreadsheet, go to the sheet (the first cell) where you want the Pivot Table summary inserted. Go to the Insert Tab > Pivot Table (Or press the Alt Key > N > V) to launch the insert Pivot Table dialog box. Refer to the cells containing the data. Check the option for a ‘New Worksheet’. Click Okay. Figure 1 – Creating Pivot Table Macro. Turning our Data into a Table. We will begin by turning our raw data into a simple table format. This ensures that we can easily update our tables (and the Pivot table) at any time. We will click the Insert tab, and then, Table; Figure 2- Clicking on Table. Next, we will name our table by clicking on the To do this, select any cell in the pivot table and click on the Analyze tab. Then, click on the PivotChart icon and select the type of chart you want to create, such as column, bar, line, or pie I'm working with 360 degree data, and trying to build a pivot table to summarize the results as they come in. What I want to do is build a pivot table that will capture the responses to the behavioural questions (which there are 10 of) Behaviour has a scale of 1-10 as well as a text option of 'Unable to comment'. Example of data. Division. Group. Step 1: Select the data that will be added to the pivot table. Step 2: Now click the Insert tab > Pivot table. Step 3: Choose where you want to insert the pivot table via the New sheet and

how to use pivot tables