Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Colleague, Excel & Word Best of Friends Presented by: Joan Kaun & Yvonne Nelson College of the Rockies
Getting Started • What data are we after ? • The easiest way to retrieve it? • What software will we use ? • Colleague • Excel • Word
How do we find the queries? not sure, use “…”
What query are we looking for? 16:NELSONYJ_YNLABELS
If you have access you can set this query up, otherwise your programmer can do it.
Once the query has run, where does it take us? Back to the main menu.
“Detail” into your report “Labels” to make sure the data is correct.
No, we don’t want to see kermit. This is what we want to see.
To down load this file click on “file” select “download”. Save this file into a directory and you’re done in Colleague.
When you open the file you are given 2 options “Delimited” or “Fixed width”. Select “Fixed width”, then click on “next”.
We want to make sure that the data in each column is the proper fit. If we look at the province and postal code they are combined.
Let’s look at the data. Tip: If you move your mouse to the top of the 1 and in front of the “A” click it selects your whole document then move the mouse onto any column and when you get the line with 2 arrows double click it will adjust all columns to “best fit”.
Cleaning up the data base. Delete blank lines and any columns you do not need.
Insert a row on the top of your data and label each column. These will be your “Headers”.
Save the file. Make sure you save this as an “.xls” spreadsheet, then close Excel.
Go to “Tools”, select “Mail merge”. We now follow 1 - 3
1. You will now see main document, “Create”, select this. A drop down menu will then appear click on “Mailing labels” and then click on “Active window”.
2. Data source, select “Get data”. We then see another drop down menu. Click on “Open data source”.
It now takes you right to “Label Options”. Decide which option works for you and click on it.
We now create our labels. Click on the “Insert merge field” you can now pick and choose from the “Headers” you previously saved.
3. Merge the data into the document. You want to click on “Merge”.
It will give you different options. Use new document, click on “Merge”.
What is a pivot table and how can it help me. • A pivot table is a tool used for interactive data analysis. • We use pivot tables when we have numerous questions on the data we have extracted. • Examples • total salaries • number of employee • total benefits costs
Send this to the hold file, but make sure you have typed NOHEAD under section 7. And other options, page width and length are “0”.
Once again we want to “Download” this file. This is a big file and make take a long time to download.