The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

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.

Gantt Chart is one of the tools used for project planning & management. Learn how to create & use Gann Chart on Microsoft Excel.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

A Gantt chart maps out deadlines within a project. Chandoo's Excel Gantt chart combines a calendar and to-do list to display what has to be completed when in a good-looking table layout.

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.

Learn about how to create a table in Excel so you can start presenting your data to others in a more professional manner.