Office 2007

From ITS Wiki - Information Technology Services - University of Rhode Island

Jump to: navigation, search

Changes and Compatibility

Education

Microsoft hosts many documents to help get you started using Office. URL: Beginner's training for Office 2007 URL: Free Online Training

Document Formats

The Office 2007 suite offers a host of new features and changes, but does not produce files compatible with older versions of Office. Files such as Word documents now end in .docx (as opposed to the old .doc format), a new XML-based format. Please see Powerpoint Viewer and Word Viewer to convert documents between the two applications.

Ribbon Interface

The menu system has been replaced by a series of tabs known as the "Ribbon" interface. This is designed to incorporate all of the functions into a single view rather than utilize drop-down menus. The new ribbon interfaces for each application are listed below.

Add-ins

Office now supports "add-ins", small applications that can be integrated into Access 2007, Excel 2007, InfoPath 2007, OneNote 2007, PowerPoint 2007, Publisher 2007, Visio 2007, and Word 2007. For instance, Microsoft recently released a "Save as PDF" add-in that allows users to save virtually any document as a PDF.

Word

Ribbon

Home
Cut, Copy, Paste, Font Styles, Paragraph Formatting, Default Styles, Find & Replace

Insert
Pages, Tables, Graphics, Links, Header & Footer, Text Scructure, Symbols

Page Layout
Themes, Page Setup, Background, Indents & Spacing, Alignment

References
Table of Contents, Footnotes, Citations, Captions, Indexing, Authorities

Review
Spelling & Language, Comments, Changes, Security

View
Layout, Rules, Zoom, Window, Macros

Document Views

To see a document in different views, click the layout icons on the right-hand side of the status bar. Users can choose Print, Full Screen Reading, Web, Outline, and Draft modes.

Customize Quick Access Toolbar

Next to the redo and undo buttons at the top, click the down arrow to show a list of available commands. Click on a command to show the icon in the toolbar at the top of Word. To remove an icon, simply click it again in the drop-down menu.

Building Blocks Organizer

In the Insert tab, click the Quick Parts drop-down menu, and select Building Blocks Organizer. From here, you can add pre-designed coverpages, watermarks, formulas, text boxes, tables, indexes, bibliographies, headers, and footers.

Document Zoom

To enlarge or decrease the size of a document, use the slider on the tight-hand side of the status bar. To enter a specific zoom level (i.e. 82%), click the % button to the left of the slider. In the dialog box that appears, use the up and down arrows to select the exact zoom.

Excel

Ribbon

Home
Cut, Copy, Paste, Font Styles, Alignment, Numbers, Cell Styles & Formatting, Find & Replace

Insert
Tables, Graphics, Charts, Links, Text Structure

Page Layout
Themes, Page Setup, Zoom, Gridlines & Headings, Alignment

Formulas
Functions, Defined Names, Auditing, Calculation

Data
Import, Connections, Sort & Filter, Tools, Analysis

Review
Spelling & Language, Comments, Changes

View
Layout, Rules, Zoom, Window, Macros

Formula Tab

To find a specific formula or type of formula, click one of the drop-down menus and select a function. To create your own function in a category, select, "Insert Function" at the bottom of any drop-down menu. Users can then select the data and functions they wish to create or work with.

Text to Columns

In the Data tab, select the spreadsheet information you wish to work with. Click the Text to Columns button, and follow the instructions to convert the comma, semicolon, space, or tab deliminated text into individual columns. This function will automatically replace columns in the spreadsheet.

Powerpoint

Ribbon

Home
Cut, Copy, Paste, Slides, Font Styles, Paragraph Formatting, Drawing, Find & Replace

Insert
Tables, Graphics, Links, Text Structure, Media

Design
Page Setup, Themes, Background

Animations
Preview, Animations, Transitions

Slide Show
Controls, Setup, Monitors

Review
Spelling & Language, Comments, Security

View
Layout, Ruler, Zoom, Color, Window, Macros

Outlook

Adding an Account

To add an account to Outlook, click the Tools button at the top, and select Account Settings. To add an account, click New, and follow the on-screen instructions.

Configuring URI Accounts

1. Open Microsoft Outlook.
2. Select Tools and then click on Account Settings.
3. To create a new account, select the Email tab, then click the New button.
4. Select the POP3, IMAP, or HTTP option, then click next.
5. Enter your information. Then check "manually configure server settings". Click Next.
6. Select the Internet E-mail option, then click Next. Select the account type and enter the server information.
7. Click the More Settings button to configure reply address, outgoing authentication, connection settings, and port settings.
8. When finished, click Next, then Finish.

Use the following incoming/outgoing settings.

When the above is complete click on next, then click finish.

.PST (Mailbox) Quota

Please note that Outlook currently allows a maximum of 2GB (2,000,000 KB) of data to be stored in any inbox. When approaching this amount, users should back up and remove messages from their inbox. Email with large attachments are commonly the source of the problem.

If a mailbox has reached quota and Outlook has trouble functioning properly; download and run the Oversized PST and OST crop tool. This will (by default) remove approximately 25MB of data in the file. It is not recommended to remove much more than 25MB, since removing raw data from an Outlook PST file will corrupt its directory structure, and removing too much may damage it beyond repair. You must run the Microsoft Inbox Repair tool, scanpst.exe, provided with Office 2007 to repair the directory structure and reorganize the raw data.


Related Links:

 POP3 SMTP Mail Servers
 Office 2007 "Save as PDF" Add-in
 Microsoft Office Demo Videos
 http://office.microsoft.com/
 Powerpoint Viewer
 Word Viewer