Reusing Your Business Data

<h1>Reusing Your Business Data</h1>Author: <a title="Omnios" href="http://www.articlesbase.com/authors/omnios/115963.htm">Omnios</a> Your company spends a great deal of time and money collecting valuable information about customers, vendors, projects, internal resources and other data to help your run your business effectively and efficiently.  This business data is essential for creating invoices, reviewing reports and monitoring balances.  Having business systems with integration tools makes this data collection easy and controlled. However, what about the other business tasks you need the information from your business software to complete and analyze?  Do you find yourself collecting the same data again so you can use it for these other purposes?  Keeping, maintaining and synchronizing this second set of data often takes additional time and resources your company doesn't have or can not afford. Did you know that your Microsoft Office suite holds many tools to help you "reuse" your business data directly from your business software eliminating the need for this second set of data?  Tools include: <ul> <li>Mail Merge</li> <li>Email Merge</li> <li>Excel PivotTable</li> </ul>  Mail Merge Example Microsoft Word has mail merge functionality where you can create documents based on your business data.  In addition, Word contains a number of preconfigured document templates, envelope sizes and labels, such as Avery, that can be used for the mail merge. Let's say you need to send a new product launch invitation letter to all your customers who live in Illinois.  In this example, we are reviewing a customer table from our business software for merging with a Word document.  Once the data source is selected, you can edit the recipient list to filter out customers with a billing address outside Illinois.  The data source fields can then be inserted, where needed, in your template document.  Once you have finished configuring your template document, select Finish & Merge to review the finished product before printing. <img src="http://www.omnios.com/announcements/imgs/merge-mail-example-1.jpg" alt="merge-mail-example-1.jpg" /> Keep in mind, the mail merge tool is not limited to addresses. It is just one way to take your business data and pull it into documents that you have already preconfigured. You can also create and save vendor name labels for your Accounts Payable files by tapping into your master vendor data and filter only vendors who have been active in the last year. The possible uses are endless. Email Merge Example In addition to the mail merge, Word also has email functionality. With Word, you can create a document and email it to selected Outlook contacts. In our second example, it is nearing the end of the year and you want to send a Holiday party invitation to all your employees and subcontractors. First, create the document you would like to email. You can use one of the many downloadable templates available on the Microsoft Web Site or use one of your own creations. If you want to use a Microsoft template, click New and it will let you review preloaded templates or query the Microsoft site for the one you want. Second, go to the Mailings Tab and click Select Recipients. You can point to your Outlook contacts or another data source if your email list is not in Outlook. You can filter the list to include only the contacts you need to exclude those you do not have an email address for or don't wish to send the invite. Last, click the Finish & Merge to send your email. <img src="http://www.omnios.com/announcements/imgs/email-merge-example-2.jpg" alt="email-merge-example-2.jpg" /> Excel PivotTable Another powerful tool is the Excel PivotTable. The Excel PivotTable tool allows you to directly access your data in the format and structure you need and define how the data should be displayed. The PivotTable function is accessible through: <ul> <li>Insert Menu - PivotTable on the ribbon in Excel 2007</li> <li>Data Menu - PivotTable in the drop down menu in Excel 2003 / XP / 2000 / 97</li> </ul> Let's say you want to see your summary sales figures with the customers running down the left and the fiscal period running across the top. In Excel 2007: <ol> <li>Select the Insert menu and the PivotTable from the ribbon.</li> <li>Select a table or range on the spreadsheet for the PivotTable wizard.</li> <li>Build your report by choosing fields from the PivotTable Field List and choose the location of the results.</li> </ol> <img src="http://www.omnios.com/announcements/imgs/excel-pivottable-3.jpg" alt="excel-pivottable-3.jpg" /> In Excel 2003 / XP / 2000 / 97 <ol> <li>Select the Data menu and the PivotTable from the drop down menu.</li> <li>Choose where you want to view the data.</li> <li>Build your report by choosing the data range.</li> <li>Drag the fields that you want to appear in the Page, Row, Column, and Data selections of the PivotTable.</li> </ol> For each Excel version, the next time you open the spreadsheet you should refresh the data from the data source and it should automatically be updated in the spreadsheet. To Learn More The Microsoft Office Web Site offers a wide variety of hot-to's, templates and solution articles to help you reuse your business data. The site also provides free topic Web training and Webcasts on the Office Suite. <img src="http://www.omnios.com/announcements/imgs/learn-more-4.jpg" alt="learn-more-4.jpg" /> Other Tools If you are looking for a more powerful tool to analyze large amounts of data, the best option is Business Intelligence Tools (BI). BI is a more robust tool designed to perform data analysis in more advanced environments. If you would like more information, visit our website at <a href="http://www.omnios.com"><a href="http://www.omnios.com" target="_blank">www.omnios.com</a></a>.About the Author: Omnios is a leading provider of consulting services for organizations with a focus on business process improvement, financial and project management policies and procedures, and supporting software tools. We work primarily with professional service and project centric businesses that want to improve their profitability and productivity by better managing specific projects, job, cost centers, and initiatives.Article Source: <a href="http://www.articlesbase.com/">ArticlesBase.com</a> - <a href="http://www.articlesbase.com/business-ideas-articles/reusing-your-business-data-742470.html" title="Reusing Your Business Data">Reusing Your Business Data</a>

