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.

Read on for a guide to using Excel’s dataviz tools to present your data. We use the Office 365 version of Excel for Windows in the descriptions below; some features may not be available if you ...

Use a DSN-less connection (i.e. with no data source defined on the server) to connect the program to your database for simplicity. You will need to use HTML to format the data.

How to Use an Excel File to Keep HTML Web Updates. Tracking updates to an active company website helps you plan, implement and -- if necessary -- roll back changes.