Automated Data Entry in Excel. One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data.

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.

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.