Sams Teach Yourself Microsoft Office 2007 All in One [NOOK Book]

Overview

One Book…All the Answers

In just a short time you will be up and running with Microsoft Office 2007, including Word, Excel, PowerPoint, Outlook, and OneNote.

Using a straightforward, step-by-step approach, each lesson builds upon a real-world foundation, allowing you to learn the essentials of Office 2007 from the ground up.

Thorough instructions walk you through the most ...

See more details below
Sams Teach Yourself Microsoft Office 2007 All in One

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)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

One Book…All the Answers

In just a short time you will be up and running with Microsoft Office 2007, including Word, Excel, PowerPoint, Outlook, and OneNote.

Using a straightforward, step-by-step approach, each lesson builds upon a real-world foundation, allowing you to learn the essentials of Office 2007 from the ground up.

Thorough instructions walk you through the most common tasks and show you extra features that make your Office 2007 documents stand apart from the crowd.

Notes present interesting pieces of information, extra features you can use, and warnings to protect your data.

Tips offer extra advice or teach an easier way to do something.

Learn how to…

  • Leverage New Features to Do More Work in Less Time
  • Master Office 2007’s New Ribbon
  • Use Live Preview to See How Changes Will Affect Your Documents
  • Create Online Web Pages from Your Office Documents, Worksheets, and Presentations
  • Apply a Consistent Theme to All Your Documents, Worksheets, and Presentations
  • Format Word Documents to Grab Attention Without Taking Away from the Message You Want to Convey
  • Perform Mail Merging with Ease
  • Set Up Powerful Worksheet Page Formats
  • Drop Audio and Video into Your PowerPoint Presentations
  • Organize Your Email to Work Smarter
  • Locate Outlook Contacts on a Global Map
  • Maximize Note Taking with OneNote

Part I: Introducing Microsoft Office 2007 1

Chapter 1: Start Here 3

PART II: Writing with Word 29

Chapter 2: Learning Word’s Basics 31

Chapter 3: Making Your Words Look Good 69

Chapter 4: Adding Lists, Tables, and Graphics 107

Chapter 5: Using Word’s Advanced Features 147

PART III: Working with Excel Worksheets 201

Chapter 6: Getting to Know Excel 203

Chapter 7: Working with Excel Data 243

Chapter 8: Formatting Worksheets with Excel 273

Chapter 9: Creating Advanced Worksheets 303

Chapter 10: Using Excel as a Simple Database 329

PART IV: Impressing Audiences with PowerPoint 347

Chapter 11: Learning About PowerPoint 349

Chapter 12: Adding Flair to Your Presentations 371

Chapter 13: Making More Impressive Presentations 393

PART V: Organizing with Outlook 429

Chapter 14: Introducing Outlook 431

Chapter 15: Making Contact 475

Chapter 16: Living with Outlook 497

PART VI: Enhancing Your Work with Other Office Features 517

Chapter 17: Making Notes with OneNote 519

Chapter 18: Automatic Office 541

Chapter 19: Sharing Data Among Office Applications 563

Chapter 20: Combining Office and the Internet 581

Read More Show Less

Product Details

  • ISBN-13: 9780132714426
  • Publisher: Pearson Education
  • Publication date: 11/23/2002
  • Series: Sams Teach Yourself Series
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 768
  • File size: 20 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Greg Perry has been a leader in computer education for twenty years, having taught at the college level and written enough books and articles to be called “the most proficient computer author on earth.” In addition to writing about computers, he speaks, consults, and writes about other topics, including real estate and the government. He and his wife Jayne now offer unique training and insights for new and advanced eBay users and run an eBay consignment business out of their rural, countryside home.

Read More Show Less

Table of Contents

Part I: Introducing Microsoft Office 2007 1

Chapter 1: Start Here 3

PART II: Writing with Word 29

Chapter 2: Learning Word’s Basics 31

Chapter 3: Making Your Words Look Good 69

Chapter 4: Adding Lists, Tables, and Graphics 107

Chapter 5: Using Word’s Advanced Features 147

PART III: Working with Excel Worksheets 201

Chapter 6: Getting to Know Excel 203

Chapter 7: Working with Excel Data 243

Chapter 8: Formatting Worksheets with Excel 273

Chapter 9: Creating Advanced Worksheets 303

Chapter 10: Using Excel as a Simple Database 329

PART IV: Impressing Audiences with PowerPoint 347

Chapter 11: Learning About PowerPoint 349

Chapter 12: Adding Flair to Your Presentations 371

Chapter 13: Making More Impressive Presentations 393

PART V: Organizing with Outlook 429

Chapter 14: Introducing Outlook 431

Chapter 15: Making Contact 475

Chapter 16: Living with Outlook 497

PART VI: Enhancing Your Work with Other Office Features 517

Chapter 17: Making Notes with OneNote 519

Chapter 18: Automatic Office 541

Chapter 19: Sharing Data Among Office Applications 563

Chapter 20: Combining Office and the Internet 581

Read More Show Less

Preface

Introduction

Microsoft Corporation's Office products have an installed base of more than 25 million licensed users. More than 90% of the Fortune 500 companies use Microsoft Office. Microsoft completely redesigned the Office interface when it produced Office 2007. Microsoft's goal was to make the Office 2007 interface easier than ever to use, as well as more integrated among other applications and the Internet.

