BASIC OFFICE 2007 TRAINING OUTLINE

Chapter 1: GETTING STARTED WITH WORD (33 min)

1. Touring the New Office 2007 Interface
2. Formatting Basic Text
3. Applying Formatting to a Paragraph
4. Creating Bulleted & Numbered Lists
5. Working with Styles
6. Making Changes to the Styles
7. Saving & Removing Formatting
8. Changing Style Sets
9. Proofing Your Work

Chapter 2: REFINING WORD® DOCUMENTS (45 min)
1. Adding Headers & Footers
2. Inserting Watermarks
3. Formatting the Overall Document
4. Inserting Graphical Elements
5. Inserting Clip Art
6. Using SmartArt
7. Inserting Tables
8. Formatting Tables
9. Creating a Cover Page with Themes
10. Saving a Document
11. Outputting to PDF

Chapter 3: EXPLORING EXCEL® (77 min)
1. Touring the Excel Interface
2. Inserting, Moving & Selecting Content
3. Format Numerical Data & Reference Cells
4. Building a Table & Using AutoFill
5. Inserting & Deleting Rows & Columns
6. Introducing Formulas
7. Introducing Functions
8. Using the Insert Function Dialog Box
9. Using Statistical Functions & the Status Bar
10. Using Auditing Commands
11. Exploring Absolute Cell Referencing
12. Naming Cell Ranges & Using Name Manager
13. Pasting Data & Using the Clipboard

Chapter 4: FORMATTING & STYLIZING IN EXCEL® (68 min)
1. Formatting Cells
2. Using Format Painter
3. Number Formatting
4. Using Cell Styles
5. Creating Cell Styles
6. Changing Styles
7. Using & Creating Table Styles
8. Filtering a Table Layout
9. Using Conditional Formatting
10. Formatting Worksheets with Themes
11. Inserting Graphical Elements
12. Managing Multiple Worksheets
13. Outputting a Document
14. Saving a Document

Chapter 5: POWERING UP WITH POWERPOINT® (60 min)
1. Touring the PowerPoint Interface
2. Formatting Text
3. Changing the Slide Layout
4. Adding Additional Slides
5. Creating a Slide Design
6. Customizing Slides
7. Inserting Objects
8. Using SmartArt
9. Creating & Formatting Charts
10. Using WordArt Styles
11. Changing Chart Types
12. Applying Themes
13. Setting Animation Effects
14. Working with Different Views
15. Setting Up a Slide Show
16. Running a Slide Show
17. Outputting a Presentation

Chapter 6: STAYING CONNECTED IN OUTLOOK® (25 min)
1. Touring the Outlook Interface
2. Using E-mail
3. Creating Signatures & New Folders
4. Using a Calendar & Adding Events
5. Working with Multiple Calendars
6. Sharing Calendars
7. Adding & Viewing Contacts
8. Creating, Viewing & Flagging Tasks

Advanced Office 2007 Training Outline

Course Content

Lesson 1: Getting Started with Microsoft® Office 2007
Topic 1A: Explore the User Interface
Topic 1B: Enhance Files
Topic 1C: Save Files

Lesson 2: Creating Professional-Looking Documents
Topic 2A: Apply a Cover Page
Topic 2B: Add Building Blocks
Topic 2C: Compare Reviewed Documents

Lesson 3: Enhancing Your Spreadsheets
Topic 3A: Organize Data
Topic 3B: Apply Conditional Formatting
Topic 3C: Apply a Formula
Topic 3D: Present Data

Lesson 4: Creating Dynamic Presentations
Topic 4A: Create Custom Slide Layouts
Topic 4B: Enhance Presentations with Graphic Effects
Topic 4C: Customize Slide Shows

Lesson 5: Working with Access 2007
Topic 5A: Create a Table
Topic 5B: Design a Form Layout
Topic 5C: Query a Database
Topic 5D: Generate Reports
Topic 5E: Work with External Data

Lesson 6: Working with Outlook 2007
Topic 6A: Locate Information Quickly
Topic 6B: Share Your Calendar Information
Topic 6C: Notify Others that You Will be Out Of Office
Topic 6D: Share Information Using Electronic Business Card
Topic 6E: Integrate Outlook with SharePoint Services
Topic 6F: Add RSS Feeds Through Outlook 2007

Lesson 7: Finalizing Files
Topic 7A: Protect Files
Topic 7B: Share Files