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.

To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data. Right-click the chart, choose "Select Data" and highlight all entries in the single column.

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

Microsoft is bringing new kinds of AI-enabled data types to Excel, starting with geography and stocks. Up next: Companies' own organizational data.

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.

This simple task can be done by manually adding data or importing and appending additional records to the original data. For relatively small datasets, Excel offers simplicity and flexibility in ...