MS Office 2007

Slide 2:2007 Microsoft Office System

WHAT’S NEW AND WHAT’S DIFFERENT A presentation by Patrick Douglas Crispen You will want to upgradeYou will want to upgrade

Slide 3:2007 Microsoft Office in a Nutshell

Next version of Office Major redesign of the user interface New file formats Release dates: Corporate: November 30, 2006 Consumer: January 30, 2007 Eight different Office suites available No free upgrades

Slide 4:Biggest Changes

User Interface The ribbon Menus have been replaced with task-specific tabs Galleries and themes Formatting options are pre-rendered Live Preview Formatting changes can be previewed without applying them Ribbon Menu system in Outlook, Publisher, and InfoPath Ribbon in Word, Excel, PowerPoint, Access, and Outlook for mail, contacts, and appointments. Brings most popular commands to the forefront Three components Tabs – organized by major activity area Groups Commands Groups have small dialog box launcher icon to take you to group options Some tabs only appear when you need them [e.g., picture tools] Office button replaces File menu Quick access toolbar: Save, Undo, Redo, and Print Add other commands to quick access toolbar by right-clicking the command or choosing customize quick access toolbar You can hide the ribbon Old keyboard shortcuts [like control B] still work New: Alt key shortcutsRibbon Menu system in Outlook, Publisher, and InfoPath Ribbon in Word, Excel, PowerPoint, Access, and Outlook for mail, contacts, and appointments. Brings most popular commands to the forefront Three components Tabs – organized by major activity area Groups Commands Groups have small dialog box launcher icon to take you to group options Some tabs only appear when you need them [e.g., picture tools] Office button replaces File menu Quick access toolbar: Save, Undo, Redo, and Print Add other commands to quick access toolbar by right-clicking the command or choosing customize quick access toolbar You can hide the ribbon Old keyboard shortcuts [like control B] still work New: Alt key shortcuts

Slide 5:Biggest Changes

User Interface Mini Toolbar Formatting controls appear when you highlight text Super-tooltips Tooltips contain more detailed information Quick Access Toolbar Office-wide repository of the most used functions and tools Zoom Slider Zoom in or out using a slider Mini-toolbar: The “floaty” Highlight text Super-tooltips Click on any tool for help Quick access toolbar Top of screen, to the right of the Microsoft button Zoom slider Bottom right corner of the document window Mini-toolbar: The “floaty” Highlight text Super-tooltips Click on any tool for help Quick access toolbar Top of screen, to the right of the Microsoft button Zoom slider Bottom right corner of the document window

Slide 6:Biggest Changes

Smart Art Create your own formatted diagrams – list, process, cycle, heirarchy -- using bulleted or ordered lists Insert > Smart Art Use Word for smart art objects with fewer than 30 shapes Use Visio for up to 1000 shapesCreate your own formatted diagrams – list, process, cycle, heirarchy -- using bulleted or ordered lists Insert > Smart Art Use Word for smart art objects with fewer than 30 shapes Use Visio for up to 1000 shapes

Slide 7:Biggest Changes

File Formats Office button New file format .docx, .pptx, .xlsx Open XML filetype with ZIP file container 75% smaller than other Office file formats Compatibility: Plug-in needed to open Office 2007 files in Office 2003 or Office 2000/XP “Down convert” in 2007 to a compatible filetype through Save As… Export to PDF Requires free plug-in Export to XPS

Slide 8:Biggest Changes

User Assistance System Click on the ? In the upper right corner or hit F1 SHOW THE WORD DEMOS!Click on the ? In the upper right corner or hit F1 SHOW THE WORD DEMOS!

Slide 9:Microsoft Word 2007

WHAT’S NEW AND WHAT’S DIFFERENT

Slide 10:Microsoft Word 2007

