To explain the basic steps to Create Pivot Table in Excel, we will be making use of Sales Data recorded at two computer stores, conveniently labelled as Store#1 and Store#2.Īs you can see in above image, the Source Data is well organized with unique column labels and it has no blank columns, blank rows or cells.
#How to work with pivot tables in excel 2013 free#
Once the Source Data for Pivot Table is properly organized and meets the above requirements, you should have no problem creating error free Pivot Tables.
Make sure that you apply formatting (Date, Number, etc.) to cells within the Source Data. Do not include Totals, Subtotals and Averages (Column or Row Totals) when you select Source Data Range in a Pivot Table.ĥ. Avoid blank Cells and blank Rows in Source Data, as they can lead to errors and confusion in Pivot Table.Ĥ.
In-fact, you won’t be able to Create Pivot Table, if there is blank Column in the Source Data.ģ. To avoid confusion, column Labels need to be unique and not repeated.Ģ. Each and every column in Source Data needs to have a heading or column Label.
In general, the Source data for Pivot Table needs to comply with the following requirementsġ. In our opinion, going with a Suggested Pivot Table and modifying it is easier and quicker than working with a blank Pivot Table. Once the Source Data is ready, you can either insert a blank pivot table or insert one of the suggested PivotTables into the worksheet.
0 kommentar(er)
