• Services

EXCEL MODELS
EXCEL MODELS EXCEL MODELS

Excel is often used successfully to collect, prepare and present information used to make important business decisions. But the right solution is required for optimal achievement of the benefits of using Excel as a supporting tool for the handling of these processes.


Development of Excel models is our core competence. We focus on streamlining our customers’ processes and models to, in this way, save time in everyday life.

We know how crucial it is for Excel solutions to be user-friendly, easy to maintain and, not least, be adaptable in connection with the changes that naturally occur in a dynamic organization. Our consultants are trained in Best Practice Spreadsheet Modelling, which is our customers’ guarantee that the solution is dynamic, robust and requires minimal maintenance.

In most of our solutions, we use simple VBA programming (macro programming) which, with a little instruction, can be updated and maintained by our customers themselves. In a few solutions, the VBA programming is, in the nature of things, more complex and requires professional assistance if it must be customized. We tailor the complexity to the wishes and needs of our customers. VBA opens up the opportunity for integration with other systems and a higher degree of automation, which boosts the level of our customers’ solutions so that the solutions become both more effective and more secure.

Here are some of the advantages you get by having a solution developed with VBA code:

  • Manual procedures become automated, which saves time and eliminates errors, f. ex., automatic importing of data from a large number of uniform Excel files.
  • It becomes possible to integrate with other programmes in the Office package, f.ex., exporting of graphs and tables directly into a PowerPoint template in connection with management reporting or sending of automatically generated e-mails via Outlook.
  • The same file can be adapted to the needs of several different user types, f.ex., of selected sheets if the user does not have rights to see them. This can eliminate the need for having several versions of the same file for different user groups
READ MORE
Close
ACCESS AND SQLDATABASES
ACCESS- AND SQL-DATABASES ACCESS- AND SQL-DATABASES

You can say a lot of good things about Excel, but a good database it’s not. If Excel no longer covers your needs a solution based on Access- or SQL-technology can be an inexpensive and flexible alternative.


A portion of our customers have started up small databases in a spreadsheet. There is nothing wrong with that – so long as “the database” is very simple and only used by a single user.

But the needs and requirements of some of these solutions increase as they become more and more central in relation to the handling of the process being supported. And, suddenly, you have a solution that’s person-dependent, complex and difficult.

We are specialized in converting these Excel databases into an Access/SQL solution – without running up the budget.

Technically, an Access database is based on the SQL database’s technology, which the vast majority of companies use today. So the opportunity opens up for developing a largely license-free solution which combines the best from both worlds, namely the easily accessible and flexible user interface in Access and the SQL database’s calculating power and security.

Here are some of the advantages you get from choosing a solution in Access:

  • Easy access for entry/handling of complex data, where there are, for example, internal dependencies which come into play.
  • All data are kept in an Access/SQL database, and several users can access data at the same time. Thus, you avoid locked files, distribution of data in several files, etc.
  • Possibility of setting up access rights – thus there are no users who can access data they don’t have the rights to.
  • The underlying database can easily be integrated with other systems, with which, f.ex., you have the opportunity for automatic updating with realized numbers from the ERP system.
READ MORE
Close
FROM EXCEL TO DATABASE
FROM EXCEL TO DATABASE FROM EXCEL TO DATABASE

Increasingly, it occurs that our customers’ needs can best be covered by a solution in which Excel is combined with an underlying database. That, f.ex., can be due to large amounts of data, a wish for simultaneous access by several users, or increased security. In such cases, a combination of Excel and a SQL database ought to be considered as a part of the solution.


We have developed a technology which enables you to keep your Excel-based data in an underlying SQL database. The technology simply requires that the data can be collected in a consistent way, f.ex., via one or several standardized Excel templates. There are no limits on how these Excel templates are framed. That is to say, you achieve the advantages through Excel’s flexibility and the database’s data integrity and data sharing functions.

As with all of our solutions, only a one-time fee is paid for the actual development – so you are free from paying for licenses or other running fixed costs.

Here are some of the advantages you get by choosing a combination of Excel and a database solution:

  • All data are kept in a secure SQL database where several users can access data at the same time. Thus, you avoid the need to distribute data in several Excel files.
  • Possibility for management of file versions and access via database rights. Thus, there are no users who can access data they don’t have the rights to, just as it is not possible to use an incorrect version of a given file.
  • The SQL database can easily be integrated with, f.ex., an ERP system, with which you get the opportunity for automatic updating of the Excel solution with realized numbers from the ERP system.
  • In case of large amounts of data and high complexity, computations can be made directly on the SQL server, which provides a calculating power and speed many times greater than what is possible in Excel.
READ MORE
Close

HOW DO WE PROCEED?

In our meeting with you, we will INITIALLY clarify whether you want to have new solutions developed or existing ones optimized.

No matter the choice, our goal is to ensure that the solutions increase your effectiveness, streamline your processes, and are easy to use every day. 


READ MORE

Type of tasks

Budgeting & forecasting

Budgeting & forecasting

Do you have a difficult and time-consuming budget process that could be in need of a service check?

 

READ MORE

Reporting

Reporting

Are you paying a license fee for a standardized reporting solution that does not meet your needs?

 

READ MORE

Consolidation

Consolidation

Are your consolidation models characterized by lots of manual routines and difficult to get an overview of?

 

READ MORE

Sales forecasting

Sales forecasting

Could you imagine a foundation for forecasting based on realized numbers in a rolling statistical forecast?

 

READ MORE

Salary budgeting

Salary budgeting

Does your salary budget also consist of quite a few different Excel sheets that are sent around among the parties involved in the bu…

 

READ MORE

Profitability analysis

Profitability analysis

Would you like to have a sharp focus on profitability and become wiser about your core business?

 

READ MORE

Calculation model

Calculation model

Is your way of making offers a streamlined process that ensures compliance with, f.ex., standard prices and discount structures in y…

 

READ MORE

Resource planning

Resource planning

Do you need to get a better overview of your planned resource use?

 

READ MORE

Bonus calculation

Bonus calculation

Have you experienced the challenge of handling diverse parameters for bonus calculation for different groups of employees?

 

 

READ MORE

Message us

Thank you for your message. You'll hear from us shortly.

Regards,
exacto

Address in Copenhagen

exacto A/S
Tuborgvej 5
DK-2900 Hellerup

Contact person: Peter Jørgen Nørvig
+45 6179 8060
peter@exacto.dk

Address in Aarhus

exacto A/S
Saralyst Allé 57
DK-8270 Højbjerg

Contact person: Tom Kortegaard
+45 6179 8050
tom@exacto.dk

Shortcuts

Homepage
About exacto
Contact
Cookies

CVR: 3020 2414
Bank: Nordea
Auditor: Deloitte Danmark