Auto citations according to APA, Chicago, and MLA Building blocks Cover page gallery Blog posting Style sheets Word count listed in status bar Contextual spell checker Translation tool tip Document comparison engine Fullscreen layout Document inspector INSERT 5 RANDOM PARAGRAPHS: =rand(5) Auto citiation: References > Insert Citation Building blocks [reusbable items]: Insert bar > Quick Parts [or header or footer] Cover page gallery: Insert > Cover Page Blog posting: Office Button > New > Blog Post … Office Button > Publish > Blog [Windows Live Spaces, SharePoint, Blogger, Community Server, etc] Style Sheets > Home tab > Change Styles Word Count: bottom of the document windows Contextual spell checker: catches correctly spelled words used incorrectly [blue underline] Translation: Review > Translation Screentip … Right-click on the word > translate [?] Document comparison: Review > Compare Fullscreen: View tab Document inspector: Office button > Prepare > Inspect document [remove personal info] INSERT 5 RANDOM PARAGRAPHS: =rand(5) Auto citiation: References > Insert Citation Building blocks [reusbable items]: Insert bar > Quick Parts [or header or footer] Cover page gallery: Insert > Cover Page Blog posting: Office Button > New > Blog Post … Office Button > Publish > Blog [Windows Live Spaces, SharePoint, Blogger, Community Server, etc] Style Sheets > Home tab > Change Styles Word Count: bottom of the document windows Contextual spell checker: catches correctly spelled words used incorrectly [blue underline] Translation: Review > Translation Screentip … Right-click on the word > translate [?] Document comparison: Review > Compare Fullscreen: View tab Document inspector: Office button > Prepare > Inspect document [remove personal info]

Slide 11:Microsoft PowerPoint 2007

WHAT’S NEW AND WHAT’S DIFFERENT

Slide 12:Microsoft PowerPoint 2007

Custom layouts New diagrams, models, and templates Improved text and 3D graphic rendering Improved Dual-Screen Presenter View Widescreen support Slide library Custom layouts [create your own slide layouts]: View tab > Slide master > Insert Layout Slide library [REQUIRES SHAREPOINT SERVER]: Office button > Publish Custom layouts [create your own slide layouts]: View tab > Slide master > Insert Layout Slide library [REQUIRES SHAREPOINT SERVER]: Office button > Publish

Slide 13:Microsoft Excel 2007

WHAT’S NEW AND WHAT’S DIFFERENT

Slide 14:Microsoft Excel 2007

Formula auto complete Auto quicksum Conditional formatting Color scales Icon sets Data bars Page layout view Worksheet limit raised to 1,048,568 rows and 16,384 columns New charting engine Pivot tables support hierarchical data Forumula autocomplete: walks you through the formulas Quicksum > Highlight and sum Charting: Insert > Charts Forumula autocomplete: walks you through the formulas Quicksum > Highlight and sum Charting: Insert > Charts

Slide 15:Microsoft Outlook 2007

WHAT’S NEW AND WHAT’S DIFFERENT

Slide 16:Microsoft Outlook 2007

RSS reader Faster searching Text messaging and SMS support Support for multiple simultaneous calendars Flagged items can be converted to tasks To Do bar Shareable contacts Attachment preview

Slide 17:Microsoft Access 2007

WHAT’S NEW AND WHAT’S DIFFERENT

Slide 18:Microsoft Access 2007

Support for more data types including documents and images Referential integrity checks Table updates auto update referencing reports Lookup Fields support multi valued lookups

Slide 19:The 8 Different Office Suites

WHAT’S INCLUDED

Slide 21:Office Basic 2007

Only available through OEMs Word Excel Outlook

Slide 22:Office Home & Student 2007

$149 retail / no upgrade available Word Excel PowerPoint OneNote [notetaking]

Slide 23:Office Standard 2007

$399 retail / $239 upgrade Word Excel PowerPoint Outlook

Slide 24:Office Small Business 2007

$449 retail / $279 upgrade Word Excel PowerPoint Publisher Outlook with Business Contact Manager

Slide 25:Office Professional 2007

$499 retail / $329 upgrade Word Excel PowerPoint Publisher Access Outlook with Business Contact Manager

Slide 26:2007 Microsoft Office in a Nutshell

Next version of Office Major redesign of the user interface New file formats Release dates: Corporate: November 30, 2006 Consumer: January 30, 2007 Eight different Office suites available No free upgrades

Slide 27:2007 Microsoft Office System

WHAT’S NEW AND WHAT’S DIFFERENT A presentation by Patrick Douglas Crispen You will want to upgradeYou will want to upgrade