Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

The Excel table to which the code examples refer shows the turnover of a company per quarter, divided into four different districts (Fig. 1).

Excel-Add-in-VisualizeExcelData Sample shows how to create data visualizations in an Excel content add-in from table data in a spreadsheet The Office sample includes a task pane add-in and a content ...

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.