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
Property Portfolio Management Spreadsheet We built the Property Portfolio Workbook for an estate agency that wanted to keep track of their clients portfolios of property investments. The idea was that the agent [...]
Environmental Modelling – Monitoring and Models Estimated driving times can play a vital role in spacial data analysis. Customer address lists can be fed into a GIS system and processed to find [...]
Environmental Modelling – Monitoring and Models There is a real need for mathematical models that simulate or model various environmental modelling systems, such as water or air quality. Environmental quality measurements [...]
Daily work orders updated automatically in Excel Drawing data from one spreadsheet and inserting it into another spreadsheet is a very common and time consuming process in the business environment. A [...]