An Excel database can now do many of the things that databases excel at.
Great things about Excel databases
1.Flexibility and power
2.Connecting to your datasources
3.Pivot tables, queries, charts and responsive dashboards
The kinds of questions our customers ask about Excel Databases.
Not necessarily no… Excel is an excellent substitute for LOTS of databases, but not all.
If you have a truly massive amount of data for instance, then Excel probably isn’t the answer.
Yes. Data entry forms are easy to make in Excel
Excel Database Case Studies
Order Tracking and Invoicing System We built the Order tracking and Invoicing system for a film processing agency that wanted to keep track of their clients orders as they passed through their [...]
Property Portfolio Management Spreadsheets Using Excel Dashboards, we built the property portfolio workbook for an estate agency, to help them to keep track of their clients’ property portfolios [...]
Environmental Modelling – Monitoring and Models Environmental modelling and monitoring with estimated driving times can play a vital role in spacial data analysis. Customer address lists can be fed into a GIS [...]
Environmental Modelling – Monitoring and Models There is a real need for mathematical models to simulate or model various environmental systems, such as water or air quality. [...]