Entering the Pivot Table Data
The first step in creating a pivot table is to enter the data into the worksheet.
When doing so, keep the following points in mind:
- At least three columns of data are needed to create a pivot table.
- It is important to enter data correctly. Errors, caused by incorrect data entry, are the source of many problems related to data management.
- Leave no blank rows or columns when entering the data. This includes NOT leaving a blank row between the column headings and the first row of data.
Tutorial Steps:
Enter the data into cells A1 to D12 as seen in the image above. For those who do not feel like typing, the data, instructions for copying it into Excel, are available at this link.
