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.

Open Microsoft Excel and create a new workbook to enter the data you'll need. In the example below, I have added relevant columns such as sales person, along with their monthly and yearly sales.