Transcript WHAT'S NEW IN OFFICE 2007-2010

WHAT'S NEW IN OFFICE 2007-2010
20/07/2015
© - Danny Puype – Trainer/Developer
OFFICE
20/07/2015
INTERFACE

The Ribbon & contextual ribbons







Screen resolution dependancy
Groups and dialog box launchers
Ctrl-F1
Alt: key tips
Showing the Developer Tab
The Office Button (2007)
Backstage (2010)







File save/close/recent files and places
Versions
Info
New files based on templates / existing documents
Print
Options
Save and send
© - Danny Puype – Trainer/Developer
20/07/2015
INTERFACE (2)






The Quick Access Toolbar
Mini Toolbar
Zoom and views
Screen tips
Status Bar
Panes





Online & offline template interface
Global Changes




Recovery pane (2007)
Navigation pane (2007-2010)
Selection pane
Colour
Proofing
Languages
Help - F1
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
FORMATTING

Using Themes to format a Document
 More
themes (2010)
Live Preview
 Paste with live preview (2010)
 Shape Styles
 Colours
 Improved wordart

20/07/2015
FEATURES




Printing (2010)
PDF saving and emailing
Smart Art
Photo/Video editing tools





Prepare (2007) – Backstage (2010)






Properties
Inspect & Encrypt
Recovery features & Versions
Language selection for interface, help & Proofing tools
Document inspector
Permissions (2010)





Screenshots
Image Background Removal tool
Adjustments
Styles
Mark as final
Password
Access to IRM – Information Rights Management
Digital Signature
Save to web & save to Sharepoint
© - Danny Puype – Trainer/Developer
20/07/2015
TECHNICALLY

New File Formats




Compatibility with Previous Versions









Protected view (2010)
Trusted Documents (2010)
File block settings (2010)
Privacy options (2010)
Macro & developer ribbon


Compatibility mode
Trust Center


Macro enable formats
XML compatible
Other format and saving features
Customisation of Quick access toolbar & Ribbon (2010)
Sharepoint integration
Office diagnostics
Digital signatures
Password encryption
64-bit version (2010)
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
LINKS

Microsoft sites
http://www.microsoft.com/Office2010
 Microsoft Office blog

 http://blogs.office.com/

Microsoft Office 2010 Engineering blog
 http://blogs.technet.com/b/office2010/

Office 2010 migration guides
 http://office.microsoft.com/en-us/excel-help/office-2010-
migration-guides-HA101982272.aspx

Infoworld

http://www.infoworld.com/d/windows/the-top-25-newoffice-2010-features-827
20/07/2015
© - Danny Puype – Trainer/Developer
EXCEL
20/07/2015
INTERFACE
Inserting a Sheet
 Page Layout View & full screen
 Changes to Pivot Tables Environment
 Formulas

Formulas libraries
 Formula Auto Complete

Resizing the Formula Bar
 Changes to Charts Environment



Charts: double click (Excel 2010)
Save Workspace
© - Danny Puype – Trainer/Developer
20/07/2015
FORMATTING
Styles
 Themes
 Tables

© - Danny Puype – Trainer/Developer
20/07/2015
FEATURES

Conditional Formatting





Working with Named Ranges
Changes to Excel Tables (Lists)





Increased functionality
Table headers (Excel 2010)
Structured References in Excel Tables
Remove duplicates
Charts & charting




Conditional Formatting Rules Manager
Multiple rules and functionality
More features (Excel 2010)
Interface and functionality
Selection pane
Sparklines (Excel 2010)
Save a workspace
© - Danny Puype – Trainer/Developer
20/07/2015
FEATURES (2)


Get external data
Enhanced Sorting and Filtering




Pivottables (Excel 2010)









Multiple filter and sorting options
Sorting by Icon, Cell Color or Font Color
New search filter (Excel 2010)
Labels fill down
Better filtering
Show values as
Pivot chart improvements
Slicers
PowerPivot add-in
Improved Solver add-in (Excel 2010)
Sharing
Equations (Excel 2010)
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
TECHNICALLY

New Excel File Types
 xlsx,
xlsm, xltx, xltm, xlam
 XML, binary
Limit Changes
 Macro recorder for chart elements (Excel 2010)

20/07/2015
© - Danny Puype – Trainer/Developer
WORD
20/07/2015
INTERFACE

Views




The Reviewing Pane



Dedicated ribbon & Interface changes
Specific features





Dedicated ribbon & Interface changes
Extras: Tracking Moved Text – Restrictions…
Mail Merge


Full Screen view & options
Draft view
View and zoom shortcuts
Breaks
Line numbers
Spacing between Paragraphs
Ruler / Gridlines
Styles




Creating and Using Quick Styles
Displaying the Styles Pane
Using the Apply Styles Window
The Style Inspector
© - Danny Puype – Trainer/Developer
20/07/2015
FORMATTING



Themes
Smart art (2007 – 2010)
Tables



Text



Table styles
Contextual ribbons
Text effects (2010)
Open type typography (2010)
Images and graphics








Artistic effects (2010)
Pictures styles
Picture effects (2010)
Adjustments (2010)
Picture layouts (2010)
Screenshots (2010)
Background removal (2010)
Selection pane
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
FEATURES

Navigation Pane and search (2010)




Quickly inserting Building Blocks (2007)







Using, managing headings
Search
Thumbnail navigation
Using from autotext, coverpages, H/F, tables, watermarks…
Creating a Quick Part Building Block
Managing Building Blocks (Galleries and categories)
Inserting fields
Text boxes & text box gallery
Contextual Spelling (2007)
Improved Compare and Combine
20/07/2015
© - Danny Puype – Trainer/Developer
FEATURES (2)

Document protection and restrictions (2007)
Restrict editing
 Mark a document as final (2010)
 Digital signature and Signature line


