SYS-CON MEDIA Authors: Adine Deford, Cynthia Dunlop, Harry Trott, Xenia von Wedel, Peter Silva

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
The 3rd International Internet of @ThingsExpo, co-located with the 16th International Cloud Expo - to be held June 9-11, 2015, at the Javits Center in New York City, NY - announces that its Call for Papers is now open. The Internet of Things (IoT) is the biggest idea since the creation of the Worldwide Web more than 20 years ago.
"We help companies that are using a lot of Software as a Service. We help companies manage and gain visibility into what people are using inside the company and decide to secure them or use standards to lock down or to embrace the adoption of SaaS inside the company," explained Scott Kriz, Co-founder and CEO of Bitium, in this SYS-CON.tv interview at 15th Cloud Expo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
15th Cloud Expo, which took place Nov. 4-6, 2014, at the Santa Clara Convention Center in Santa Clara, CA, expanded the conference content of @ThingsExpo, Big Data Expo, and DevOps Summit to include two developer events. IBM held a Bluemix Developer Playground on November 5 and ElasticBox held a Hackathon on November 6. Both events took place on the expo floor. The Bluemix Developer Playground, for developers of all levels, highlighted the ease of use of Bluemix, its services and functionalit...
The 4th International DevOps Summit, co-located with16th International Cloud Expo – being held June 9-11, 2015, at the Javits Center in New York City, NY – announces that its Call for Papers is now open. Born out of proven success in agile development, cloud computing, and process automation, DevOps is a macro trend you cannot afford to miss. From showcase success stories from early adopters and web-scale businesses, DevOps is expanding to organizations of all sizes, including the world's large...
Some developers believe that monitoring is a function of the operations team. Some operations teams firmly believe that monitoring the systems they maintain is sufficient to run the business successfully. Most of them are wrong. The complexity of today's applications have gone far and beyond the capabilities of "traditional" system-level monitoring tools and approaches and requires much broader knowledge of business and applications as a whole. The goal of DevOps is to connect all aspects of app...
SAP is delivering break-through innovation combined with fantastic user experience powered by the market-leading in-memory technology, SAP HANA. In his General Session at 15th Cloud Expo, Thorsten Leiduck, VP ISVs & Digital Commerce, SAP, discussed how SAP and partners provide cloud and hybrid cloud solutions as well as real-time Big Data offerings that help companies of all sizes and industries run better. SAP launched an application challenge to award the most innovative SAP HANA and SAP HANA...
When an enterprise builds a hybrid IaaS cloud connecting its data center to one or more public clouds, security is often a major topic along with the other challenges involved. Security is closely intertwined with the networking choices made for the hybrid cloud. Traditional networking approaches for building a hybrid cloud try to kludge together the enterprise infrastructure with the public cloud. Consequently this approach requires risky, deep "surgery" including changes to firewalls, subnets...
Want to enable self-service provisioning of application environments in minutes that mirror production? Can you automatically provide rich data with code-level detail back to the developers when issues occur in production? In his session at DevOps Summit, David Tesar, Microsoft Technical Evangelist on Microsoft Azure and DevOps, will discuss how to accomplish this and more utilizing technologies such as Microsoft Azure, Visual Studio online, and Application Insights in this demo-heavy session.
DevOps is all about agility. However, you don't want to be on a high-speed bus to nowhere. The right DevOps approach controls velocity with a tight feedback loop that not only consists of operational data but also incorporates business context. With a business context in the decision making, the right business priorities are incorporated, which results in a higher value creation. In his session at DevOps Summit, Todd Rader, Solutions Architect at AppDynamics, discussed key monitoring techniques...
Cultural, regulatory, environmental, political and economic (CREPE) conditions over the past decade are creating cross-industry solution spaces that require processes and technologies from both the Internet of Things (IoT), and Data Management and Analytics (DMA). These solution spaces are evolving into Sensor Analytics Ecosystems (SAE) that represent significant new opportunities for organizations of all types. Public Utilities throughout the world, providing electricity, natural gas and water,...
The security devil is always in the details of the attack: the ones you've endured, the ones you prepare yourself to fend off, and the ones that, you fear, will catch you completely unaware and defenseless. The Internet of Things (IoT) is nothing if not an endless proliferation of details. It's the vision of a world in which continuous Internet connectivity and addressability is embedded into a growing range of human artifacts, into the natural world, and even into our smartphones, appliances, a...
How do APIs and IoT relate? The answer is not as simple as merely adding an API on top of a dumb device, but rather about understanding the architectural patterns for implementing an IoT fabric. There are typically two or three trends: Exposing the device to a management framework Exposing that management framework to a business centric logic Exposing that business layer and data to end users. This last trend is the IoT stack, which involves a new shift in the separation of what stuff happe...
The Internet of Things is tied together with a thin strand that is known as time. Coincidentally, at the core of nearly all data analytics is a timestamp. When working with time series data there are a few core principles that everyone should consider, especially across datasets where time is the common boundary. In his session at Internet of @ThingsExpo, Jim Scott, Director of Enterprise Strategy & Architecture at MapR Technologies, discussed single-value, geo-spatial, and log time series dat...
An entirely new security model is needed for the Internet of Things, or is it? Can we save some old and tested controls for this new and different environment? In his session at @ThingsExpo, New York's at the Javits Center, Davi Ottenheimer, EMC Senior Director of Trust, reviewed hands-on lessons with IoT devices and reveal a new risk balance you might not expect. Davi Ottenheimer, EMC Senior Director of Trust, has more than nineteen years' experience managing global security operations and asse...
The Internet of Things will greatly expand the opportunities for data collection and new business models driven off of that data. In her session at @ThingsExpo, Esmeralda Swartz, CMO of MetraTech, discussed how for this to be effective you not only need to have infrastructure and operational models capable of utilizing this new phenomenon, but increasingly service providers will need to convince a skeptical public to participate. Get ready to show them the money!