Many people don’t know how to create a PivotTable in Excel. They consider it too complicated. In the preparation of the Pivot table, you have to select the data range the Pivot Table is going to use. Next you choose the fields that you want to use in the Pivot Table. Then you assign these fields roles; place some in rows while others in column headings. In this tutorial, we will teach you how to create a basic Pivot Table in Excel.