Skip to main navigation Skip to main content Skip to page footer
MODERNIZATION OF CONTROLLING
Excel is and remains the No. 1 productivity tool!

The know-how of your organization is stored in large, historically grown Excel files with thousands of cell formulas and code:

Excel mit Formeln

Microsoft Excel has many advantages...

  • Perfectly tailored to your tasks.
  • Works and has proven itself - for years.
  • Inexpensive and safe investment, because Excel is a core product from Microsoft, one of the largest software manufacturers in the world.
  • Comprehensible thanks to cell formulas.
  • Highly complex logic feasible.
  • Flexible: the specialist department can expand the solution independently.
  • Accepted by the users. They are productive in the proven processes.

...but also 3 disadvantages:

1) Error-prone: Manual data entry & corrections. Copy & Paste.

Excel Error in Formula

2) Excel chaos: Which version of the file is the right one?

Excel Files Chaos

3) Operational risk for IT: Excel sprawl is difficult to maintain.

Excel risk time bomb

Therefore, the digitalization of controlling should not be continued purely with Excel.

Is a browser-based reporting system the silver bullet?

Principle:

  • Data is moved to a central database.
  • Output takes place in the browser.

Advantage: The database eliminates the 3 disadvantages of Excel.

  • Error-prone
    The database ensures 100% data quality.
  • Excel chaos
    The database provides exactly the same data to everyone.
  • Operational risk
    Logic is centrally stored in the database, where IT professionals are responsible for maintenance.

Disadvantage: The browser eliminates many advantages of Excel:

  • Perfectly tailored to your tasks.
    If you buy a ready-made system, you'll have to change the way you work.
  • Works and is proven
    Every new development has teething problems, and can also miss the point. Never touch a running system.
  • Inexpensive and investment-secure
    The system is based on a web platform that may become obsolete in the future. Switching to a different platform will then be expensive.
  • Transparent
    There are no cell formulas. Only a developer knows the logic.
  • Highly complex logic feasible
    The new system cannot replace the powerful Excel 100%.
  • Flexible: The department can independently expand the solution.
    Software developers are required.
  • Accepted by users. They are productive in established processes.
    Users have to get used to the new system. New processes first have to be introduced. Training may be necessary.

LeanMIS offers a better reporting system!

LeanMIS combines the advantages of a database and Excel:

With Microsoft Excel, LeanMIS has a future-proof foundation and enables the integration of web-based BI systems, such as the leading Microsoft Power BI.

USP: Reuse of proven Excel files.
 

LeanMIS saves half the development time.

LeanMIS saves half the headaches.

LeanMIS saves half the costs.