Then I discovered Power Pivot, and everything changed. This built-in Excel feature transforms your spreadsheet into a ...

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.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.