Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Microsoft Office 2007 On Demand
  • Alternative view 1 of Microsoft Office 2007 On Demand
  • Alternative view 2 of Microsoft Office 2007 On Demand

Microsoft Office 2007 On Demand

4.0 1
by Steve Johnson, Inc. Perspection, Perspection, Inc. Staff

See All Formats & Editions

How to Use

• Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface

• Word: Create great-looking documents faster using themes, styles, and templates

• Excel: Use organizing, processing, and presenting tools to create data in Excel


How to Use

• Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface

• Word: Create great-looking documents faster using themes, styles, and templates

• Excel: Use organizing, processing, and presenting tools to create data in Excel

• PowerPoint: Create powerful presentations faster using ready-made design templates and themes

• Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks

• Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer

• SharePoint: Collaborate and share documents and information

• Prepare for the Microsoft Certified Application Specialist exam

• Practice your new skills with the useful workshops inside

On the Web

This book uses real-world examples to give you a context in which to use a task. This book also includes workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com

Perspection has written and produced books on a variety of computer software—including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks—and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.

Includes MCAS Exam Objectives!

This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.

Chapter 1 Getting Started with Office 1

Chapter 2 Using Shared Office Tools 33

Chapter 3 Adding Art to Office Documents 57

Chapter 4 Adding Shapes to Office Documents 93

Chapter 5 Formatting Office Documents 115

Chapter 6 Creating a Document with Word 131

Chapter 7 Formatting a Document with Word 153

Chapter 8 Enhancing a Document with Word 173

Chapter 9 Creating a Worksheet with Excel 211

Chapter 10 Building a Worksheet with Excel 239

Chapter 11 Designing a Worksheet with Excel 281

Chapter 12 Creating a Presentation with PowerPoint 305

Chapter 13 Delivering a Presentation with PowerPoint 343

Chapter 14 Creating a Database with Access 375

Chapter 15 Locating and Managing Data with Access 405

Chapter 16 Presenting Data with Access 423

Chapter 17 Communication with Outlook 447

Chapter 18 Managing Information with Outlook 489

Chapter 19 Creating a Publication with Publisher 519

Chapter 20 Designing a Publication with Publisher 537

Chapter 21 Publishing Office Documents on the Web 557

Chapter 22 Protecting and Securing Office Documents 575

Chapter 23 Reviewing and Sharing Office Documents 605

Chapter 24 Expanding Office Functionality 647

New Features 673

Microsoft Certified Applications Specialist 683

Product Details

Publication date:
On Demand Series
Product dimensions:
7.52(w) x 9.50(h) x 1.23(d)

Read an Excerpt

IntroductionIntroductionHow You'll Learn

  • How This Book Works
  • What's New
  • Keyboard Shortcuts
  • Step-by-Step Instructions
  • Real World Examples
  • Workshop
  • Microsoft Certified Applications Specialist
  • Get More on the Web

Welcome to Microsoft Office 2007 On Demand, a visual quick reference book that shows you how to work efficiently with Microsoft Office. This book provides complete coverage of basic to advanced Office skills.

How This Book Works

You don't have to read this book in any particular order. We've designed the book so that you can jump in, get the information you need, and jump out. However, the book does follow a logical progression from simple tasks to more complex ones. Each task is presented on no more than two facing pages, which lets you focus on a single task without having to turn the page. To find the information that you need, just look up the task in the table of contents or index, and turn to the page listed. Read the task introduction, follow the step-by-step instructions in the left column along with screen illustrations in the right column, and you're done.

What's New

If you're searching for what's new in Office 2007, just look for the icon: New!. The new icon appears in the table of contents and through out this book so you can quickly and easily identify a new or improved feature in Office 2007. A complete description of each new feature appears in the New Features guide in the back of this book.

Keyboard Shortcuts

Most menu commands have a keyboard equivalent, such as Ctrl+P, as a quicker alternative to using the mouse. A complete list of keyboard shortcuts is available on the Web at http://www.perspection.com.

Step-by-Step Instructions

This book provides concise step-by-step instructions that show you "how" to accomplish a task. Each set of instructions include illustrations that directly correspond to the easy-to-read steps. Also included in the text are timesavers, tables, and sidebars to help you work more efficiently or to teach you more in-depth information. A "Did You Know?" provides tips and techniques to help you work smarter, while a "See Also" leads you to other parts of the book containing related information about the task.

