Office 2002 (xp) new features - general

course description
this course is aimed at those you wish to gain a wider knowledge of office 2002. you will benefit fully from this course if you have been using previous versions of office.
target audience
confident users of office 97/2000 (word, excel and powerpoint)
after completing this course, participants will be able to:
make best use of the new features and functionality of the entire office suite thereby becoming more efficient and productive.

• excel 2002 (xp)
• use the new formula and function features effectively
• import data from web sites directly
• select from a host of new features those which will be most useful
• word 2002 (xp)
• use styles and formatting task panes to speed up formatting of long documents
• select those new features which will be most productive
• use the new reviewing functions to collaborate more effectively
• protect your documents using the improved and simplified security functions
• powerpoint 2002 (xp)
• transform presentations using the new animation schemes
• increase impact using multiple design templates
• protect your presentations from unauthorised changes and access
• create presentations quicker

prerequisites
to benefit fully from this overview, participants are expected to be proficient with the topics covered in the excel 97/2000, word 97/2000 and powerpoint 97/2000 foundation courses.

related courses

word 2000 / excel 2000 / powerpoint 2000 foundation

further use of word 2000 / excel 2000

word / excel power user (vba)

tailored training is available

common office xp improvements
topic

• task panes - office, search, office clipboard, new file task panes
• improved help - ask a question box
• smart tags - control paste options and automatic changes
• updated clip organizer
• conceptual diagrams
• find printers - automatic search for printers across a network
• document recovery and safer shutdown

microsoft excel
topic

• importing data - querying data from web pages
• formulas & functions - screentips, recommended functions, cut-and-paste function reference examples, watch window, expanded autosum functionality, formula evaluator, formula error checking
• worksheet and workbook formatting - , colour-coded worksheet tabs, smart tags, unmerge on the toolbar, retain column widths, new border drawing tool
• everyday tasks - new find and replace options, new edit links options, hyperlink navigation improved, email a selected range, insert and delete columns while filtering, speech playback, more header & footer functions, item properties in pivottables, open and save xml, improved worksheet protection

microsoft word
topic

• easier formatting - styles and formatting task pane, reveal formatting task pane, select all text with similar formatting, clear formatting from text, check formatting for consistency, autocorrect options buttons, paste options button
• collaborative document creation - improved reviewing toolbar, enhanced compare and merge, document review automation
• everyday tasks - improved table and list formatting, improved proofing tools, enhanced autocomplete, multi-selection, word count toolbar, simplified mail merge, hiding white space, drawing canvas, diagramming, improved watermarks, improved picture bullets
• security - new security tab, protecting personal information
• smart tags

microsoft powerpoint
topic

• animation effects and animation schemes - new animation effects, including entry and exit, motion paths, animation schemes task pane
• better organization charts & new diagram types - smaller files, organisation charts, radial, pyramid, venn, cycle and target diagrams
• everyday tasks - task panes for slide and presentation formatting, slide layout task pane, slide design task pane, print preview, multiple design templates per presentation, visible grid, navigate using thumbnails of slides in normal view, text autofit improvements, automatic layout for inserted objects, save background or selection as picture, easier selection of an object in a group, insert multiple pictures, picture compression, picture rotation, play sounds and animations in web presentations
• password protection
• proofing tools improvements