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
Complete Internet of Things (IoT) embedded device security is not just about the device but involves the entire product’s identity, data and control integrity, and services traversing the cloud. A device can no longer be looked at as an island; it is a part of a system. In fact, given the cross-domain interactions enabled by IoT it could be a part of many systems. Also, depending on where the device is deployed, for example, in the office building versus a factory floor or oil field, security ha...
An IoT product’s log files speak volumes about what’s happening with your products in the field, pinpointing current and potential issues, and enabling you to predict failures and save millions of dollars in inventory. But until recently, no one knew how to listen. In his session at @ThingsExpo, Dan Gettens, Chief Research Officer at OnProcess, will discuss recent research by Massachusetts Institute of Technology and OnProcess Technology, where MIT created a new, breakthrough analytics model f...
"We have several customers now running private clouds. They're not as large as they should be but it's getting there. The adoption challenge has been pretty simple. Look at the world today of virtualization vs cloud," stated Nara Rajagopalan, CEO of Accelerite, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
Fifty billion connected devices and still no winning protocols standards. HTTP, WebSockets, MQTT, and CoAP seem to be leading in the IoT protocol race at the moment but many more protocols are getting introduced on a regular basis. Each protocol has its pros and cons depending on the nature of the communications. Does there really need to be only one protocol to rule them all? Of course not. In his session at @ThingsExpo, Chris Matthieu, co-founder and CTO of Octoblu, walk you through how Oct...
There are several IoTs: the Industrial Internet, Consumer Wearables, Wearables and Healthcare, Supply Chains, and the movement toward Smart Grids, Cities, Regions, and Nations. There are competing communications standards every step of the way, a bewildering array of sensors and devices, and an entire world of competing data analytics platforms. To some this appears to be chaos. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, Bradley Holt, Developer Advocate a...
SYS-CON Events announced today that Bsquare has been named “Silver Sponsor” of SYS-CON's @ThingsExpo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. For more than two decades, Bsquare has helped its customers extract business value from a broad array of physical assets by making them intelligent, connecting them, and using the data they generate to optimize business processes.
As organizations shift towards IT-as-a-service models, the need for managing and protecting data residing across physical, virtual, and now cloud environments grows with it. Commvault can ensure protection, access and E-Discovery of your data – whether in a private cloud, a Service Provider delivered public cloud, or a hybrid cloud environment – across the heterogeneous enterprise. In his general session at 18th Cloud Expo, Randy De Meno, Chief Technologist - Windows Products and Microsoft Part...
SYS-CON Events announced today that Tintri Inc., a leading producer of VM-aware storage (VAS) for virtualization and cloud environments, will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Tintri VM-aware storage is the simplest for virtualized applications and cloud. Organizations including GE, Toyota, United Healthcare, NASA and 6 of the Fortune 15 have said “No to LUNs.” With Tintri they mana...
The Internet of Things will challenge the status quo of how IT and development organizations operate. Or will it? Certainly the fog layer of IoT requires special insights about data ontology, security and transactional integrity. But the developmental challenges are the same: People, Process and Platform and how we integrate our thinking to solve complicated problems. In his session at 19th Cloud Expo, Craig Sproule, CEO of Metavine, will demonstrate how to move beyond today's coding paradigm ...
So, you bought into the current machine learning craze and went on to collect millions/billions of records from this promising new data source. Now, what do you do with them? Too often, the abundance of data quickly turns into an abundance of problems. How do you extract that "magic essence" from your data without falling into the common pitfalls? In her session at @ThingsExpo, Natalia Ponomareva, Software Engineer at Google, provided tips on how to be successful in large scale machine learning...
Digitization is driving a fundamental change in society that is transforming the way businesses work with their customers, their supply chains and their people. Digital transformation leverages DevOps best practices, such as Agile Parallel Development, Continuous Delivery and Agile Operations to capitalize on opportunities and create competitive differentiation in the application economy. However, information security has been notably absent from the DevOps movement. Speed doesn’t have to negat...
The Jevons Paradox suggests that when technological advances increase efficiency of a resource, it results in an overall increase in consumption. Writing on the increased use of coal as a result of technological improvements, 19th-century economist William Stanley Jevons found that these improvements led to the development of new ways to utilize coal. In his session at 19th Cloud Expo, Mark Thiele, Chief Strategy Officer for Apcera, will compare the Jevons Paradox to modern-day enterprise IT, e...
There is little doubt that Big Data solutions will have an increasing role in the Enterprise IT mainstream over time. Big Data at Cloud Expo - to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA - has announced its Call for Papers is open. Cloud computing is being adopted in one form or another by 94% of enterprises today. Tens of billions of new devices are being connected to The Internet of Things. And Big Data is driving this bus. An exponential increase is...
IoT offers a value of almost $4 trillion to the manufacturing industry through platforms that can improve margins, optimize operations & drive high performance work teams. By using IoT technologies as a foundation, manufacturing customers are integrating worker safety with manufacturing systems, driving deep collaboration and utilizing analytics to exponentially increased per-unit margins. However, as Benoit Lheureux, the VP for Research at Gartner points out, “IoT project implementers often ...
Your business relies on your applications and your employees to stay in business. Whether you develop apps or manage business critical apps that help fuel your business, what happens when users experience sluggish performance? You and all technical teams across the organization – application, network, operations, among others, as well as, those outside the organization, like ISPs and third-party providers – are called in to solve the problem.