How to use pivot tables in excel 2010 tutorial

#How to use pivot tables in excel 2010 tutorial how to

Make sure the settings are correct, then click OK. The Create PivotTable dialog box will appear. From the Insert tab, click the PivotTable command. To make these relationships easily detectable, you can select the part of the table that interests you and then switch on different visualization options from HOME Tab > CONDITIONALВ FORMATTING. Select the table or cells including column headerscontaining the data you want to use. (6) Now click and drag the QUARTER field from the ROW label to the COLUMN label and drag the BRAND label back to the ROW labels to create yet another PivotВ Table:ДЄs you can see, different Pivot Tables display different relationships between selected data, which is the whole idea to this exercise. (5) Now you can click and drag the BRAND field from the ROW labels to the COLUMN labels to create a differentВ PivotВ Table:

Your screen now should look something like this: However, itвЂ™s always good practice to keep a backup copy of all your important data before manipulating them. The default location for a new pivot table is New Worksheet. Notice the data range is already filled in.

#How to use pivot tables in excel 2010 tutorial how to

REMEMBER: Your original data remains intact no matter what you do with your Pivot Table. To start off, select any cell in the data and click Pivot Table on the Insert tab of the ribbon: Excel will display the Create Pivot Table window. This Excel tutorial explains how to create a pivot table in Excel 2010 (with screenshots and step-by-step instructions). (4) Select the fields (variables) youвЂ™d like toВ includeВ in your Pivot Table by putting a check mark next to them. (3) Use the default вЂњ New WorksheetвЂќ setting and click OK to display the Pivot Table wizard in a new worksheet: Create Pivot Table dialog box will display: (2) Go to InsertВ tab on the ribbon and click the PivotTable button on the Tables pod. Such вЂњtrick questionsвЂќ is easy to answer when you re-format your data as a Pivot Table. Here is a sample table representing the imaginary Atlantic and Pacific region sales of a fictitious fish company.ДЄs you can see, itвЂ™s not easy to look at this data and answer a simple question like вЂњwhich fish brand is more profitable in Atlantic region?вЂќ, or, вЂњWhich fish is more profitable in Quarter 2, regardless of region?вЂќ Creating a Pivot Table in MS Excel 2010 is very easy if your data is in proper TABULAR LAYOUT FORMAT.