Your company spends a great deal of time and money collecting valuable information about customers, vendors, projects, internal resources and other data to help your run your business effectively and efficiently. This business data is essential for creating invoices, reviewing reports and monitoring balances. Having business systems with integration tools makes this data collection easy and controlled.

However, what about the other business tasks you need the information from your business software to complete and analyze? Do you find yourself collecting the same data again so you can use it for these other purposes? Keeping, maintaining and synchronizing this second set of data often takes additional time and resources your company doesn't have or can not afford.

Did you know that your Microsoft Office suite holds many tools to help you "reuse" your business data directly from your business software eliminating the need for this second set of data? Tools include:

Mail Merge
Email Merge
Excel PivotTable

Mail Merge Example

Microsoft Word has mail merge functionality where you can create documents based on your business data. In addition, Word contains a number of preconfigured document templates, envelope sizes and labels, such as Avery, that can be used for the mail merge.

Let's say you need to send a new product launch invitation letter to all your customers who live in Illinois. In this example, we are reviewing a customer table from our business software for merging with a Word document. Once the data source is selected, you can edit the recipient list to filter out customers with a billing address outside Illinois. The data source fields can then be inserted, where needed, in your template document. Once you have finished configuring your template document, select Finish & Merge to review the finished product before printing.

Keep in mind, the mail merge tool is not limited to addresses. It is just one way to take your business data and pull it into documents that you have already preconfigured. You can also create and save vendor name labels for your Accounts Payable files by tapping into your master vendor data and filter only vendors who have been active in the last year. The possible uses are endless.

Email Merge Example

In addition to the mail merge, Word also has email functionality. With Word, you can create a document and email it to selected Outlook contacts. In our second example, it is nearing the end of the year and you want to send a Holiday party invitation to all your employees and subcontractors.

First, create the document you would like to email. You can use one of the many downloadable templates available on the Microsoft Web Site or use one of your own creations. If you want to use a Microsoft template, click New and it will let you review preloaded templates or query the Microsoft site for the one you want.

Second, go to the Mailings Tab and click Select Recipients. You can point to your Outlook contacts or another data source if your email list is not in Outlook. You can filter the list to include only the contacts you need to exclude those you do not have an email address for or don't wish to send the invite.

Last, click the Finish & Merge to send your email.

Excel PivotTable

Another powerful tool is the Excel PivotTable. The Excel PivotTable tool allows you to directly access your data in the format and structure you need and define how the data should be displayed. The PivotTable function is accessible through:

Insert Menu - PivotTable on the ribbon in Excel 2007
Data Menu - PivotTable in the drop down menu in Excel 2003 / XP / 2000 / 97

Let's say you want to see your summary sales figures with the customers running down the left and the fiscal period running across the top.

In Excel 2007:

Select the Insert menu and the PivotTable from the ribbon.
Select a table or range on the spreadsheet for the PivotTable wizard.
Build your report by choosing fields from the PivotTable Field List and choose the location of the results.

In Excel 2003 / XP / 2000 / 97

Select the Data menu and the PivotTable from the drop down menu.
Choose where you want to view the data.
Build your report by choosing the data range.
Drag the fields that you want to appear in the Page, Row, Column, and Data selections of the PivotTable.

For each Excel version, the next time you open the spreadsheet you should refresh the data from the data source and it should automatically be updated in the spreadsheet.

To Learn More

The Microsoft Office Web Site offers a wide variety of hot-to's, templates and solution articles to help you reuse your business data. The site also provides free topic Web training and Webcasts on the Office Suite.

Other Tools

If you are looking for a more powerful tool to analyze large amounts of data, the best option is Business Intelligence Tools (BI). BI is a more robust tool designed to perform data analysis in more advanced environments.

If you would like more information, visit our website at www.omnios.com.

Omnios is a leading provider of consulting services for organizations with a focus on business process improvement, financial and project management policies and procedures, and supporting software tools. We work primarily with professional service and project centric businesses that want to improve their profitability and productivity by better managing specific projects, job, cost centers, and initiatives.

Rate this Article:

0 / 5 stars - 0 vote(s)

Re-Publish

Article Source: http://www.articlesbase.com/business-ideas-articles/reusing-your-business-data-742470.html

