Inserting Images in a Word 2007 Document

Filed under: Tech Tips, Technology Training Center — TechInfo @ September 30th, 2009

Click here to download a PDF document on  Inserting Images into a Word 2007 Document.  Includes additional instructions on how to search the Flickr Creative Commons for images for your presentations and documents and inserting and formating captions

Tags: ,

Expanding the Axes of an X-Y Scatter Plot in Excel 2007

Filed under: Tech Tips, Technology Training Center — TechInfo @ September 10th, 2008

When you create an X-Y scatter plot in Excel 2007, the default setting will create a chart with axes that end with the largest data points. If you need to extrapolate further data points, you will need to expand the axes of your existing chart.

Click here to download step by step instructions on how to Expand the Axes of an X-Y Scatter Plot in Excel 2007

Keyboard Shortcuts for International Characters in Word 2007

Filed under: Tech Tips — TechInfo @ August 20th, 2008

To create characters such as

à, è, ì, ò, ù,
À, È, Ì, Ò, Ù

in Word 2007, use the keyboard shortcuts listed at the links below

http://office.microsoft.com/en-us/word/HP012303781033.aspx

http://www.fingertipsoft.com/3dkbd/ansitable.html

Tags: ,

Creating a Design Theme in PowerPoint 2007 from the Cortland Branded PowerPoint Files

Filed under: New Services, Tech Tips — TechInfo @ August 5th, 2008

We now have several PowerPoint template designs with the new Cortland logo and bridge graphics available for download on the Communication Guide website – http://www.cortland.edu/commguide/brand/ppt.html

You can incorporate any or all of these PowerPoint file as design themes in PowerPoint 2007 and apply them to existing presentations, or create new ones.

Click here to download instructions on how to download and install these template designs as design themes in PowerPoint 2007.  Please note, if you are going to use the new Cortland approved fonts, you will need to download and install the fonts from this page – http://www.cortland.edu/fonts/ (Instructions for downloading and installing the fonts are included on the page).

Word 2007 – Change the Default Line Spacing and Font Back to Word 2003

Filed under: Tech Tips, Technology Training Center — TechInfo @ March 18th, 2008

Some users still prefer the styles, line spacing and font from Word 2003. To change the default in Word 2007 to that of Word 2003, follow these simple instructions.

1. Open Word 2007 and click on the Home Tab.

2. On the far right, is the ‘Change Styles’ button. Click on the button. On the drop down menu, hold your cursor over ‘Style Set’. From the fly out menu, click on ‘Word 2003’.

3. Click on the ‘Change Styles’ button again and then click on ‘Set as Default’. This sets the default spacing for all new documents to that of Word 2003. Now you are ready to change the default font.

4. The default font in Word 2007 is set to ‘Calibri’. To change this to Times New Roman (or any other font type); click on the small arrow at the bottom right corner of the Font group on the Home Tab. A Font dialogue window will open. Choose the font type, style and size that you want to set as the default and then click the default button at the bottom of the window. A confirmation window will open. Click ok, and the font in your current document and any *NEW* documents based on the normal template (blank documents) will have the spacing, style and font of Word 2003.

5. Ignore steps 2 through 4 if you want to keep the style sets and default font in Word 2007, but just want to change the line spacing. Click on the Page Layout tab and then click on the small arrow on the Paragraph group below ‘Spacing’. The Paragraph dialog window will open. Under the Spacing heading, change the Line Spacing to Single and the After spacing from 10 to 0 pt. Then click on the default button to make this the default spacing for this document and all future new documents.

If you need more information, please contact:

Tera Doty-Blance
Software Training and Support Specialist
Memorial Library B113
(607)753-4056
dotyblancet@cortland.edu
http://library.cortland.edu/ttc/training_center.asp

Adding a Watermark to a Document in Word 2007

Filed under: Tech Tips, Technology Training Center — TechInfo @ January 24th, 2008

Watermarks can be added to the background of a document to help identify it’s status or ownership.To add a watermark in Word 2007, click on the Page Layout tab and then click on the Watermark button in the Page Background group of functions.  You can choose from one of the default options or click on the custom watermark button.A watermark can be an image or text.  In the example in the video below, we added a text watermark that reads ‘First Draft’.  You can also choose the font type, size, color and layout.When you click the ok button in the watermark dialogue window, the watermark appears in the document behind the existing text.  To change or delete the watermark, click on the watermark button again on the Page Layout tab and click on the ‘remove watermark’ button to delete it or the ‘custom watermark’ button to make changes.

More video tutorials from the Technology Training Center can be found on YouTube and in SUNY Cortland’s iTunesU.

