Microsoft Office 2007 On Demand

( 1 )

Overview

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 ...

See more details below
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (4) from $35.37   
  • Used (16) from $1.99   
Microsoft Office 2007 On Demand

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$13.49
BN.com price
(Save 43%)$23.99 List Price

Overview

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

Read More Show Less

Product Details

  • ISBN-13: 9780789736406
  • Publisher: Que
  • Publication date: 1/1/2007
  • Series: On Demand Series
  • Pages: 728
  • Sales rank: 1,122,950
  • 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.

Workshop

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.

Read More Show Less

Table of Contents

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

Read More Show Less

Preface

Introduction

How 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 .

Workshop

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.

Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted May 13, 2009

    Microsoft Office 2007 on Demand is well thought out, and is an ideal tool for beginning and intermeriate Office users, as well as those advanced users that want to become familiar with the new features and functionality of this version of Office.

    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.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)