Article Tags: Business Data, Microsoft Office, Excel, Mail Merge, Email Merge, PivotTable

Related Videos
Related Articles
Ask / Related Q&A

Play

How to Get Salary data

Play

How to Avoid Identity Theft - Identifying Data Thieves

Play

How to Prevent Business Data Loss

Play

How to Back Up Your Business Data

Play

How to Secure Your Business Data

Latest Business Ideas Articles
More from Omnios

Chinese Fertilizer supply-demand for Import and Export market

By: Bharat Book Bureau | 23/12/2009
Bharatbook.com added a new report on "Report on Analysis and Forecast of China Fertilizer (2009-2010)" which gives demand and growth of Chinas fertilizer.

MINI Iphone KA08 Wholesale from china--2g memory

By: Andy | 23/12/2009
This phone really appeals to these folks because this gadget can slide into a small pocket or a thin slot in your purse. It doesn't weigh much or drag you down.

Are You Already Marketing On The Internet

By: temp_113807 | 23/12/2009
Take a moment to think about how you would really answer this question. If given enough thought just about any business owner who utilizes the Internet for any purpose will likely find that whether or not they intentionally organized an Internet marketing campaign, they may already be marketing their products and services on the Internet. This article will examine some subtle ways business owners may already be marketing their business on the Internet.

Star Your Own Home Based Business In 2010! The Time Has Come! You Can Do It!

By: Father Time | 22/12/2009
The person who says it cannot be done should NOT interrupt the person who is doing it!

Making a Ton of Cash Selling Resale Rights?

By: Martinact420 | 22/12/2009
There is always a massive demand for products of all types. I.E. software programs and eBooks and if you have the talent, innovation and time you can cash in on huge market by creating and grating resale rights to your bespoke products (not completely true, read on!) The easiest and fastest way for anyone to start a business or acquire a product is to buy it. So if you are there with a selection of businesses 'In a Box' you are ready to take control of the market and make a ton of cash.

Tips on Setting up a Good Welding Business

By: Andrei Smith | 22/12/2009
Setting up a welding shop isn’t as easy as it seems. People who want to enter in this business should possess technical expertise in many welding practices, know the basics of running a service-oriented enterpise, and, most importantly, understand the importance of following safety procedures.

Value Boosting – Putting the Fun in Funding!

By: Christine Comaford | 22/12/2009
Company valuation is emotional – it is FUN! After all, a company is worth what an acquirer will pay, what the market will pay, what the interested parties perceive. We see evidence of this frequently when companies with a trickle of revenue are acquired for gushing millions or even billions of dollars. So you get to be the master of ceremonies here and PRESENT your vision.

Value Boosting – Putting the Fun in Funding!

By: mightyventures | 22/12/2009
Company valuation is emotional – it is FUN! After all, a company is worth what an acquirer will pay, what the market will pay, what the interested parties perceive. We see evidence of this frequently when companies with a trickle of revenue are acquired for gushing millions or even billions of dollars. So you get to be the master of ceremonies here and PRESENT your vision.

If We Only Had a Better System - Five Insights into this Common Ailment

By: Omnios | 23/09/2009 | Ask an Expert
If you had a dollar for every excuse or lament that started with, "If only we had a better system....," you'd be retired and yachting off the coast of San Tropez, right? What if you discover "the system" is more than likely not the problem? What if you can use the system you already have to get what you need done?

Is All Your Data Slowing You Down?

By: Omnios | 19/05/2009 | Databases
Have you been using the same accounting system for awhile now? Well, the good news is that you have years of historical data to use! Read more to learn now.

Omnios Business And Financial Management Consulting

By: Omnios | 25/02/2009 | Ask an Expert
Omnios specializes in planning, designing and building streamlined and effective internal business management strategies and systems that allow companies to focus on their strategic objectives and run a successful business.

Consulting Firm Helps Clients Improve Business Processes With Integrated Solution

By: Omnios | 02/02/2009 | Project Management
Omnios uses Microsoft Dynamics SL to provide customers with easy-to-implement, integrated solutions that adept to their individual business needs, which in turn, helps Omnios expand its own business.

Making The Most Of Your Human Resources Data

By: Omnios | 27/01/2009 | Human Resources
Your company is already collecting the key HR information it needs to maintain business operations and meet labor regulations, but are you getting the most out of the data? Making thee most of your data doesn't only depend on the information, but also the strategy addressing how it is organized, used and accessed.

Reusing Your Business Data

By: Omnios | 27/01/2009 | Business Ideas
Your company spends a great deal of time and money collecting valuable information about customers, vendors, projects, internal resources and other data to help you run your business effectively and efficiently. This business data is essential for creating invoices, reviewing reports and monitoring balances. Do you find yourself collecting the same data again so you can use it for these other purposes? Keeping, maintaining and synchronizing this second set of data often takes additional time