If you need more information, please contact:

Tera Doty-Blance
Software Training and Support Specialist
Memorial Library B113
(607)753-4056
dotyblancet@cortland.edu
http://library.cortland.edu/ttc/training_center.asp

Death by PowerPoint

Filed under: Tech Tips, Technology Training Center — TechInfo @ January 4th, 2008

Though the Technology Trainer may lack the comedic timing of this guy, the TTC does offer a “Death by PowerPoint” workshop. Check the TTC website for this month’s schedule.

If you need more information, please contact:

Tera Doty-Blance
Software Training and Support Specialist
Memorial Library B113
(607)753-4056
dotyblancet@cortland.edu
http://library.cortland.edu/ttc/training_center.asp

Activating the Anova Data Analysis Function in Excel 2007

Filed under: Tech Tips, Technology Training Center — TechInfo @ November 27th, 2007

To add the Anova Data Analysis function to Excel 2007, start by opening Excel and clicking on the Office button at the top left of the screen. At the bottom of the drop down menu, click on the’ Excel Options’ button.The Excel Options window will open. In the column on the left, click on the Add-Ins heading. On the right side of the window, scroll down to Inactive Application Add-Ins and click on ‘Analysis ToolPak’ to select it. Then click the Go Button.An ‘Add-Ins’ window will open. Click in the checkbox next to ‘Analysis ToolPak’ and click the OK button. Another window may open that says Excel can’t run the add-in until you install the feature. Click Yes.The Microsoft Office Configuration window will launch. This can take a minute or two to configure. When it is finished, click on the Data tab and the Anova Data Analysis function will appear in the Analysis group on the right side of the ribbon.

<

For more text tutorials, visit the Technology Training Center website at http://library.cortland.edu/ttc/materials.asp .

If you need more information, please contact:

Tera Doty-Blance
Software Training and Support Specialist
Memorial Library B113
(607)753-4056
dotyblancet@cortland.edu
http://library.cortland.edu/ttc/training_center.asp

PDF Add in for Office 2007 Applications

Filed under: Tech Tips, Technology Training Center — TechInfo @ September 14th, 2007

In the new Office 2007 application suite (Word, PowerPoint, Excel, Access, Publisher, Etc), you can convert your files to PDF without Adobe Acrobat Professional.  But first, you have to download and install the PDF add-in.Click on the link below to download and install the free add inhttps://www.microsoft.com/downloads/details.aspx?familyid=F1FC413C-6D89-4F15-991B-63B07BA5F2E5&displaylang=en(Windows Validation Required)

If you need more information, please contact:

Tera Doty-Blance
Software Training and Support Specialist
Memorial Library B113
(607)753-4056
dotyblancet@cortland.edu
http://library.cortland.edu/ttc/training_center.asp

Tags: , ,

Office 2007 in the classroom

Filed under: Academic Computing, New Services, Tech Tips — Josh Peluso @ August 29th, 2007

Welcome back new and returning faculty!  We are about to begin a new semester at SUNY Cortland, and there are a couple of items we would like to advise you of if you plan to teach in one of the Windows Technology Classrooms or computer labs (this does not affect the Macintosh platform at this time). 

• As stated last spring, all the technology rooms and labs have been upgraded to Office 2007.
• Additional information about Office 2007 can also be obtained through the following resources:
 o The Training Center is offering training sessions.  You can find these at http://library.cortland.edu/ttc/training_center.asp
 o Microsoft has also created many self-paced on-line tutorials for both the Office 2007 and Office 2003 application suites.  These are text-based tutorials that include images with an audio narration and are categorized by application and function.  The tutorials can be viewed at:
 o Main Training site:  http://office.microsoft.com/en-us/training/default.aspx
 o Getting Started Training:  http://office.microsoft.com/en-us/getstarted/FX101938921033.aspx
 o More Virtual Labs (90 minutes) http://www.microsoft.com/technet/traincert/virtuallab/office.mspx
 o Differences between Office 2003 and Office 2007: http://office.microsoft.com/en-us/word/HA100744321033.aspx

 If you do not want to upgrade to Office 2007, please be assured that documents created with Office 2003 are compatible with Office 2007 documents (see below). We expect many students to arrive on campus with new computers that have Office 2007 installed on them.  It will be important to tell your students that:
• When they save a document in Office 2007, they should use the “save as” function and save the document as an “a 97 to 2003 document.”
• If someone is still using Office 2003 and they receive an Office 2007 document, they may receive a pop-up dialogue box asking them to download an application that will convert this automatically for them.  If they are comfortable doing so, they may go ahead and install this application.
Sent on behalf of Academic Computing Services