Select any cell in the source data table.In this example the source data contains information about food sales,Īfter your source data is prepared, you can create a pivot table.įirst, follow these steps, to see which pivot table layouts are suggested by Excel.
#Microsoft excel pivot tables full#
There are written instructions below the video, and the full Video Transcript is at the end of the page.īefore you create a pivot table, organize your data into rows andĬolumns, and create an Excel Table. Watch this video, to see the steps for creating a pivot table in Excel 2013 and later. More Pivot Table Tutorials Create a Pivot Table