Slide 5 Before creating Pivot Table Convert the source data to a table before creating the pivot table This updates the pivot table to include any data that is added to the data table after pivot table is created Steps Click on cell in the source data table Select insert tab, Select table Select Ok 5 Slide 6 6 1.Select a Data Cell a)In this example cell B4 2. 3 Slide 4 4 Leave no blank rows or columnsrowscolumns Leave NO blank row between the column headings and the first row of data.

Leave no blank rows or columns when entering the data.rowscolumns This includes NOT leaving a blank row between the column headings and the first row of data. Errors, caused by incorrect data entry, are the source of many problems related to data management. Columns must have column heading It is important to enter data correctly.

Pivot tables also allow user to rearrange the summarized data simply by rotating row and column headings 2 Slide 3 Enter Worksheet Data At least three columns of data are needed to create a pivot table.

Pivot Tables Overview 1 Slide 2 What are Pivot Tables Pivot tables in Excel are a versatile reporting tool that makes it easy to extract information from large tables of data without the use of formulas Uses Data in the table can be categorized and summarized without making you create formulas to perform the calculations.

What are pivot tables in excel 2013