Entering the Pivot Table Data
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.
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.