Real World Examples

This book uses real world examples files to give you a context in which to use the task. By using the example files, you won't waste time looking for or creating sample files. You get a start file and a result file, so you can compare your work. Not every topic needs an example file, such as changing options, so we provide a complete list of the example files used through out the book. The example files that you need for project tasks along with a complete file list are available on the Web at http://www.perspection.com.


This book shows you how to put together the individual step-by-step tasks into indepth projects with the Workshop. You start each project with a sample file, work through the steps, and then compare your results with project results file at the end. The Workshop projects and associated files are available on the Web at http://www.perspection.com.

Microsoft Certified Applications Specialist

This book prepares you for the Microsoft Certified Applications Specialist (MCAS) exam for Microsoft Office 2007 programs. Each MCAS certification exam has a set of objectives, which are organized into broader skill sets. To prepare for the certification exam, you should review and perform each task identified with a MCAS objective to confirm that you can meet the requirements for the exam. Throughout this book, content that pertains to an objective is identified with the following MCAS logo and objective number next to it.

Get More on the Web

In addition to the information in this book, you can also get more information on the Web to help you get up to speed faster with Office 2007. Some of the information includes:

Transition Helpers

  • Only New Features. Download and print the new feature tasks as a quick and easy guide.
Productivity Tools
  • Keyboard Shortcuts. Download a list of keyboard shortcuts to learn faster ways to get the job done.
More Content
  • Photographs. Download photographs and other graphics to use in your Office documents.
  • More Content. Download new content developed after publication. For example, you can download a complete chapter on Office SharePoint Server 2007 and Office Groove 2007.

You can access these additional resources on the Web at http://www.perspection.com.

© Copyright Pearson Education. All rights reserved.

Meet the Author

Steve Johnson has written more than 35 books on a variety of computer software, including Microsoft Office 2007 and 2003, Microsoft Windows XP, Apple Mac OS X Panther, Macromedia Flash MX 2004 and 8, Macromedia Director MX 2004, Macromedia Fireworks, and Adobe Photoshop CS and CS2. In 1991, after working for Apple Computer and Microsoft, Steve founded Perspection, Inc., which writes and produces software training. When he is not staying up late writing, he enjoys playing golf, gardening, and spending time with his wife, Holly, and three children, JP, Brett, and Hannah. When time permits, he likes to travel to such places as New Hampshire in October, and Hawaii. Steve and his family live in Pleasanton, California, but can also be found visiting family all over the western United States.

Customer Reviews

Average Review:

Post to your social network


Most Helpful Customer Reviews

See all customer reviews

Microsoft Office 2007 On Demand 4 out of 5 based on 0 ratings. 1 reviews.
MarkSil More than 1 year ago
I am a long term user of Microsoft Office, going back at least 3 versions. I consider my self an advanced user of many features and a more intermediate user of other features that are not needed on any regular basis in my job as a software development project manager. Office 2007 on Demand is a very visual book which steps you through the current version of Office in a very logical fashion. While it has separate sections for Word, Excel, Powerpoint, Outlook, Access and Publisher, it also has a number of chapters on features, functions and usability that are common to the entire package. For new or intermediate users of previous versions, I believe this an ideal way to quickly get up and running with the 2007 version. It breaks features and functions down into logical, manaageable pieces, and presents them with clear examples and illustratons. There is ample use of white space on the pages so that the novice or intermediate user is not overwhelmed with the feeling they're being forced to read a reference manual. For power users the book is less useful since it doesn't go into a lot of depth on many advanced features such as the use of macros and Visual Basic for Applications. However, For advanced users of previous versions, this book will aid the transition to the ribbon interface and the new features. While there are a number of new features in Office 2007, the older features are still there, and most of them still use dialog boxes that are similar or identical to previous versions. The key is finding these features, I found that this book made the transition to the very logical ribbon interface fairly painless. Many have opted to avoid Office 2007 specifically because of the ribbon interface and the lack of a menus to help with the transition. Once you take the time to understand the new design, through the use of a book like this, I think you'll find the Office 2007 ribbon interface grouping is more logical and more usable than the menu driven versions. I found this book to be a great help making the transition, and even more valuable to my wife and son who are intermediate users.