Microsoft Office 2007 On Demand

Want to read this on your NOOK? Request as NOOK Book from the publisher

Thank you for requesting this book as a NOOK book from the publisher.

Customers Who Bought This Also Bought

More About This Book

Overview
Product Details
Meet the Author
Read an Excerpt
Table of Contents

Advertising

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

Product Details

ISBN-13: 9780789736406
Publisher: Que
Publication date: 1/1/2007
Pages: 728
Sales rank: 713,584
Series: On Demand Series
Product dimensions: 7.52 (w) x 9.50 (h) x 1.23 (d)

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.

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.

Introduction     xxi
Getting Started with Office     1
Starting an Office Program     2
Viewing an Office Program Window     3
Using the Ribbon     4
Choosing Commands     5
Working with Toolbars     6
Choosing Dialog Box Options     8
Using the Status Bar     9
Creating a Blank Office Document     10
Creating a Document Using a Template     11
Opening an Existing Office Document     12
Converting an Existing Office Document     14
Using Task and Window Panes     15
Arranging Windows     16
Getting Help While You Work     18
Saving an Office Document     20
Saving an Office Document with Different Formats     22
Checking Compatibility     24
Documenting Properties     25
Switching Views     26
Getting Updates on the Web     27
Recovering an Office Document     28
Diagnosing and Repairing Problems     30
Closing a Document and Exiting Office     32
Using Shared Office Tools     33
Editing Text     34
Copying and Moving Text     36
Finding and Replacing Text     38
Correcting Text Automatically     40
Inserting Information the Smart Way     42
Checking Spelling     44
Changing Proofing Options     45
Using Custom Dictionaries     46
Inserting Symbols     47
Finding the Right Words     48
Inserting Research Material     49
Translating Text to Another Language     50
Using Multiple Languages     51
Undoing and Redoing an Action     52
Zooming the View In and Out     53
Previewing a Document     54
Printing a Document     55
Creating a Template     56
Adding Art to Office Documents     57
Locating and Inserting Clip Art     58
Inserting a Picture     59
Adding a Quick Style to a Picture     60
Applying a Shape to a Picture     61
Applying a Border to a Picture     62
Applying Picture Effects     63
Modifying Picture Size     64
Compressing a Picture     66
Modifying Picture Brightness and Contrast     67
Recoloring a Picture     68
Cropping and Rotating a Picture      70
Scanning and Imaging Documents     71
Managing Pictures     72
Creating WordArt Text     73
Formatting WordArt Text     74
Applying WordArt Text Effects     76
Modifying WordArt Text Position     77
Creating SmartArt Graphics     78
Formatting a SmartArt Graphic     80
Modifying a SmartArt Graphic     82
Creating an Organization Chart     83
Modifying an Organization Chart     84
Inserting and Creating a Chart     85
Changing a ChartType     86
Changing a Chart Layout and Style     87
Changing Chart Titles     88
Changing Chart Labels     89
Formatting Line and Bar Charts     90
Editing Chart Data     91
Saving a Chart Template     92
Adding Shapes to Office Documents     93
Drawing and Resizing Shapes     94
Adding Text to a Shape     96
Creating and Editing Freeforms     97
Adding a Quick Style to a Shape     98
Adding a Quick Style to Shape Text     99
Applying Color Fills     100
Applying Picture or Texture Fills     102
Applying Gradient Fills     103
Applying Shape Effects     104
Aligning and Distributing Objects     106
Aligning Objects to Grids and Guides     108
Changing Stacking Order     110
Rotating and Flipping Objects     111
Grouping and Ungrouping Objects     112
Selecting Objects Using the Selection Pane     114
Formatting Office Documents     115
Formatting Text     116
Changing Alignment     118
Using the Format Painter     120
Adding Custom Colors     121
Understanding Themes     122
Viewing and Applying a Theme     123
Creating Theme Colors     124
Choosing Theme Fonts     126
Choosing Theme Effects     128
Creating a Custom Theme     129
Choosing a Custom Theme     130
Creating a Document with Word     131
Viewing the Word Window     132
Moving Around in a Document     133
Changing Document Views     134
Reading a Document     136
Setting Up the Page     138
Setting Up the Page Margins     140
Creating an Outline     142
Selecting Text     143
Checking Spelling and Grammar     144
Inserting New Pages and Sections     146
Adding Headers and Footers     148
Inserting Page Numbers and the Date and Time     150
Formatting a Document with Word     153
Formatting Text for Emphasis     154
Finding and Replacing Formatting     156
Changing Paragraph Alignment     158
Changing Line Spacing     159
Displaying Rulers     160
Setting Paragraph Tabs     161
Setting Paragraph Indents     162
Changing Character Spacing     164
Applying a Quick Style     165
Changing a Style Set     166
Creating and Modifying Styles     168
Creating Bulleted and Numbered Lists     170
Hiding Text     172
Enhancing a Document with Word     173
Adding Desktop Publishing Effects     174
Adding a Watermark     175
Adding Page Backgrounds     176
Adding Text in Columns     178
Wrapping Text Around an Object     180
Working with Text Boxes     182
Inserting Building Blocks Using Quick Parts     184
Creating a Table     186
Entering Text in a Table     187
Modifying a Table     188
Adjusting Table Cells     190
Formatting a Table     192
Calculating a Value in a Table     194
Addressing Envelopes and Labels     195
Creating a Form Letter     196
Creating Labels     198
Inserting a Table of Contents     200
Creating an Index     201
Creating Captions     202
Creating a Table of Figures     203
Creating Footnotes or Endnotes     204
Creating a Bookmark     205
Inserting Cross References     206
Comparing and Merging Documents     207
Using Track Changing     208
Adding a Cover Page     210
Creating a Worksheet with Excel     211
Viewing the Excel Window     212
Selecting Cells     213
Moving Around the Workbook     214
Entering Labels on a Worksheet     216
Entering Values on a Worksheet     218
Entering Values Quickly with AutoFill     219
Editing Cell Contents     220
Clearing Cell Contents     221
Inserting and Deleting Cell Contents      222
Selecting Rows, Columns, and Special Ranges     224
Selecting and Naming a Worksheet     226
Inserting and Deleting a Worksheet     227
Moving and Copying a Worksheet     228
Hiding and Unhiding Worksheets and Workbooks     230
Hiding and Unhiding a Column or Row     231
Inserting a Column or Row     232
Deleting a Column or Row     233
Adjusting Column Width and Row Height     234
Splitting a Worksheet into Panes     236
Freezing and Unfreezing a Column or Row     237
Showing and Hiding Workbook Elements     238
Building a Worksheet with Excel     239
Understanding Formulas     240
Understanding Cell Referencing     241
Creating a Simple Formula     242
Creating a Formula Using Formula AutoComplete     244
Editing a Formula     245
Naming Cells and Ranges     246
Entering Named Cells and Ranges     248
Managing Names     250
Simplifying a Formula with Ranges     252
Calculating Totals with AutoSum     253
Correcting Formulas     254
Auditing a Worksheet     256
Creating Functions     257
Creating Functions Using the Library     258
Calculating Multiple Results     259
Using Nested Functions     260
Using Text Functions     261
Using Lookup and Reference Functions     262
Summarizing Data Using Subtotals     264
Summarizing Data Using Functions     265
Converting Text to Columns     266
Creating a Table     267
Formatting a Table     268
Formatting Table Elements     269
Creating Calculations in a Table     270
Removing Table Rows and Columns     271
Working with Tables     272
Sorting Data in a Table     274
Displaying Parts of a Table with AutoFilter     276
Creating Custom Searches     277
Creating Groups and Outlines     278
Adding Data Validation to a Worksheet     279
Creating a Drop-Down List     280
Designing a Worksheet with Excel     281
Formatting Numbers     282
Applying and Creating Cell Styles     284
Applying Conditional Formatting     286
Applying Specialized Conditional Formatting     288
Creating Conditional Formatting      290
Managing Conditional Formatting     291
Controlling Text Flow     292
Formatting Tabs and Background     293
Adding Borders to Cells     294
Setting Up the Page     295
Adjusting Page Margins     296
Adding Headers and Footers     298
Inserting Page Breaks     300
Customizing Worksheet Printing     302
Setting the Print Area     304
Creating a Presentation with PowerPoint     305
Viewing the PowerPoint Window     306
Browsing a Presentation     307
Understanding PowerPoint Views     308
Creating New and Consistent Slides     310
Working with Objects     312
Entering and Editing Text     314
Resizing Text While Typing     316
Changing Character Direction     317
Inserting and Developing an Outline     318
Moving and Indenting Text     320
Modifying a Bulleted and Numbered List     322
Creating Text Columns     324
Changing Text Spacing     325
Rearranging Slides     326
Using Slides from Other Presentations     328
Making Your Presentation Look Consistent     329
Controlling Slide Appearance with Masters     330
Controlling a Slide Layout with Masters     332
Modifying Placeholders     334
Controlling a Slide Background with Masters     336
Adding a Background Style     337
Inserting a Table     338
Modifying a Table     339
Formatting a Table     340
Adding a Quick Style to a Table     341
Creating a Text Box     342
Delivering a Presentation with PowerPoint     343
Changing Page Setup Options     344
Adding Animation     345
Using Specialized Animations     346
Coordinating Multiple Animations     348
Adding Slide Timings     350
Creating Slide Transitions     352
Recording a Narration     353
Inserting Movies and Sounds     354
Setting Movie and Sound Play Options     355
Setting Up a Slide Show     356
Creating a Custom Slide Show     358
Starting a Slide Show     359
Navigating a Slide Show     360
Annotating a Slide Show     361
Packaging a Presentation on CD     362
Saving a Presentation as a Slide Show      364
Preparing Handouts     365
Preparing Speaker Notes     366
Adding a Footer and Header     368
Inserting the Date and Time     359
Inserting Slide Numbers     370
Previewing Slides     372
Printing a Presentation     373
Creating a Database with Access     375
Understanding How Databases Store Data     376
Creating a Database     378
Viewing the Access Window     380
Changing Database Display Options     381
Viewing Database Objects     382
Working with Database Objects     384
Planning Tables     386
Creating a Table by Entering Data     387
Creating a Table Using a Template     388
Creating a Table Using SharePoint     389
Working with a Table     390
Importing Data into Tables     392
Working with a Table in Design View     393
Working with Fields     394
Specifying Data Types and Field Properties     396
Changing Field Properties     397
Creating Input Masks     393
Creating a Lookup Field     399
Planning Table Relationships      400
Defining Table Relationships     402
Ensuring Referential Integrity     404
Locating and Managing Data with Access     405
Sorting Records     406
Filtering Out Records     407
Creating Complex Filters Using Forms     408
Understanding the Different Types of Queries     409
Creating a Query Using a Wizard     410
Creating a Query in Design View     412
Getting Information with a Query     413
Modifying a Query in Design View     414
Performing Calculations in Queries     415
Summarizing Values with a Crosstab Query     416
Creating a Parameter Query     418
Finding Duplicate Fields     419
Identifying Object Dependencies     420
Backing Up a Database     421
Compacting and Repairing a Database     422
Presenting Data with Access     423
Creating a Form     424
Working with a Form in Design View     426
Entering and Editing Data in a Form     427
Modifying a Form     428
Creating a Report     430
Modifying a Report in Design View     432
Performing Calculations in Reports      434
Formatting a Form or Report     436
Aligning and Grouping Controls     438
Grouping and Sorting in Reports     440
Formatting a Datasheet     442
Changing the Page Setup     443
Previewing and Printing Information     444
Creating Mailing Labels     446
Communication with Outlook     447
Preparing for Outlook     448
Using Outlook for the First Time     449
Viewing the Outlook Window     450
Using Outlook Today     451
Using the Navigation Pane     452
Viewing Items and Folders     453
Creating a Contact     454
Sorting Contacts     456
Creating a Distribution List     457
Creating and Addressing and E-Mail Message     458
Formatting Message Text     460
Attaching a File or Item to a Message     461
Using Stationery     462
Creating a Signature     463
Inserting Message Content     464
Sending Messages     465
Setting Message Delivery Options     466
Receiving and Reading Messages     468
Flagging Messages     469
Categorizing Messages By Color     470
Deleting Messages     471
Replying To and Forwarding a Message     472
Finding and Filtering Messages     474
Organizing Messages in Folders     476
Managing Messages with Colors and Rules     478
Using Search Folders     480
Reducing Junk E-Mail     482
Archiving Messages     483
Working with Outlook Data     484
Sending and Receiving Instant Messages     486
Enabling Instant Messaging     488
Managing Information with Outlook     489
Viewing the Calendar     490
Customizing the Calendar     491
Scheduling an Appointment and Event     492
Scheduling Meetings     494
Responding to Meeting Requests     496
Updating and Canceling Meeting Requests     498
Creating an Online Meeting Workspace     499
Creating and Updating Tasks     500
Organizing Tasks     501
Assigning Tasks to Others     502
Monitoring Task Progress     503
Managing Tasks     504
Tracking Activities with Contacts     505
Recording Items in the Journal     506
Opening and Modifying Journal Entries     508
Organizing Items by Categories     509
Customizing How You View Items     510
Creating and Modifying Notes     512
Previewing Items from Outlook     513
Printing Items from Outlook     514
Customizing Panes     515
Sharing Calendars Over the Internet     516
Adding and Viewing an RSS Feed     518
Creating a Publication with Publisher     519
Viewing the Publisher Window     520
Creating a Quick Publication     521
Creating a New Publication     522
Creating a Blank Publication     523
Changing Your View     524
Inserting and Deleting Pages     525
Inserting and Editing Text     526
Creating a Web Site     528
Adding a Hot Spot Hyperlink     530
Applying Color     531
Adding Design Gallery Elements     532
Checking Your Design     533
Setting Up the Page     534
Using Commercial Printing Tools     535
Printing Publications     536
Designing a Publication with Publisher     537
Setting Up Layout Guides     538
Creating a Frame      539
Working with Text     540
Connecting Text Frames     542
Creating a Consistent Look     544
Creating Tables     546
Working with Pictures and Shapes     548
Wrapping Text Around an Object     550
Layering Objects     552
Grouping Objects Together     553
Aligning with Precision     554
Rotating and Flipping Objects     556
Publishing Office Documents on the Web     557
Opening a Web Page     558
Previewing a Web Page     559
Creating a Hyperlink     560
Adding Hyperlinks to Slide Objects     562
Formatting a Cell Hyperlink     564
Changing Web Page Options     565
Saving a Web Page     566
Publishing a Web Page     568
Saving Slides as Web Graphics     569
Creating Refreshable Web Queries     570
Getting Data from Web Queries     571
Saving Web Queries     572
Accessing Office Information on the Web     573
Getting Documents from the Web     574
Protecting and Securing Office Documents     575
Inspecting Documents     576
Protecting a Worksheet     578
Locking or Unlocking Worksheet Cells     580
Adding Security Encryption to a Document     581
Adding Password Protection to a Document     582
Restricting Document Access     584
Adding a Digital Signature     586
Adding a Signature Line     588
Avoiding Harmful Attacks     590
Using the Trust Center     592
Selecting Trusted Publishers and Locations     593
Setting Add-in Security Options     594
Setting ActiveX Security Options     595
Setting Macro Security Options     596
Changing Message Bar Security Options     597
Setting Privacy Options     598
Setting External Content Security Options     600
Working with Office Safe Modes     602
Marking a Document as Read-Only     604
Reviewing and Sharing Office Documents     605
Sharing Workbooks     606
Creating and Reading a Cell Comment     608
Editing and Deleting a Cell Comment     609
Adding Comments to a Presentation     610
Tracking Changes     612
Sending a Document for Review Using E-Mail     614
Sending a Document by Internet Fax     615
Working with XML     616
Creating an XML Data Map     618
Exporting and Saving Data in XML     620
Creating a PDF Document     622
Creating an XPS Document     623
Sharing Information Between Programs     624
Exporting and Importing Data     626
Linking and Embedding Files     628
Consolidating Data in Excel     630
Linking Data in Excel     632
Getting External Data in Excel     633
Connecting to Data in Excel     634
Getting Query Data from a Database     636
Getting Data from Access     638
Getting Text Data in Excel     640
Working with a Shared Workspace     641
Working with Excel Services     642
Publishing Slides to a Library     644
Saving a Document to a Document Management Server     646
Expanding Office Functionality     647
Viewing and Managing Add-ins     648
Loading and Unloading Add-ins     650
Enhancing a Document with VBA     652
Viewing the Visual Basic Editor     654
Setting Developer Options     655
Understanding How Macros Automate Your Work      656
Recording a Macro     657
Creating a Macro     658
Running a Macro     659
Controlling a Macro     660
Adding a Digital Signature to a Macro Project     662
Assigning a Macro to a Toolbar     663
Saving a Document with Macro     664
Opening a Document with Macros     665
Inserting ActiveX Controls     666
Using ActiveX Controls     668
Setting ActiveX Control Properties     669
Adding VBA Code to an ActiveX Control     670
Playing a Movie Using an ActiveX Control     671
Changing the Document Information Panel     672
New Features     673
Microsoft Certified Applications Specialist     683
Index     691

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:

Review Guidelines

Tell the world what you think of this product.

Add Recommendations

Your Name: Create a Pen Name or Leave Anonymously

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.

MarkSil

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.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.

If you find inappropriate content, please report it to Barnes & Noble

Microsoft Office 2007 On Demand

Overview

Customers Who Bought This Also Bought

More About This Book

Overview

Related Subjects

Product Details

Meet the Author

Read an Excerpt

Table of Contents

Customer Reviews

Rating Distribution

5 Star

4 Star

3 Star

2 Star

1 Star

Your Rating:

Your Recommendations:

Barnes & Noble.com Review Rules

Reviews by Our Customers Under the Age of 13

What to exclude from your review:

Reviews should not contain any of the following:

Reminder:

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

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.