Customized excel development that fits specific business needs: complementary solution to core IT systems or standalone model
|
_______ ___ Question: Is it possible to apply customized solution for data collection and analysis based on existing platforms and with minimal investment?
Solution: Application development based on Office Method: Process characterization and development of customized solution Result: 100% customized application that fits specific needs_____
|
Excel development has a surprising potential. Its numerous functionalities, simple and complex, allow powerful data analysis possibilities as well as customized data management solutions integrated with other data sources or as a standalone model.
MS Office platforms are available at about 95% of business, governmental, educational, academic and other organizations. Utilizing existing Excel and other Office applications capabilities provide a wide range of applied functionalities and models.
However, only 3% to 7% of users master advanced features and implement effective usage of Excel. Experienced excel expert is capable of agile and cost-effective solution with immediate added-value for organization.
|
|
Question: When Excel is the appropriate solution?
|
Answer:
The appropriate solution should be considered subject to needs. We can distinguish among two major scenarios: 1) There is an existing data software infrastructure - required are additional features in existing system, that estimated to be expensive and last for several months to years 2) There is no an existing data system - reqiured customized and independent solution Now, it is recommended to define the need, number of users, use cases and additional factors. For example, when you need to analyze data from various data sources, Excel can serve as a fast and cost effective solution. In case of multiple remote users, alternative platform for development should be considered. |
Variety of possibilities to integrate excel solutions is really wide:
|
Disciplines |
Solutions for example |
|
Supply chain (Procurement, Logistics, P&C, Production) |
KPI management system |
| Quality & Service | Quality performance system Service calls analysis system |
| Finance |
Expenses reporting management system |
| BI (business intelligence) |
Customers analyzer |
| R&D and laboratories |
Analysis, reporting and back-up system |
| Other | Project management tool Working hours control tool Vacations calculator (tourism) |
