How to Create a Database in Excel

Creating a database in Excel is a great way to gather and monitor information. Databases can list the names and addresses of potential and current clients for ongoing marketing campaigns. Promotional results can be added to the existing information, sorted, analyzed and further utilized to fine tune your sales efforts. Databases can also be used for tracking sales dollars, percentages, monitoring achieved goals, tracking inventory and so much more. Follow the steps below to learn how to construct a simple database as a beginning foundation on which to build a customized structure upon.

...

Step

In Excel, open up a new document and begin with "Row 1" and "Column A." Type in short, one to two word descriptions for each column to best describe the information you will be gathering.

...
...

Step

Add your data, going down each row and column as needed.

...

Step

If your newly added information is not displayed on the screen in it's entirely, place your curser between the two columns that are affected by the hidden data and double-click.

Step

From the toolbar menu, select "File" and then choose "Save as" and give your file a descriptive name.

Step

To close the document, select "File" from the toolbar menu, and then choose "Exit."