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.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

8. Multi-Select slicer: Excel 2016 allows you to ­select multiple items in an Excel slicer on a touch device, as pictured below. (Previously only one item in a slicer could be selected at a time using ...