database

Excel as a Database

Excel as database

So you want to use Excel to act like a database, after all a database is mainly a list of lists right? Well, most databases such as SQL databases are very complex and almost convoluted in how they relate to data via primary keys and such. Did I lose you? Okay, then back to Excel, something you and I both can understand right? I've been using Excel for over 20 years and have now designed an easy to use process to make Excel behave like a simple database. Granted, this wasn't really feasible in the past as not until Excel version 2007 could you store more than 65,536 rows of data on each tab. Now you can store 1,048,576 rows. Now we're talking!!!

Read More

Sales Contact Database for Excel

This will allow you to easily keep a list of sales contacts as a long spreadsheet yet quickly display it in a printable format. FREE.

Read More
Subscribe to RSS - database