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

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

How to create a SharePoint list using Excel Once you’ve made the decision to share Excel data as a SharePoint list, you must format the data as an Excel Table.

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.