Welcome!

Blog Post

Accelerating Excel Integration with IT Systems

Advice how to integrate your spreadsheets

Understanding the Problem

The numbers-driven aspect of modern business operations makes working with spreadsheets a nearly inevitable aspect of any business process. Whether you're working through a budget, planning a new project, or tracking results of a project in progress, it's almost certain that Excel or another spreadsheet application will be at the center of your efforts.

Excel's centrality to the modern business also has its downsides, both in its use and in its integration with other IT systems. If knowledge workers are not familiar with all the options that this tool offers, it's easy to spend many hours doing things manually that take seconds for those who know which button to press. This is additionally complicated by the expansive tendency inherent to spreadsheet data -- as spreadsheets grow to thousands of rows or more, tasks which are easily done by hand at the beginning become tedious or nearly impossible.

Furthermore, while nearly everyone in an office knows how to use Excel, often next to nobody will understand how to integrate it with other IT aspects of the business process. Here again, tasks which were easily done 'the manual way' to start with end up slowing or crippling the flow of business.

This state of affairs is as unnecessary as it can be costly. Excel is packed with features enabling the easy import and export of all forms of data to other applications. Good Excel training programs (example:http://www.consultivetraining.com.au/services/microsoft-excel-training/) make this clear -- walking trainees through the process of integrating it with the rest of the businesses' IT systems and in the process saving long hours and a great deal of energy. The fact is, this software is designed to be easy to integrate with other applications.

Integration with Other Office Applications

Excel integrates neatly with Microsoft Word and other Office applications. Word makes it a simple matter to import data from any spreadsheet or import any related graph into a particular word document.

Compared with the old 'copy and paste' approach, this saves document creators time and gives them the full power of Excel's data management capabilities. The formulas and calculations of that spreadsheet work seamlessly in the new document.

Most importantly, the Word-Excel integration is a two way street. There is no need to do twice the work each time the data is updated. A change in Word will change your document, and vice-versa.

Integration with Microsoft SharePoint

Organizations using Microsoft SharePoint for collaboration often completely ignore the extensive ME integration capabilities, to their detriment.

All versions of this program since Microsoft Excel 2003 are compatible with SharePoint. This means you can save any worksheet to a SharePoint document library, you can export your spreadsheet's data to a SharePoint list, and you can take data from a SharePoint list and import it to an Excel spreadsheet.

As simple as these points may seem, bringing SharePoint integration into play gives you the document- and knowledge-management features many organizations desperately need. Versioning, check-out, and content approval can make a tremendous difference in many scenarios.

Of course, there are many more points of integration between these two applications -- too many to list here. Consult your Excel trainer for more information.

Integration with 3rd Party Software

3rd party software, from CRM software, ERP packages, and trading software to specialized knowledge management tools, all often support ME integration. These features are often overlooked, but since this tool represents office end-user's tool of choice for data processing, chances are any specialized package you use has some way of integrating with it.

Conclusion

As Excel is frequently used for easily processing large amounts of business-critical data, integration with other aspects of your IT systems is a quick and easy 'win' for improving the flow of business. The steps for doing this are simple and should be part of any related training program.

References and related resources:

http://office.microsoft.com/en-au/excel/
http://office.microsoft.com/en-au/sharepoint/
http://faculty.educ.ubc.ca/sanderson/courses/HKIN363/LABS/notes/INT.htm

More Stories By Anne Lee

Anne Lee is a freelance technology journalist, a wife and a mother of two.

Latest Stories
SYS-CON Events announced today that CollabNet, a global leader in enterprise software development, release automation and DevOps solutions, will be a Bronze Sponsor of SYS-CON's 20th International Cloud Expo®, taking place from June 6-8, 2017, at the Javits Center in New York City, NY. CollabNet offers a broad range of solutions with the mission of helping modern organizations deliver quality software at speed. The company’s latest innovation, the DevOps Lifecycle Manager (DLM), supports Value S...
SYS-CON Events announced today that Hitachi, the leading provider the Internet of Things and Digital Transformation, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Hitachi Data Systems, a wholly owned subsidiary of Hitachi, Ltd., offers an integrated portfolio of services and solutions that enable digital transformation through enhanced data management, governance, mobility and analytics. We help globa...
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in compute, storage and networking technologies, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology, is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/...
Amazon has gradually rolled out parts of its IoT offerings in the last year, but these are just the tip of the iceberg. In addition to optimizing their back-end AWS offerings, Amazon is laying the ground work to be a major force in IoT – especially in the connected home and office. Amazon is extending its reach by building on its dominant Cloud IoT platform, its Dash Button strategy, recently announced Replenishment Services, the Echo/Alexa voice recognition control platform, the 6-7 strategic...
Building a cross-cloud operational model can be a daunting task. Per-cloud silos are not the answer, but neither is a fully generic abstraction plane that strips out capabilities unique to a particular provider. In his session at 20th Cloud Expo, Chris Wolf, VP & Chief Technology Officer, Global Field & Industry at VMware, will discuss how successful organizations approach cloud operations and management, with insights into where operations should be centralized and when it’s best to decentraliz...
@GonzalezCarmen has been ranked the Number One Influencer and @ThingsExpo has been named the Number One Brand in the “M2M 2016: Top 100 Influencers and Brands” by Analytic. Onalytica analyzed tweets over the last 6 months mentioning the keywords M2M OR “Machine to Machine.” They then identified the top 100 most influential brands and individuals leading the discussion on Twitter.
SYS-CON Events announced today that Juniper Networks (NYSE: JNPR), an industry leader in automated, scalable and secure networks, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Juniper Networks challenges the status quo with products, solutions and services that transform the economics of networking. The company co-innovates with customers and partners to deliver automated, scalable and secure network...
The age of Digital Disruption is evolving into the next era – Digital Cohesion, an age in which applications securely self-assemble and deliver predictive services that continuously adapt to user behavior. Information from devices, sensors and applications around us will drive services seamlessly across mobile and fixed devices/infrastructure. This evolution is happening now in software defined services and secure networking. Four key drivers – Performance, Economics, Interoperability and Trust ...
Data is an unusual currency; it is not restricted by the same transactional limitations as money or people. In fact, the more that you leverage your data across multiple business use cases, the more valuable it becomes to the organization. And the same can be said about the organization’s analytics. In his session at 19th Cloud Expo, Bill Schmarzo, CTO for the Big Data Practice at Dell EMC, introduced a methodology for capturing, enriching and sharing data (and analytics) across the organization...
Developers want to create better apps faster. Static clouds are giving way to scalable systems, with dynamic resource allocation and application monitoring. You won't hear that chant from users on any picket line, but helping developers to create better apps faster is the mission of Lee Atchison, principal cloud architect and advocate at New Relic Inc., based in San Francisco. His singular job is to understand and drive the industry in the areas of cloud architecture, microservices, scalability ...
SYS-CON Events announced today that T-Mobile will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. As America's Un-carrier, T-Mobile US, Inc., is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The Company's advanced nationwide 4G LTE network delivers outstanding wireless experiences to 67.4 million customers who are unwilling to compromise on ...
The explosion of new web/cloud/IoT-based applications and the data they generate are transforming our world right before our eyes. In this rush to adopt these new technologies, organizations are often ignoring fundamental questions concerning who owns the data and failing to ask for permission to conduct invasive surveillance of their customers. Organizations that are not transparent about how their systems gather data telemetry without offering shared data ownership risk product rejection, regu...
Everyone wants to use containers, but monitoring containers is hard. New ephemeral architecture introduces new challenges in how monitoring tools need to monitor and visualize containers, so your team can make sense of everything. In his session at @DevOpsSummit, David Gildeh, co-founder and CEO of Outlyer, will go through the challenges and show there is light at the end of the tunnel if you use the right tools and understand what you need to be monitoring to successfully use containers in your...
Bert Loomis was a visionary. This general session will highlight how Bert Loomis and people like him inspire us to build great things with small inventions. In their general session at 19th Cloud Expo, Harold Hannon, Architect at IBM Bluemix, and Michael O'Neill, Strategic Business Development at Nvidia, discussed the accelerating pace of AI development and how IBM Cloud and NVIDIA are partnering to bring AI capabilities to "every day," on-demand. They also reviewed two "free infrastructure" pr...
New competitors, disruptive technologies, and growing expectations are pushing every business to both adopt and deliver new digital services. This ‘Digital Transformation’ demands rapid delivery and continuous iteration of new competitive services via multiple channels, which in turn demands new service delivery techniques – including DevOps. In this power panel at @DevOpsSummit 20th Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, panelists will examine how DevOps helps to meet th...