How To Create Pivot Tables In Excel. Click on pivot chart & table button. Then click the insert tab on…