Office 2007 New Features

**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**

 

Description:     Students will learn about the Microsoft Office button, Ribbon tabs and Ribbon groups, galleries, contextual Ribbon tabs, Live Preview, the Dialog Box Launcher, the Document Information Panel, and the Mini toolbar. Students will also work with the XML file format and the macro and non-macro file formats. In addition, dedicated units for Word, Excel, PowerPoint, Outlook, and Access introduce the new features of each application.

 

Days:                1

 

Prerequisites:  Word 2003: Introduction, Excel 2003: Introduction, PowerPoint 2003: Introduction, Access 2003: Introduction, and Outlook 2003: Introduction, or equivalent experience.

 

 

Unit 1: The Office 2007 interface

 Topic A: The Office Button menu

·          Viewing Office Button commands

·          Changing the application options

 Topic B: The Ribbon

·          Using the Ribbon

·          Using contextual Ribbon tabs

·          Using Live Preview

·          Using the Dialog Box Launcher

·          Using the Document Information Panel

·          Finishing a document

 Topic C: The Mini toolbar

·          Using the Mini toolbar

·          Hiding the Mini toolbar

 Topic D: The Quick Access toolbar and the Status bar

·          Positioning the Quick Access toolbar

·          Adding a command to the Quick Access toolbar

·          Using the Customize settings

·          Using the Status bar

 Unit 2: The Office XML file format

 Topic A: The Office XML format

·          Discussing benefits of the Office XML format

 Topic B: Office XML format compatibility

·          Saving files to older Office formats

·          Comparing Office 2007 to Office 2003 file sizes

·          Using macro formats

·          Discussing converters for previous Office releases

 Unit 3: New Word features

 Topic A: Formatting

·          Formatting content by using the Styles gallery

·          Creating and formatting charts in Word

·          Adding and formatting a shape

·          Applying themes

 Topic B: Quick Parts and Building Blocks

·          Accessing Quick Parts

·          Using the Building Blocks Organizer

·          Adding custom Quick Parts

 Topic C: Shared documents

·          Discussing workflows

·          Comparing two versions of a document

·          Saving a file as a static document

 Unit 4: New Excel features

 Topic A: Larger worksheet size

·          Discussing worksheet size

 Topic B: Charts and reports

·          Creating a chart

·          Adding a chart title

·          Modifying the chart format

·          Changing the page layout and adding print titles

·          Adding a header

 Topic C: Table options

·          Creating and formatting a table

·          Working with Table AutoExpansion

·          Applying structured referencing

·          Creating and using table names

·          Creating functions with [#ThisRow]

 Topic D: PivotTables

·          Creating and formatting PivotTables

 Topic E: Excel Services

·          Discussing Excel Services for online sharing

 Unit 5: New PowerPoint features

 Topic A: Dynamic SmartArt graphics

·          Converting a bulleted list to SmartArt

·          Formatting diagrams

 Topic B: Slide libraries

·          Discussing SharePoint Server 2007

 Topic C: Sharing presentations

·          Saving as a static document

·          Discussing presentation review processes

·          Discussing digital signatures

 Topic D: Custom layouts

·          Creating custom slide layouts

·          Applying themes to a presentation

 Unit 6: New Outlook features

 Topic A: Content management tools

·          Using Instant Search

·          Organizing content by using Color Categories

·          Previewing an attachment

·          Subscribing to RSS feeds

 Topic B: The To-Do Bar

·          Flagging a message

·          Adding a new task to the To-Do Bar

 Topic C: Shared content

·          Discussing Internet calendar publishing

·          Creating calendar snapshots

·          Creating an electronic business card

·          Inserting and sending a business card

·          Discussing Exchange Server collaboration

 Unit 7: New Access features

 Topic A: Data features

·          Using the document window

·          Preparing to use the Lookup wizard

·          Creating a Lookup list field

·          Using the Attachment data type

·          Collecting data via e-mail

 Topic B: Reports

·          Using Layout view to modify reports

·          Sorting and filtering reports

·          Grouping report data

Feb 20, 2012
Mar 21, 2012
Apr 10, 2012
May 16, 2012
Jun 18, 2012
Jul 05, 2012
Aug 20, 2012
Sep 18, 2012
Oct 22, 2012
Dec 10, 2012



Price: $295



Or you can purchase our CW vBook training:Register with vbook