Excel doesn’t offer true tables, which are often ideal for complex data structures with interconnected entities. At times, you will often end up duplicating data across different spreadsheets.

Data forms provide an alternative option for data entry in your Excel spreadsheet. Instead of scrolling from right to left in a wide row of fields, use a data form to view one record at a time. A ...

Excel’s new linked data types are available only to Office 365 subscribers. Microsoft says it hopes to roll out additional linked data types, but so far the company hasn’t said when.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Excel’s Data Model creates a relationship between two (or more) sets of data using a common field. In this case, the common field is Shelf Code, as shown in Figure A.