The dangers of Excel: Why collecting data with Excel becomes a problem
20 october

The dangers of Excel: Why collecting data with Excel becomes a problem

In 1985, Microsoft Excel was introduced for the Apple Macintosh - almost 40 years later, the spreadsheet programme is one of the most important office tools of every company. The range of functions is enormous and, because it is quick and easy to use, it enjoys great popularity among users. However, Excel also tempts people to use it everywhere possible - regardless of whether better alternatives have already been created for it..

0

Evaluations, analyses and calculations? Excel go!

However, with Excel Hours recorded from projects, orders, purchase orders or sales data are collected. But why does this become problematic?

Working with Excel becomes a problem, for example, when an Excel template is given to several employees for data collection. Each of these employees can change the Excel spreadsheet as desired. For example, they can add or delete columns, rows or sheets. When these data are then brought together, it takes a lot of time to bring the respective adjustments to Excel back into a unit.

From an Excel file, many

Another problem occurs when an Excel sheet is edited by several people in succession. The sheet is distributed by e-mail and can then be sent on as desired. Due to the distribution, it is unclear which is the current version. This means that incorrect sheets are quickly forwarded and processed.

To avoid this problem, it is possible for all employees to edit one and the same Excel spreadsheet. However, simultaneous access is not possible. This is still very easy with personal Excel sheets, as they are only passed on to one or two other people at most. This makes it easy to maintain an overview and to adjust any deviations.

Better with suitable systems

However, it is much easier to handle all data management via a suitable system. ERP, CRM or DMS Software provides the ideal basis for collecting data on a single basis. Adjustments or changes are automatically synchronised. Likewise, the search for corresponding data is facilitated, because every user of the system has access to the data he or she needs. This makes data management simple, efficient and avoids errors.

Better on a uniform data basis

In contrast, the work process with Excel is not only very time-intensive, but any process security is also lost. With evaluations or Calculationsbased on such unclear and inconsistent data, it is no longer possible to work in spite of Excel. What initially appears to be simple use can lead to an uncontrollable accumulation of Excel files. The productivity of the work is lowered and errors are provoked.

MariProject Dashboards

Dashboard functions in MARIProject

SAP Business One has had distinctive functionalities for creating dashboards since version 9 at the latest. But also MARIProject, integrated project software ...
Continue reading ?
metrics

More key figures transparency in the ERP system

Many companies hope that the introduction of ERP software will bring more transparency to their key figures. However, it only becomes clearer...
Continue reading ?
Data Lake vs Warehouse

Data warehouse or data lake

Data lakes and data warehouses are buzzwords one hears when it comes to data retention in the context of big data...
Continue reading ?
BIG DATA for SMEs

Big Data – Relevant for SMEs?

Big data is not relevant for small and medium-sized companies. Such an assessment can often be heard and read ...
Continue reading ?
DATA Science

Data analysis for SMEs

A critical analysis "Data analysis for SMEs" or "Data Science" should actually be one of the top issues for medium-sized companies. For it ...
Continue reading ?
Free MS Power Bi Ebook

Free MS Power Bi Ebook

Microsoft Power Bi is a business intelligence tool that can be used to dock different data sources. The data can be used by the Bi Tool ...
Continue reading ?
Power Bi course

Monthly update to MS Power Bi

Microsoft Power Bi monthly update has been released. Of particular interest is a function that allows users to explore new ways...
Continue reading ?
Update for the data analysis tool: MS Power BI

Update for the data analysis tool: MS Power BI

Microsoft is regularly expanding the functionality of MS Power BI. A new version offers a number of new features...
Continue reading ?
New Reports / Power Bi for SAP Business One

New Reports / Power Bi for SAP Business One

Power Bi is a tool that allows you to analyze and visualize data in the simplest way. Versino has...
Continue reading ?
smart shop with SAP Business One

Smartshop Analytics prototype for SAP Business One

A YouTube video from SAP shows a prototype of a SAP Business One installation that uses SAP HANA Analytics to create new ...
Continue reading ?
0

Leave a Reply

Your email address will not be published. Required fields are marked *
You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>