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




Smart Art
Photo/Video editing tools










Properties
Inspect & Encrypt
Save to web & save to Sharepoint
Recovery features


Screenshots
Image Background Removal tool
Adjustments
Styles
Prepare (2007) – Backstage (2010)


Emailing
Saving as PDF
Versions
Language selection for interface, help
Proofing tools
Document inspector
Permissions (2010)




Mark as final
Password
Access to IRM – Information Rights Management
Digital Signature
© - 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
© - Danny Puype – Trainer/Developer
INTERFACE
Inserting a Sheet
 Page Layout View
 Changes to Pivot Tables Environment
 Formula Auto Complete
 Resizing the Formula Bar
 Changes to Charts Environment

 Charts:
double click (Excel 2010)
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)




Conditional Formatting Rules Manager
Multiple rules and functionality
More features (Excel 2010)
Increased functionality
Table headers (Excel 2010)
Structured References in Excel Tables
Charts & charting



Interface and functionality
Selection pane
Sparklines (Excel 2010)
© - Danny Puype – Trainer/Developer
20/07/2015
FEATURES (2)

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
© - Danny Puype – Trainer/Developer
FORMATTING



Themes
Smart art (2007 – 2010)
Tables



Text



Table styles
Contextual ribbons
Text effects (2010)
Open type typography (2010) (Calibri, Cambria, Constantia, and Corbel - Consolas, and Gabriola :Windows 7 only)
Images and graphics








Artistic effects (2010)
Pictures styles
Picture effects (2010)
Adjustments (2010)
Picture layouts (2010)
Screenshots (2010)
Background removal (2010)
Selection pane
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










Controlling the Navigation Pane
Previewing an Attachment
Viewing Next/Previous Message in a Single Email
Simplified Steps for Sharing Calendar, Contacts, Tasks,
Notes
Changing Detail Level in Month View
Viewing To-Do Items in the Calendar
Overlaying Multiple Calendars
Showing Full or Work Week
The To-Do Bar
Using the Out of Office Assistant
20/07/2015
FORMATTING

Categories
 Color-Coded
Categories
 Roaming
 Assigning
Items to Categories
© - Danny Puype – Trainer/Developer
20/07/2015
© - Danny Puype – Trainer/Developer
FEATURES










Using Instant Search - Using Search Queries
Adding an Electronic Business Card to an Email
Flags
RSS support
Voice mail and faxes to inbox
Restricting Access to Free/Busy Information
Scheduling Assistant
Sending a Calendar Snapshot by Email
Meeting Change Notifications
Publishing Your Calendar to Office Online

Sharing a Published Calendar
20/07/2015
TECHNICALLY
Sharepoint lists
 Auto Account setup
 Infopath integration
 Improved data caching

© - Danny Puype – Trainer/Developer
20/07/2015
2010
Conversation view
 MailTips
 Social connector
 Quick steps
 Cleanup

© - Danny Puype – Trainer/Developer
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