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

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

この記事では、CData Drivers for IBM DB2の内「Excel Add-In for IBM DB2」を利用して「DB2 for IBM iのデータをExcelで一括編集する方法」をご紹介します。

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.