By redesigning the interface, Microsoft in effect did away with menus and toolbars and replaced the interface with an ever-changing ribbon across the top of the Office product screens. To many Office old-timers, the ribbon was a bold move—Microsoft did away with the interface we've been using for what seems like forever. At first, the ribbon might frustrate you. You'll find yourself wondering, "Where's that option I need?" If you look up at the ribbon, you'll probably find it! The ribbon changes depending on what you're doing at the time. If you need a feature that you used to have to hunt through menus to locate, you'll probably find it on the ribbon. Office pros are happily finding that after a session or two with Office 2007, they wonder how they ever worked efficiently with the clunky menus and toolbars that used to be there.

Brand-new Office users may not ever know how well they have it with the new interface. The ribbon makes it far simpler to master Office than the menu system did. In addition, the graphical features of Office 2007, especially when used with a Windows Vista–compatible computer with Aero graphics capabilities, make learning Office 2007 a pleasure—and a quick pleasure at that.

You probably are anxious to get started with Office 2007. Take just a few preliminary moments to acquaint yourself with the design of this book, as described in the next few sections.

Who Should Read This Book?

This book is for both beginning and advanced Office 2007 users. Readers rarely believe that lofty claim, for good reason, but the design of this book and the nature of Office 2007 make it possible for this book to address that wide of an audience. The reason is simple: The book you hold in your hands approaches Office 2007 the way that most users approach Office 2007 in that a task needs to be done and this book shows you how to do it. All major and most minor Office 2007 features are not taught from a theoretical viewpoint; you don't read paragraph after paragraph of background before learning how something works. Instead, you see how something works in a step-by-step lesson. For example, if you want to create an Excel graph, you'll jump to the task in this book that walks you through the creation of an Excel graph. Why bother with a background of color palettes when you need a simple pie chart?

Readers unfamiliar with Windows–based environments will find plenty of introductory help here that brings them quickly up to speed. This book shows you how to do work in Office 2007, as well as how to manage many of the Internet-based Office 2007 elements that you need in order to use Office 2007 in today's online, connected world. If you are new to the Internet, this book helps you get started and shows you how to combine the Internet with Office 2007 to gain synergy from both.

Quite simply, this book talks to newcomers without talking down to them.

This book also brings those who presently use a Microsoft Office product up to speed with Office 2007. You face a mighty dramatic interface change, as the preceding section explained. With the fundamental Office understanding you already have, you will appreciate the new features and added power of Office 2007, and you'll learn how to maximize your use of the Office 2007 ribbon to get your work done quickly and easily.

What This Book Does for You

Although this book is not a complicated reference book, you'll learn almost every aspect of Office 2007 from a task-based, typical user's point of view. Office 2007 includes many advanced technical details that most users never need, and this book does not waste your time with those. You want to get up to speed with Office 2007 now, and this book helps you fulfill that goal.

Those of you who are tired of the mass of quick-fix computer titles cluttering today's shelves will find a welcome reprieve here. This book presents both the background and descriptions that a new Office 2007 user needs without burdening you with a lot of theory. This book is practical and provides a plethora of step-by-step task walk-throughs that you can follow when you need a feature that a task demonstrates while ignoring the tasks you don't need at the time.

This is truly a hands-on book for any Office 2007 user, from novice to pro. These tasks guide you through all the common Office 2007 actions you need to perform to make Office 2007 work for you.

Conventions Used in This Book

Given that this book is task-based, almost everything shown to you is performed in a step-by-step task. When you read a task, you'll learn about other tasks that you should understand first. For example, before learning how to add text to a PowerPoint slide, you need to know how to insert a slide into a new PowerPoint presentation. The cross-reference for that preliminary task is right there for you to review.

Other tasks form a basis or a foundation for subsequent tasks in the book. For example, when you follow the task that shows you how to format Excel cells, the task also lists other tasks that might be beneficial to you after you complete the cell-formatting task.

These cross-references among the tasks form web page–like links to the other tasks so that you're sure to get a rounded walk-through of whatever you want to do. Most hands-on tasks include a "Before You Begin" and "See Also" cross-reference section like this one:

Before you Begin

See Also

Enter Data into a Worksheet

Set Up Page Formatting

Conditionally Format Data

About Excel Styles, Themes, and Templates

In addition to the step-by-step tasks, you'll find several "About" tasks. These tasks give you necessary background when that background is required to do something else. For example, before learning how to apply a theme to an Excel worksheet, you need to understand how styles, themes, and templates go together to help reduce your work time and increase your productivity. Therefore, the "About Excel Styles, Themes, and Templates" task (task number 78) provides the background necessary—and no more—for you to then tackle the tasks that show you how to apply a style, theme, or template to your work.

As you follow the tasks, you'll run across several Tips such as this one:


Tip - If you want to freeze only the top row, you don't need to select it first. You only need to select Freeze Top Row from the Freeze Panes drop down list. The same is also true if you want to free the leftmost column; you would select Freeze First Column.


These Tips give you added insight into the task you're currently learning about and show you ways to improve on something you're doing.

Several Notes are included as well to explain a task in more detail, such as this one:


Note - Whatever format you can apply to a cell you can also apply to a range or to your entire worksheet. Select what you want to format and then select the formatting command.


It seems to be the nature of computer software to litter our language with terms that are generally unfamiliar to newcomers, and sometimes to advanced users too. When a new term is introduced, the New Term margin note will explain the term to you like this:


New Term - AutoFit—The capability of Excel to adjust a column's width to accommodate the widest data value in that column.

Your Job Now

With that introduction, it's time that you began learning what Office 2007 has in store for you. Turn the page and begin learning Microsoft's exciting redesigned product.

© Copyright Pearson Education. All rights reserved.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

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

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