Office Upgrade Training from 2003 to 2007 (All Users)

Office 2007 has a radically new user interface compared with either Office 97/2000 or XP/2003:

• The ‘ribbon’ replaces most menu and toolbar functions in Word, Excel, PowerPoint and Access as well as some parts of Outlook.
• Real-time’ previewing of changes in formatting, prior to application to the current document.
• Documents can now be saved in .pdf format.
• New Graphics engine.
• SmartArt is a new feature designed to create professional-looking diagrams.
• Document Themes allow a consistent use of fonts, formatting, etc across all documents created win Word, Excel and PowerPoint.
• Simplified working with multiple applications, e.g. Excel chart embedded in a Word document.

None

The new Interface – Office 2007

• The Ribbon
• Tabs
• Command Groups
• Dialog box Launcher
• Quick Access Toolbar
• Status bar – including Views, Zoom, customising
• Office Button
  
  • Creating a new file
  • The Office 2007 file formats
  • Open files
  • Saving files to ERM
  • Saving as PDF
  • Saving for earlier version
  • Converting files to Office 2007
  • Printing
  • Preparing for print

• Document properties
• Marking documents as final
• Compatibility checker
  
  • Sending as e-mail
  • The Options button

• Mini-toolbar
• Live Preview
• Tool tips

New Features - Word

• Styles and Quick Styles
• Cover page gallery
• Automatic Word count
• Contextual spell checker
• Quick Parts and Building Blocks
• Using Tables Quick Styles
• Document comparison, review and merging

New Features -Excel

• New worksheet size and capabilities
• Formula Autocomplete
• Formatting from Home Ribbon
• New features in Conditional Formatting
• Improved Sorting and Filtering
• Page Layout view
• Charts and reports from existing worksheets
• New Table options
• Pivot Tables
• Name Manager
• SUMIFS, etc.

New Features - Outlook

• The Navigation Pane
• Changing look of reading pane
• Instant Search
• Search Folders
• Colour Categories
• Preview Attachments
• The To Do Bar
• Additional Flag facilities
• Formatting e-mails
• The Create e-mail tabs
• Task Integration
• Calendar views and scheduling
• Calendar snapshots
• RSS Feeds

New features - PowerPoint

• Additional formatting options
• Changing the direction of text
• Indenting text
• Font command group
• Aligning text
• Text in columns
• Quick Styles
• Themes
• Enhanced tables and pasting tables from Excel
• Custom slide layouts – Slide Layout Gallery
• Slide Master Layouts
• Smart Art Graphics
• Converting bulleted lists to Smart Art
• New Effects in animations and transitions
• Presenter View
• Reuse Slides task pane

New features -Access

• Creating a blank database
• Navigation pane, including customisation
• Access Options
• New features in tables
  
  • Adding a field from another template
  • Creating a new field using the field template
  • Creating a table using a template
  • Creating a table using a SharePoint list
  • Performing calculations using the Totals row
  • Date picker

• New features in form
  
  • Creating a form using the Report Wizard
  • Creating a split form

• New features in reports
  
  • Creating a group or sort
  • Modifying groups or sorts
  • Adding a calculated function

• Aligning controls in forms and reports
   (New Users)

This course is available as an inhouse course tailored to your organisational aims and objectives, please contact us to discuss your requirements and delegate numbers. (pricing can vary dependant on the size of group)

All prices are excluding VAT, travel is charged with In-house courses at 40p per mile from our head office
Accommodation is required for distances over 100 miles from our head office.