Sheets Archives - Excel Pro School

Microsoft Excel PivotTable – Beginner to Advanced

Welcome you to Microsoft Excel Pivot Table Series (Beginner to Advanced) A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Pivot Tables work a little bit differently depending on what platform you are using to run Excel. Post 001: Introduction to Pivot Table and purposes of using Pivot Table Post 002: How to create a Pivot Table in Excel and [...]

Excel PivotTable Fields

By default, a PivotTable fields should show up to the right of the Microsoft Excel window when you create a pivot table and select a cell within it. The field list can be used to choose fields for the pivot table layout and to reposition pivot table fields within the layout. The Task Pane for a pivot table is called PivotTable Fields. Areas and Fields are both parts of the PivotTable Fields Task Pane. Fields [...]