While many charts only involve one variable, you can create charts that have multiple variables. To do this, you need only to create a table with multiple columns.

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

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 ...

Cells in different spreadsheets across an Excel workbook will have identical cell references if they occupy the same position in different sheets. To cross-reference between spreadsheets, you must ...