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

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.

As you probably know, whenever you are doing any kind of date or time-based calculations in DAX you should always have a separate Date table in your Power Pivot model. There are a number of ways of ...

While the other formulas can do some magical things, the FORECAST function feels the closest to actual magic because it's as ...

In our example, Excel offers to create 10 different pivot tables that take a look ... If you want to get really good at using Excel pivot tables, invest some time in learning a bit more about how ...