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.

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.

Nested data structures are a boon to modeling, storage, and query performance, but pose challenges to traditional BI tools. Here’s how to overcome them ...

If you’re able to download a .csv file, you can open this file in Excel by clicking the Data tab. In the Get & Transform Data group, click Get Data. Then, choose From File and finally From Text/CSV.