Cookies are very small text files that are stored on your computer when you visit some websites. We use cookies to help provide you with the best possible online experience. By using this site, you agree that we may store and access cookies on your device. Accept this cookie or find out more.



Excel: Create Your Own Database

If you have a collection of music, DVD movies, stamps, books or something else, you know how hard it is to keep track of it all. If you use Microsoft Excel, however, you’ve got the ideal solution at your fingertips! Excel is vastly easier to use than a ‘real’ database program, but it does all you need – not just storing information, but sorting and searching it to quickly find the details you need.
Read on to learn how to set up and use a database in Excel spreadsheet, using a music collection as a typical example.

Category: Issues, Office & Software Programs
Issue: 2019 Issue 7 July
Operating Systems: 7, 8, 10
Article Reference: E896

Download("2,709.6") KB