Русский Русская версия English English version

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-tablesManaging Pivot Tables 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-trainingPivot Tables Excel training using examples.
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-examplesWorking with pivot tables in Excel on examples.
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-multipleCreating the Excel consolidated Pivot Table from multiple sheets.
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-tablesExamples of working with pivot tables in Excel.
Working with the PivotTable Wizard. Advanced settings for PivotTables, which show their extensive capabilities in the formation of flexible-customizable reports.