PivotTables in Excel with examples and description

Creation of a PivotTables from several sheets and tables for quick forming summary data reports. Pivot tables creating.

Creating PivotTables in Excel

managing-pivot-tablesWhat is the use of Pivot Table and Pivot Chart in Excel.
Working with pivot tables for filtering, sorting, grouping. Using formulas with the addition of calculated fields. Insert additional columns in the summary report.
pivot-tables-trainingExcel Pivot Table training with step-by-step instructions.
Forming reports using the Pivot Tables for the example of working with the client database. Change the structure of reports in the settings of the fields in the PivotTable.
working-pivot-tables-examplesWhat is Pivot Table in Excel with examples for beginners.
Examples for working on pivot tables in Excel: automatic updating, merging multiple files, grouping by date, adding a calculated field and detailing the data in the reports.
create-consolidated-pivottable-multipleHow to create Pivot Table from multiple sheets in Excel.
Create a pivot table in Excel based on data from several different worksheets and third-party sources. Quickly create and configure a report using the PivotTable Wizard.
working-with-pivot-tablesWhat pivot table toolbar button update data in Excel.
Working with the PivotTable Wizard. Advanced settings for PivotTables, which show their extensive capabilities in the formation of flexible-customizable reports.

en ru