Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Click Add to Data Model in the Tables group. Doing so generates another view of your data. Your Excel data is safe–you can’t edit the data in the Power Pivot view.

What is a pivot table, and why should you create one? Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and ...

Smart rename: Excel 2016 enables you to rename tables and columns in your workbook’s data model. With each edit or change, Excel 2016 now automatically updates any related tables and calculations ...