![]() You’ll notice that there is also another toolbar that has appeared next to the pivot table – this is a shortcut toolbar so you can make changes to the pivot table as and when you want to. ![]() For this example, we’ll drag the Order Ref Number field to the Row section and the Total to the Data section, then click OK…Ĭlick Finish, and the pivot table should appear in cell G2 next to the existing data… You can now construct your pivot table by dragging the fields that you want to appear in the Page, Row, Column, and Data sections of the pivot table. For this example we’ll choose existing worksheet, click on an empty cell where you want the pivot table to appear (in this example cell G2), then click on Layout… It then asks where you want the pivot table to appear, either in a new worksheet or in the existing one. ![]() Select the range of data that you want to use for the pivot table, in this example it has automatically highlighted the range A2:E27, then click Next… Make sure that the “Microsoft Excel list or database” and “PivotTable” options are chosen, then click Next… This will automatically open up the pivot table wizard, and it’s just a matter of following the step by step instructions. In Sheet 1 is a list of data that we’ll use for the pivot table, it basically just lists a reference number, product name, unit price, quantity and a total…Ĭlick on Data on the toolbar, and select PivotTable and PivotChart Report… For example, if you have data that shows details of every customer that has bought your product over the last 5 years, by using a pivot table you can find out which product is most popular, which town/county/country most of your customers came from, and whether your customers were male or female etc, depending on the data you have available.īelow is a short tutorial on how to set up a very simple pivot table in Excel 2003. It seems a lot of people want to use them but are just not sure where to begin, so in the words of Aladdin’s genie “your wish is my command”! □įirstly, for those of you who don’t know what a pivot table is, it’s a fantastic tool in Excel that sorts and summarises data, and then inputs it into another table which is a bit more user friendly, more readable. A few weeks ago I asked followers of my Facebook page if they wanted me to cover a specific topic in a tutorial, the majority of the replies I received were for pivot tables.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |