skip to content
Microsoft Office 2010 on demand Preview this item
ClosePreview this item

Microsoft Office 2010 on demand

Author: Steve Johnson
Publisher: Indianapolis, IN : Que Pub., ©2010.
Series: On demand (Indianapolis, Ind.)
Edition/Format:   Print book : EnglishView all editions and formats

An ideal hands-on guide for every advanced beginner-to-intermediate-level user who wants to make the most of the new Office 2010, this book combines step-by-step training with quick-reference  Read more...


(not yet rated) 0 with reviews - Be the first.

More like this


Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


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


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


All user tags (3)

View most popular tags as: tag list | tag cloud

Similar Items

Related Subjects:(2)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Microsoft Office 2010 on demand
    a schema:CreativeWork, schema:Book ;
    library:oclcnum "471787231" ;
    library:placeOfPublication <> ; # Indianapolis, IN
    library:placeOfPublication <> ;
    schema:about <> ; # Business--Computer programs
    schema:about <> ; # Microsoft Office.
    schema:about <> ;
    schema:about <> ; # Microsoft Office.
    schema:about <> ; # Business--Computer programs
    schema:bookFormat bgn:PrintBook ;
    schema:copyrightYear "2010" ;
    schema:creator <> ; # Steve Johnson
    schema:datePublished "2010" ;
    schema:exampleOfWork <> ;
    schema:inLanguage "en" ;
    schema:isPartOf <> ; # On demand
    schema:isPartOf <> ; # On demand (Indianapolis, Ind.)
    schema:name "Microsoft Office 2010 on demand"@en ;
    schema:productID "471787231" ;
    schema:publication <> ;
    schema:publisher <> ; # Que Pub.
    schema:url <> ;
    schema:workExample <> ;
    umbel:isLike <> ;
    wdrs:describedby <> ;

Related Entities

<> # Indianapolis, IN
    a schema:Place ;
    schema:name "Indianapolis, IN" ;

<> # On demand (Indianapolis, Ind.)
    a bgn:PublicationSeries ;
    schema:hasPart <> ; # Microsoft Office 2010 on demand
    schema:name "On demand (Indianapolis, Ind.)" ;

<> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;

<> # Microsoft Office.
    a schema:CreativeWork ;
    schema:name "Microsoft Office." ;

<> # Business--Computer programs
    a schema:Intangible ;
    schema:name "Business--Computer programs"@en ;

<> # Steve Johnson
    a schema:Person ;
    schema:birthDate "1961" ;
    schema:familyName "Johnson" ;
    schema:givenName "Steve" ;
    schema:name "Steve Johnson" ;

    a schema:ProductModel ;
    schema:isbn "0789742780" ;
    schema:isbn "9780789742780" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.