Pivot Tables from A to Z

Online course “Pivot Tables from A to Z” How to harness the power of Excel pivot tables for analyzing large volumes of data and creating visually appealing interactive reports and charts. No modern Microsoft Excel user can be imagined without confident mastery of the most powerful analytical tool in this program – pivot tables. In this course, you will learn: How to properly prepare source data for subsequent analysis in pivot tables. Building pivot tables of any level of complexity. Customizing the appearance and formatting of pivot tables according to corporate requirements. Adding visualization to your pivot tables using charts, sparklines, and conditional formatting. Filtering and sorting data in the pivot by any fields and logic. Flexibly configure calculations in the pivot table, calculating intermediate and grand totals, percentages, dynamics, differences, ranks, etc.

Difficulty: medium

Duration: 8 hours