A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

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

Insert data and create a pivot table (or several!) First, generate the raw data set that you plan to use to create an interactive dashboard in Excel.

When you’re trying to find correlations and causal relationships, anything short of a pivot table is going to fall short. Pivot tables are like the Swiss army knife of data analysis in Excel.

Pivot tables let you parse raw spreadsheet data to display specific information in a concise, easy-to-digest format. Here’s how to use them in Google Sheets.