実はあまり知られていないExcelの「ピボットテーブル」ですが、大量のデータを集計・分析する際に大活躍してくれます。その使い方をご紹介します。

Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

Learn how Power Pivot transforms Excel into a powerful tool for managing complex datasets, advanced calculations, and data integration.

Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.