HelpFeedback
PAS
Information Center
Feature Summary
Table of Contents
Word Sample Chapter
Excel Sample Chapter


Student Edition
Instructor Edition
Microsoft Office 2007: Professional Approach Series / 0073373516

Deborah Hinkle, Microsoft Word, ISBN: 0073519197
Kathleen Stewart, Microsoft Excel, ISBN:0073519219
John Carter & Jon Juarez, Microsoft Access, ISBN:0073519200
Pat Graves & Amie Mayhall, Microsoft PowerPoint, ISBN:0073519189
David Nickles & M.B. Ogawa, Microsoft Outlook, ISBN:0073373508

ISBN: 0073519197
Copyright year: 2008

Table of Contents



* The contents shaded in yellow indicate lessons included in The Professional Approach Series Microsoft Office 2007 book.
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/482073/word.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (19.0K)</a>

Microsoft Office Word 2007

Unit 1 - Basic Skills
Lesson 01 - Creating a Document
Lesson 02 - Selecting and Editing Text
Lesson 03 - Formatting Characters
Lesson 04 - Writing Tools

Unit 2 - Paragraph Formatting, tabs, and Advanced Editing
Lesson 05 - Formatting Paragraphs
Lesson 06 - Tabs and Tabbed Columns
Lesson 07 - Moving and Copying Text
Lesson 08 - Find and Replace

Unit 3 - Page Formatting
Lesson 09 - Margins and Printing Options
Lesson 10 - Page and Section Breaks
Lesson 11 - Page Numbers, Headers, and Footers
Lesson 12 - Styles
Lesson 13 - Templates and Wizards
Unit 4 - Tables and Columns
Lesson 14 - Tables
Lesson 15 - Advanced Tables
Lesson 16 - Columns

Unit 5 - Graphics and Charts
Lesson 17 - Graphics
Lesson 18 - Text Boxes and Desktop Publishing
Lesson 19 - SmartArt and Charts

Unit 6 - Advanced Topics
Lesson 20 - Mail Merge
Lesson 21 - Fields
Lesson 22 - Macros

Unit 7 - long Documents and Document Sharing
Lesson 23 - Footnotes and Endnotes
Lesson 24 - Outlines, Indexes, and Tables of Contents
Lesson 25 - Sharing Your Work and Hyperlinks

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/482073/excel.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (17.0K)</a>

Microsoft Office Excel 2007

Unit 1 - introduction to Excel
Lesson 01 - Getting Started with Excel
Lesson 02 - Creating a Workbook
Lesson 03 - Using Editing and Style Tools
Lesson 04 - Exploring Home Tab Commands

Unit 2 - Working with Formulas and Functions
Lesson 05 - Exploring Formulas Basics
Lesson 06 - Working with Functions
Lesson 07 - Using Logical and Financial Functions
Lesson 08 - Rounding and Nesting Functions

Unit 3 - Enhancing Worksheet Appearance
Lesson 09 - Building Charts
Lesson 10 - Inserting Shapes
Lesson 11 - Using Images and SmartArt Graphics
Unit 4 - Expanding Uses of Workbook Data
Lesson 12 - Using 3-D References
Lesson 13 - Working with Tables
Lesson 14 - Using Named Ranges and Structured References

Unit 5 - Auditing, Analyzing, and Consolidating Data
Lesson 15 - Using Auditing Tools
Lesson 16 - Using What-If Analysis
Lesson 17 - Consolidating and Linking Workbooks

Unit 6 - Exploring Data and Table Features
Lesson 18 - Using External Data Sources
Lesson 19 - Exploring List Ranges
Lesson 20 - Using Data Tables and PivotTables

Unit 7 - Exploring Macros, Templates, and Workgroups
Lesson 21 - Working with Macros
Lesson 22 - Using Templates
Lesson 23 - Using Workgroup Features

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/482073/powerpoint.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (16.0K)</a>

Microsoft Office PowerPoint 2007

Unit 1 - Basic Skills
Lesson 01 - Getting Started In PowerPoint
Lesson 02 - Developing Presentation Text
Lesson 03 - Revising Presentation Text

Unit 2 - Presentation Illustration
Lesson 04 - Working with Graphics
Lesson 05 - Creating Tables
Lesson 06 - Creating Charts
Lesson 07 - Creating Diagrams with SmartArt Graphics

Unit 3 - Visual Impact
Lesson 08 - Designing Original Illustrations
Lesson 09 - Refining Original Illustrations
Lesson 10 - Animating and Using Multimedia Effects
Lesson 11 - Customizing Themes and Master Slides

Unit 4 - Development and Distribution
Lesson 12 - Integrating with Other Programs
Lesson 13 - Preparing a Presentation for Delivery
Lesson 14 - Preparing for Electronic Distribution

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/482073/access.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (22.0K)</a>

Microsoft Office Access 2007

Unit 1 - Understanding Access Databases
Lesson 01 - Getting Started with a Database
Lesson 02 - Viewing and Modifying Records
Lesson 03 - Finding, Filtering, Sorting, and Summarizing Data
Lesson 04 - Creating New Databases and Tables

Unit 2 - Designing and Managing Database Objects
Lesson 05 - Managing Data Integrity
Lesson 06 - Designing Queries
Lesson 07 - Adding and Modifying Forms
Lesson 08 - Adding and Modifying Reports

Unit 3 - Integrating Database Objects
Lesson 09 - Building Links, Relationships, and Indexes
Lesson 10 - Designing Advanced Queries
Lesson 11 - Building Advanced Forms
Lesson 12 - Building Advanced Reports

Unit 4 - Using Advanced Features
Lesson 13 - Advanced Database Features
Lesson 14 - Using Special Controls and Tools
Lesson 15 - Working with Macros and Modules

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/482073/outlook200.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (19.0K)</a>

Microsoft Office Outlook 2007

Unit 1 – Outlook Basics
Lesson 1 – Introduction to Outlook and E-mail
Lesson 2 – Contact Management

Unit 2 – Managing Your Schedule and Tasks
Lesson 3 – Managing Scheduling
Lesson 4 – Task Management

Unit 3 – Advanced Topics
Lesson 5 – Managing E-mail Efficiently
Lesson 6 – Categorizing and Managing Outlook
Professional Approach Series Office 2007

To obtain an instructor login for this Online Learning Center, ask your local sales representative. If you're an instructor thinking about adopting this textbook, request a free copy for review.