How to create a calculated column with values from related tables So far, everything needed has been in the same table, but you can add a calculated column that depends on values in another table.

When you want to visualize results in each row—such as when each row of data is a trend over time—you can do that inside a new table column with mini inline graphs called sparklines ...

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.

If the natural data can't support the sorting and filtering requirements, you might need to add an index column and sort by it.

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.