This one-day course covers those features of
Microsoft Office 2007 that are new to the Office system.
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.
Prerequisites: Word 2003: Basic, Excel 2003:
Basic, PowerPoint 2003: Basic, Access 2003: Basic, and
Outlook 2003: Basic, or equivalent experience
This course includes the following topics:
Unit 1 : The Office 2007 interface
Topic A:
The Office Button menu
A-1: Viewing Office Button
commands
A-2: Changing the application options
Topic B: The Ribbon
B-1: Using the Ribbon
B-2:
Using contextual Ribbon tabs
B-3: Using Live Preview
B-4: Using the Dialog Box Launcher
B-5: Using
the Document Information Panel
B-6: Finishing a
document
Topic C: The Mini toolbar
C-1: Using
the Mini toolbar
C-2: Hiding the Mini toolbar
Topic D: The Quick Access toolbar and the Status bar
D-1: Positioning the Quick Access toolbar
D-2:
Adding a command to the Quick Access toolbar
D-3:
Using the Customize settings
D-4: Using the Status
bar
Unit 2 : The Office XML file format
Topic A: The Office XML format
A-1: Discussing
benefits of the Office XML format
Topic B: Office
XML format compatibility
B-1: Saving files to older
Office formats
B-2: Comparing Office 2007 to Office
2003 file sizes
B-3: Using macro formats
B-4:
Discussing converters for previous Office releases
Unit 3 : New Word features
Topic A: Formatting
A-1: Formatting content by using the Styles gallery
A-2: Creating and formatting charts in Word
A-3:
Adding and formatting a shape
A-4: Applying themes
Topic B: Quick Parts and Building Blocks
B-1:
Accessing Quick Parts
B-2: Using the Building Blocks
Organizer
B-3: Adding custom Quick Parts
Topic
C: Shared documents
C-1: Discussing workflows
C-2: Comparing two versions of a document
C-3:
Saving a file as a static document
Unit 4 : New
Excel features
Topic A: Larger worksheet size
A-1: Discussing worksheet size
Topic B: Charts and
reports
B-1: Creating a chart
B-2: Adding a
chart title
B-3: Modifying the chart format
B-4:
Changing the page layout and adding print titles
B-5: Adding a header
Topic C: Table options
C-1:
Creating and formatting a table
C-2: Working with
Table AutoExpansion
C-3: Applying structured
referencing
C-4: Creating and using table names
C-5: Creating functions with [#ThisRow]
Topic D: 0
PivotTables
D-1: Creating and formatting PivotTables
Topic E: Excel Services
E-1: Discussing Excel
Services for online sharing
Unit 5 : New
PowerPoint features
Topic A: Dynamic SmartArt
graphics
A-1: Converting a bulleted list to SmartArt
A-2: Formatting diagrams
Topic B: Slide
libraries
B-1: Discussing SharePoint Server 2007
Topic C: Sharing presentations
C-1: Saving as a
static document
C-2: Discussing presentation review
processes
C-3: Discussing digital signatures
Topic D: Custom layouts
D-1: Creating custom slide
layouts
D-2: Applying themes to a presentation
Unit 6 : New Outlook features
Topic A: Content
management tools
A-1: Using Instant Search
A-2:
Organising content by using Color Categories
A-3:
Previewing an attachment
A-4: Subscribing to RSS
feeds
Topic B: The To-Do Bar
B-1: Flagging a
message
B-2: Adding a new task to the To-Do Bar
Topic C: Shared content
C-1: Discussing Internet
calendar publishing
C-2: Creating calendar snapshots
C-3: Creating an electronic business card
C-4:
Inserting and sending a business card
C-5:
Discussing Exchange Server collaboration
Unit 7
: New Access features
Topic A: Data features
A-1: Using the document window
A-2: Preparing to use
the Lookup wizard
A-3: Creating a Lookup list field
A-4: Using the Attachment data type
A-5:
Collecting data via e-mail
Topic B: Reports
B-1:
Using Layout view to modify reports
B-2: Sorting and
filtering reports
B-3: Grouping report data
