LeTNet Lunch ‘n Learn: What’s New in Office 2007

1. LeTNet Lunch ‘n Learn:What’s New in Office 2007 September 2007

2. Major Changes • The Interface • The Ribbon, Office button, live previews • New file formats • Based on XML - .docx .xlsx .pptx .accdb • Windows Desktop Search (WDS) • Search all emails and documents at once! • SmartArt tools • Quick insertion and formatting of lists, charts, etc. • OneNote • Organizes all types of information into notebooks

3. The Interface • Office button and customizable Quick Access toolbar • Ribbon (with tabs) • Groups of commands, with dialog box launcher in lower right corner • Gallery • Contextual tabs • Help • Task Pane • View Options • Customizable Status bar

4. New File Formats • Microsoft Office XML Format • Compact files, automatically compressed • Default “x” ending cannot include VBA macros or ActiveX controls (so are safer to send and receive) • For backward compatibility, must save in earlier formats • Can download a free plugin for saving as PDF

5. Windows Desktop Search (WDS) • FAST search of documents and emails! • Indexing of documents and emails during system idle time

6. SmartArt

7. OneNote • Collects and manages a variety of data, including text, pictures, drawings, tables, lists, files, screenshots, audio, video, Outlook tasks, hyperlinks, and more • Organizes data into multiple notebooks, with each notebook divided into sections • Each section contains multiple pages • GREAT tool for organizing projects!

8. Some New Things in Word • Preformatted text boxes – pull quotes, sidebars • Live previews – dynamically see formatting changes to your text when you move your pointer over different formatting choices • Source Manager for research papers • Equation writing • Cover Pages, Building Blocks, Quick Styles, and document themes • Contextual spelling checker

9. Some New Things in Excel • Massive spreadsheets, faster processing and smaller file sizes • Live previews and Cell Styles Gallery • Conditional formatting with icon sets • Resizable formula bar • Improved tables (formerly called lists) – calculated columns, total rows, automatic autofiltering, table styles, pivot tables • Revamped charting engine – includes new chart types and visual effects

10. Some new Things in PowerPoint 47 New Things in PowerPoint 2007 • Custom slide layouts • SmartArt diagrams • Add placeholder to slide masters • Outline text • Other text effects • Shape effects • Shape and text effects • Selection pane • Themes • Custom colors • Photo edges • Recolor picture • Shadows • No more MS Graph • Chart elements work like drawing objects • Real-time previews • Kerning • Quick layouts and quick styles • Tables • Zoom slider • Presenter view • Ctrl + G now groups selected items • Insert and Link • Save as PDF • New file format • Columns • Tabs • Slide libraries • Workflow services • Mark as final • Compatibility checker • A few new autoshapes • Better autoshape manipulation • Font effects • Clear all formatting • Better contrast colors when typing • 16:9 page size out of the box • Chart templates • Paste Special has a shortcut • Gradient on lines • Specify ALL CAPS • Inspect Document • New display window • Add a digital signature • Persistent undo and redo • Convert autoshapes to freeforms • Add connection points to shapes

11. 47 New Things in PowerPoint 2007 • A new intuitive look – Called Microsoft Fluent user interface

12. 47 New Things in PowerPoint 2007 • New Zoom/Slider! • Screen layout buttons moved too!

13. Left Blank

14. Reminder:PowerPoint 2007 Training • September 27 • 11:00am-12:30PM • IT Training Room

15. Outlook New Features • The to-do bar • OneNote integration • RSS feeds • Sharepoint Integration • Integrated search • Attachment preview • Improved collaboration and security

16. Outlook “to-do bar”

17. OneNote integration

18. RSS Feeds

19. Sharepoint Integration

20. Attachment Preview

21. Improved Collaboration and Security • Sharepoint Integration • Calendar snapshot • Managed e-mail folders • Secure e-mail with Information Rights Management

22. Access 2007 New Features • Enhanced database templates • Field and table templates • Improved datasheet view • New Layout view speeds form/report design • Office Ribbon eases access to commands • Visual group and sort on reports • Report and Layout view • New split forms – combine datasheet and form view • Embedded macros on objects • Attachment fields for files • Memo fields store rich text and support revision history • Calendar tool for picking dates • Enhanced security and sharepoint integration • PDF and XPS export

23. IT Support for Office 2007 • All Labs and Classrooms have Office 2007 • Cannot have both 2007 and 2003 • Office 2003 will open 2007 files with converter • All LETU computers have converter • Terminal Server has 2003 • IT verifying application compatibility with 2007 • Faculty/Staff may upgrade by 2007 on request • Plan to upgrade all computers Summer 2008

24. Additional Resources • http://office.microsoft.com/training • Office Demos • 2007 Office System User Interface Guides • To ask for Office 2007 to be installed on your office machine: email techsupport@letu.edu