Monthly report exported from ERP system as a data source for Excel user? Such
usually contains repeated headers, subtotal rows, wrong number format, ..., with export date but
missing selected period. Then, a macro expert steps in, and "codes" (in localized version) copy
and paste operations between hard-coded cell ranges between sheets! Or a user, who copies data
from web (intranet) app into Excel, another user who does conditional sum by selecting
non-adjacent cell ranges instead of using SumIF with defined condition. Manually created Pivot
Tables, Pivot Tables from range instead of a table.
And how about next month? File > New and all
These Excel classic workflows are still being used! Stop it
On the other hand enterprise Business Intelligence solution often shortly after implementation don't meet the
requirements. One makes request to ticketing system, waits for a response and after 6 weeks a
new column appears in report - too long, too expensive, minimal improvement.
Start your data revolution today