MS Office applications are available in vast majority of organizations and houses, however, their functional potential is not fairly utilized.
|
_______ ___
Issue: MS Office applications interconnectivity and collaboration features are barely used
Solution: Recognizing the massive use cases between Office applications and development of add-ins and customized features
Result: Utilization of "hidden" functionalities of familiar and available tools
_____
|
Connectivity and integration between different Office applications allow development and implementation of varios automatic data processes.
For example:
- Building PowerPoint presentations automatically
- Distribution of files to mailing lists in Outlook or other email protocols
- Transactions with Access databases
- Generating files to SharePoint
- Building text reports in Word based on SQL Server databases
- Utilizing Web connectivity
Using those capabilities makes it possible to design simple models that supplement existing information systems and create new opportunities.
|
|
Question:
What are pro's and con's of customized solutions and unique add-ins in Office compared to other solutions?
|
Answer:
Pro's:
1) Availability of main Office platforms in organizations and householders
2) Development flexibility and time to market
3) Cost efficient solutions
4) Main applications (like Excel, Word, Outlook) are well-known
5) A lot of time can be saved by automation programming
6) Integration to varios data systems is possible via export/import of data files
7) Many professionals and available knowledge
Con's:
1) Technology pace and cloud solutions allow new portions of features
2) Users number and data quantities impact performance
3) Compatibility issues between Office versions
|