References
TOC
 Bibliography and Citations Feature

New Numbering features (2010)
 Mini-translator (2010)
 Blog posting (2007)

20/07/2015
TECHNICALLY

New Word File Types
 docx,
docm, dotx, dotm
 rtf does not support new features
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
POWERPOINT
20/07/2015
© - Danny Puype – Trainer/Developer
INTERFACE

Dedicated ribbons
 Animations
 Show
 Reviewing
 Drawing
tools (sub or contextual ribbon)
Insert Photo Album
 Table and Chart enhancements

20/07/2015
FORMATTING
Background Styles
 Converting a Shape to Free form
 Improvements to Gradients
 Resetting Placeholders
 New designs & themes
 Colour schemes
 Effects

shadow
 photo edges
 etc

© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
FEATURES


The Selection and Visibility Pane
Text Features








Masters





Text Wrapping & kerning
Text Direction
Columns
Selecting Separate Areas of Text
Indents & Tabs by Paragraph
Outline text
All kind of text effects
Adding a Customized Layouts
Adding Placeholders to a Slide Master
Sections
Smart art and Converting to Smart Art
Many new photo editing features (global office changes)
20/07/2015
FEATURES (2)



Presenter view & resolution settings
Transition improvements
Animations



Video editing (2010)





More formats: QuickTime, Flash, Windows Media, and MP4.
Video from online sources
Editing possibilities for video
Output to video
Collaboration



Triggers
Animation painter
Compare
Review changes
Features No Longer Available.







Recolor picture
Macro recorder
Animation schemes
Summary slide
Autocontent wizard
Send for Review
Black & White for Charts
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
TECHNICALLY

New PowerPoint FileTypes
 pptx
 potx
 pptm
Save as a webpageby save to web (Windows
Live ID)
 Broadcast slideshows (Windows Live ID)

20/07/2015
© - Danny Puype – Trainer/Developer
OUTLOOK
20/07/2015
© - Danny Puype – Trainer/Developer
INTERFACE

General







Mail




Navigation Pane Improvements
Ribbon integration and ribbon improvements
Simplified Steps for Sharing Calendar, Contacts, Tasks, Notes
The To-Do Bar (2007) & improvements (2010)
View zoom control (2010)
Favorite folders & search folders
Previewing an Attachment
Viewing Next/Previous Message in a Single Email
Out of Office Assistant improvements
Calendar





Changing Detail Level in Month View
Viewing To-Do Items in the Calendar
Overlaying Multiple Calendars
Showing Full or Work Week
New Schedule View (2010)
20/07/2015
FORMATTING

Categories
 Color-Coded
Categories
 Assigning Items to Categories
Flag formatting
 Generic offices features

 Themes
 Paste
special live preview
 Picture editing (2010)
 Smart art
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
SPECIFIC MAIL FEATURES


Flags & flag to task
Conversation Management (2010)





MailTips (Exchange server)
Quick steps (2010)
Attachments







Conversation view
Clean up feature
Save and removing attachments
Preview
Reduce image sizes & screenshots
Voice mail and faxes to inbox
Adding an Electronic Business Card to an Email
Detailed delivery information (Exchange server)
Integrated Email archive (Exchange server)
20/07/2015
© - Danny Puype – Trainer/Developer
SPECIFIC CALENDAR FEATURES
Restricting Access to Free/Busy Information
 Scheduling Assistant
 Meeting Suggestions (2010)
 Meeting Change Notifications
 Meeting reply (2010)
 Calendar Quick View in Meetings Requests
 Team or Groups Calendars (Exchange server)
 Room finder (Exchange server)
 Calendar sharing through Office.com

20/07/2015
© - Danny Puype – Trainer/Developer
VARIOUT OTHER FEATURES

Accounts












Improved Accounts management & Auto Account setup
Multiple Exchange accounts (Exchange server)
Better synchronisation with Hotmail, Gmail and others
Search tools & queries enhancements
Auto-Complete List improvements
Word integrated features (quickpart, symbols, objects…)
Autotext and signature improvements
Include screen shot (2010)
Sending a Calendar Snapshot by Email
People pane (2010)
Cleanup tools and Quota Thermometer (2010)
Outlook Social Connector (OSC) (2010)
20/07/2015
© - Danny Puype – Trainer/Developer
TECHNICALLY

Adjacent Technologies




Internet





Word engine for Html mail
RSS support
Roaming


Sharepoint lists
Extended browser support for OWA and Sharepoint (2010)
Infopath integration
Signatures (2010)
Categories (2007)
IMAP improvements (2010)
Improved data caching
20/07/2015
© - Danny Puype – Trainer/Developer
ACCESS
20/07/2015
© - Danny Puype – Trainer/Developer
INTERFACE
Get started screen and db templates
 Datasheet view
 Tabulated windows
 Enhanced sorting and filtering
 Import and export wizards

20/07/2015
FORMATTING
Alternate background colour
 Themes in Forms & Reports

© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
FEATURES
Layout view
 Navigation pane
 New components

Splitted form
 Embedded macros
 Attachment field
 Multivalued fields
 Rich text and tracking
changes to memo fields
 Calendar in date fields

Report view
 Groups in reports
 Totals
 Import and Export
improvements
 Data collection through
Outlook and Infopath
 XML and PDF support

20/07/2015
TECHNICALLY
Security
 Integration with Sharepoint

© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
MORE INFORMATION….

You can find more information on Word, Excel,
PowerPoint and Outlook:
 Intranet
/ Finance & Administration / Informatica
 Interactive guide 2003-2010
 Quick Reference Card Outlook, Word, Excel and
PowerPoint
 Reference – location 2003 versus location 2010
 Guides EN / FR
 Frequently Asked Questions