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.

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

Click on the Databases tab and select the format of your database. Our demo uses MS Access Database . If your database product doesn’t appear, click on Browse to locate it on your computer and then ...