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
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...
SYS-CON Events announced today that Catchpoint Systems, Inc., a provider of innovative web and infrastructure monitoring solutions, has been named “Silver Sponsor” of SYS-CON's DevOps Summit at 18th Cloud Expo New York, which will take place June 7-9, 2016, at the Javits Center in New York City, NY. Catchpoint is a leading Digital Performance Analytics company that provides unparalleled insight into customer-critical services to help consistently deliver an amazing customer experience. Designed ...
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 manage only virtual machines, in a fraction of the footprint and at far lower cost than conventional storage. Tintri offers the choice of all-flash or hybrid-flash platform, converged or stand-alone structure and any hypervisor. Rather than obsess with storage, leaders focus on the business app...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
SYS-CON Events announced today that Cloud Academy 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. Cloud Academy is the industry’s most innovative, vendor-neutral cloud technology training platform. Cloud Academy provides continuous learning solutions for individuals and enterprise teams for Amazon Web Services, Microsoft Azure, Google Cloud Platform, and the most popular cloud computing technologies. Ge...
Cloud Expo, Inc. has announced today that Aruna Ravichandran, vice president of DevOps Product and Solutions Marketing at CA Technologies, has been named co-conference chair of DevOps at Cloud Expo 2017. The @DevOpsSummit at Cloud Expo New York will take place on June 6-8, 2017, at the Javits Center in New York City, New York, and @DevOpsSummit at Cloud Expo Silicon Valley will take place Oct. 31-Nov. 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
"A lot of the enterprises that have been using our systems for many years are reaching out to the cloud - the public cloud, the private cloud and hybrid," stated Reuven Harrison, CTO and Co-Founder of Tufin, in this SYS-CON.tv interview at 16th Cloud Expo, held June 9-11, 2015, at the Javits Center in New York City.
In his keynote at 19th Cloud Expo, Sheng Liang, co-founder and CEO of Rancher Labs, discussed the technological advances and new business opportunities created by the rapid adoption of containers. With the success of Amazon Web Services (AWS) and various open source technologies used to build private clouds, cloud computing has become an essential component of IT strategy. However, users continue to face challenges in implementing clouds, as older technologies evolve and newer ones like Docker c...
20th Cloud Expo, taking place June 6-8, 2017, at the Javits Center in New York City, NY, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy.
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...
Have you ever noticed how some IT people seem to lead successful, rewarding, and satisfying lives and careers, while others struggle? IT author and speaker Don Crawley uncovered the five principles that successful IT people use to build satisfying lives and careers and he shares them in this fast-paced, thought-provoking webinar. You'll learn the importance of striking a balance with technical skills and people skills, challenge your pre-existing ideas about IT customer service, and gain new in...
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. In his session at @ThingsExpo, Craig Sproule, CEO of Metavine, demonstrated how to move beyond today's coding paradigm and shared the must-have mindsets for removing complexity from the develop...
Column Technologies exhibited at SYS-CON's @DevOpsSummit at Cloud Expo, which took place at the Javits Center in New York City, NY, in June 2016. Established in 1998, Column Technologies is a global technology solutions provider with over 400 employees, headquartered in the United States with offices in Canada, India, and the United Kingdom. Column Technologies provides “Best of Breed” technology solutions that automate the key DevOps principals and help our customers meet today’s DevOps and Dig...
Have you ever noticed how some IT people seem to lead successful, rewarding, and satisfying lives and careers, while others struggle? IT author and speaker Don Crawley uncovered the five principles that successful IT people use to build satisfying lives and careers and he shares them in this fast-paced, thought-provoking webinar. You'll learn the importance of striking a balance with technical skills and people skills, challenge your pre-existing ideas about IT customer service, and gain new in...
@DevOpsSummit at Cloud taking place June 6-8, 2017, at Javits Center, New York City, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long developm...