Skip to content

Microsoft Office 2010 on Demand

ISBN-10: 0789742780

ISBN-13: 9780789742780

Edition: 2010

Authors: Steve Johnson, Inc. Staff Perspection

List price: $18.99
Blue ribbon 30 day, 100% satisfaction guarantee!
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Customers also bought

Book details

List price: $18.99
Copyright year: 2010
Publisher: Pearson Education, Limited
Publication date: 6/15/2010
Binding: Paperback
Pages: 768
Size: 7.00" wide x 9.00" long x 1.25" tall
Weight: 2.750
Language: English

Introduction
Getting Started with Office
Starting an Office Program
New! Viewing an Office Program Window
Using the Ribbon 4
New! Choosing Commands
New! Working with the Ribbon and Toolbars
New! Choosing Dialog Box Options
Using the Status Bar
Creating a Blank Office Document
Creating a Document Using a Template
Opening an Existing Office Document
New! Converting an Existing Office Document
Using Task and Window Panes
Arranging Windows
Switching Views
Documenting Properties
Getting Help While You Work
Saving an Office Document
Saving an Office Document with Different Formats
Checking Compatibility
Checking Accessibility
New! Recovering an Office Document
New! Maintaining and Repairing Office
Getting Updates on the Web
Closing a Document and Exiting Office
Using Shared Office Tools
Editing Text
Copying and Moving Text
New! Finding and Replacing Text
Correcting Text Automatically
New! Inserting Information the Smart Way
New! Checking Spelling
Changing Proofing Options
Using Custom Dictionaries
Inserting Symbols
Finding the Right Words
Inserting Research Material
Translating Text to Another Language
New! Using Multiple Languages
New! Undoing and Redoing an Action
Zooming the View In and Out
Previewing a Document
New! Printing a Document
New! Creating a Template
Adding Art to Office Documents
Locating and Inserting Clip Art
New! Inserting a Picture
Inserting a Picture Screen Shot
New! Adding an Artistic Style to a Picture
New! Adding a Quick Style to a Picture
Applying a Shape to a Picture
New! Applying a Border to a Picture
Applying Picture Effects
Modifying Picture Size
Compressing a Picture
New! Correcting a Picture
New! Recoloring a Picture
New! Cropping and Rotating a Picture
New! Removing a Picture Background
New! Creating WordArt Text
Formatting WordArt Text
Applying WordArt Text Effects
Modifying WordArt Text Position
Creating SmartArt Graphics
New! Formatting a SmartArt Graphic
Modifying a SmartArt Graphic
Adding Pictures to a SmartArt Graphic
New! Creating an Organization Chart
Inserting and Creating a Chart
Changing a Chart Layout and Style
New! Changing Chart Labels
Formatting Line and Bar Charts
Editing Chart Data
New! Saving a Chart Template
Adding Shapes to Office Documents
Drawing and Resizing Shapes
Adding Text to a Shape
Creating and Editing Freeforms
Adding a Quick Style to a Shape
Adding a Quick Style to Shape Text
Applying Color Fills
Applying Picture or Texture Fills
Applying Gradient Fills
Applying Shape Effects
Aligning and Distributing Objects
Aligning Objects to Grids and Guides
New! Changing Stacking Order
Rotating and Flipping Objects
Grouping and Ungrouping Objects
Selecting Objects Using the Selection Pane
Formatting Office Documents
Formatting Text
Changing Alignment
Using the Format Painter
Adding Custom Colors
Understanding Themes
Viewing and Applying a Theme
New! Creating Theme Colors
Choosing Theme Fonts
Choosing Theme Effects
Creating a Custom Theme
Choosing a Custom Theme
Creating a Document with Word
Viewing the Word Window
Moving Around in a Document
Changing Document Views
Reading a Document
New! Navigating a Document
New! Setting Up the Page
Setting Up the Page Margins
Creating an Outline
Selecting Text
Checking Spelling and Grammar
Inserting New Pages and Sections
Adding Headers and Footers
Inserting Page Numbers and the Date and Time
Creating a Blog Posting on the Web
Formatting a Document with Word
Formatting Text for Emphasis
New! Finding and Replacing Formatting
Changing Paragraph Alignment
Changing Line Spacing
Displaying Rulers
Setting Paragraph Tabs
Setting Paragraph Indents
Changing Character Spacing
New! Applying a Quick Style
Changing a Style Set
Creating and Modifying Styles
Creating Bulleted and Numbered Lists
New! Hiding Text
Enhancing a Document with Word
Adding Desktop Publishing Effects
Adding a Watermark
New! Adding Page Backgrounds
Arranging Text in Columns
Wrapping Text Around an Object
Working with Text Boxes
New! Inserting Building Blocks Using Quick Parts
New! Creating a Table
Entering Text in a Table
Modifying a Table
Adjusting Table Cells
Formatting a Table
Calculating a Value in a Table
Addressing Envelopes and Labels
Creating a Form Letter
Creating Labels
Inserting a Table of Contents
Creating an Index
Creating Captions
Creating a Table of Figures
Creating Footnotes or Endnotes
Creating a Bookmark
Inserting Cross References
Comparing and Merging Documents
Using Track Changing
Adding a Cover Page
New!
Creating a Worksheet with Excel
Viewing the Excel Window
Selecting Cells
Moving Around the Workbook
Entering Labels on a Worksheet
Entering Values on a Worksheet
Entering Values Quickly with AutoFill
Editing Cell Contents
Clearing Cell Contents
Inserting and Deleting Cell Contents
Selecting Rows, Columns, and Special Ranges
Selecting and Naming a Worksheet
Inserting and Deleting a Worksheet
Moving and Copying a Worksheet
Hiding and Unhiding Worksheets and Workbooks
Hiding and Unhiding a Column or Row
Inserting a Column or Row
Deleting a Column or Row
Adjusting Column Width and Row Height
Splitting a Worksheet into Panes
Freezing and Unfreezing a Column or Row
Showing and Hiding Workbook Elements
Building a Worksheet with Excel
Understanding Formulas
Understanding Cell Referencing
Creating a Simple Formula
Creating a Formula Using Formula AutoComplete
Editing a Formula
Naming Cells and Ranges
Entering Named Cells and Ranges
Managing Names
Simplifying a Formula with Ranges
Calculating Totals with AutoSum
Correcting Formulas
Auditing a Worksheet
Creating Functions
Creating Functions Using the Library
New! Calculating Multiple Results
Using Nested Functions
Using Text Functions
Using Lookup and Reference Functions
Summarizing Data Using Subtotals
Summarizing Data Using Functions
Converting Text to Columns
Creating a Table
Formatting a Table
Formatting Table Elements
Creating Calculations in a Table
Removing Table Rows and Columns
Working with Tables
Sorting Data in a Table
Displaying Parts of a Table with AutoFilter
New! Creating Custom Searches
Creating Groups and Outlines
Adding Data Validation to a Worksheet
Creating a Drop-Down List
Designing a Worksheet with Excel
Formatting Numbers
Applying and Creating Cell Styles
Applying Conditional Formatting
New! Applying Specialized Conditional Formatting
New! Creating Conditional Formatting
New! Managing Conditional Formatting
Creating Sparkline Formatting
New! Controlling Text Flow
Formatting Tabs and Background
Adding Borders to Cells
Setting Up the Page
Inserting Page Breaks
Adjusting Page Margins
Adding Headers and Footers
Customizing Worksheet Printing
Setting the Print Area
Creating a Presentation with PowerPoint
Viewing the PowerPoint Window
Browsing a Presentation
Understanding PowerPoint Views
New! Creating New and Consistent Slides
Working with Objects
Entering and Editing Text
Resizing Text While Typing
Changing Text Spacing
Inserting and Developing an Outline
Moving and Indenting Text
Modifying a Bulleted and Numbered List
Creating Text Columns
Organizing Slides into Sections
New! Rearranging Slides
Using Slides from Other Presentations
New! Making Your Presentation Look Consistent
Controlling Slide Appearance with Masters
Controlling a Slide Layout with Masters
Modifying Placeholders
Controlling a Slide Background with Masters
Adding a Background Style
New! Inserting a Table
Modifying a Table
Adding a Quick Style to a Table
Formatting a Table
Creating a Text Box
Delivering a Presentation with PowerPoint
Changing Page Setup Options
Adding Animation
New! Using Specialized Animations
New! Coordinating Multiple Animations
New! Adding Slide Timings
Creating Slide Transitions
New! Inserting Videos and Audio
New! Editing and Formatting Videos and Audio
New! Setting Video and Audio Play Options
Recording a Narration
New! Setting Up a Slide Show
Creating a Custom Slide Show
Starting a Slide Show
Navigating a Slide Show
New! Annotating a Slide Show
Saving a Presentation as a Slide Show
New! Saving a Presentation as a Video
New! Packaging a Presentation on CD
Preparing Handouts
Preparing Speaker Notes
Adding a Footer and Header
Inserting the Date and Time
Inserting Slide Numbers
Previewing Slides
Printing a Presentation
New!
Creating a Database with Access
Understanding How Databases Store Data
Creating a Database
New! Viewing the Access Window
Changing Database Display Options
New! Viewing Database Objects
Working with Database Objects
New! Planning Tables
Creating a Table by Entering Data
New! Creating an Application Part Using a Template
New! Creating a Table Using SharePoint
Working with a Table
Importing Data into Tables
Working with a Table in Design View
Working with Fields
Specifying Data Types and Field Properties
New! Changing Field Properties
Creating Input Masks
Creating a Lookup Field
Planning Table Relationships
Defining Table Relationships
Ensuring Referential Integrity
Locating and Managing Data with Access
Sorting Records
Filtering Out Records
New! Creating Complex Filters Using Forms
Understanding the Different Types of Queries
Creating a Query Using a Wizard
Creating a Query in Design View
Getting Information with a Query
Modifying a Query in Design View
Performing Calculations in Queries
New! Summarizing Values with a Crosstab Query
Creating a Parameter Query
Finding Duplicate Fields
Identifying Object Dependencies
Backing Up and Repairing a Database
Sharing a Database
New!
Presenting Data with Access
Creating a Form
New! Working with a Form in Design View
New! Entering and Editing Data in a Form
Modifying a Form
New! Creating a Report
Modifying a Report in Design View
Performing Calculations in Reports
Formatting a Form or Report
New! Aligning and Sizing Controls
Grouping and Sorting in Reports
Formatting a Datasheet
Changing the Page Setup
Previewing and Printing Information
Creating Mailing Labels
Communicating with Outlook
Preparing for Outlook
Using Outlook for the First Time
Viewing the Outlook Window
New! Using the To-Do Bar
Using the Navigation Pane
Viewing Items and Folders
Creating a Contact
Sorting Contacts
Creating a Contact Group
Creating and Addressing an E-Mail Message
Formatting Message Text
Attaching a File or Item to a Message
Using Stationery
Creating a Signature
Inserting Message Content
New! Sending Messages
Setting Message Delivery Options
Receiving and Reading Messages
Flagging Messages
Categorizing Messages By Color
Deleting Messages
New! Replying To and Forwarding a Message
New! Finding and Filtering Messages
New! Organizing Messages in Folders
New! Managing Messages with Rules
Managing Messages with Quick Steps
New! Using Search Folders
Working with a Message Conversation
New! Reducing Junk Messages
Archiving Messages
Cleaning Up Messages
New! Working with Outlook Data
Sending and Receiving Instant Messages
Managing Information with Outlook
Viewing the Calendar
New! Customizing the Calendar
New! Scheduling an Appointment and Event
New! Scheduling Meetings
New! Responding to Meeting Requests
New! Updating and Canceling Meeting Re quests
Working with Calendars
New! Creating and Updating Tasks
Organizing Tasks
Assigning Tasks to Others
Monitoring Task Progress
Managing Tasks
Tracking Activities with Contacts
Recording Items in the Journal
Opening and Modifying Journal Entries
Organizing Items by Categories
Customizing How You View Items
New! Creating and Modifying Notes
Previewing and Printing Items from Outlook
New! Connecting to a Social Network
New! Sharing Calendars Over the Internet
Adding and Viewing an RSS Feed
Creating a Publication with Publisher
Viewing the Publisher Window
New! Creating a New Publication
Downloading a New Publication
Creating a Blank Publication
Changing Your View
Working with Pages
Inserting and Editing Text
Inserting Content
New! Controlling Pages Appearance with Masters
Applying Color
Checking Your Design
Setting Up the Page
Using Commercial Printing Tools
Printing a Publication
New!
Designing a Publication with Publisher
Setting Up Layout Guides
Viewing Elements and Tools
Working with Text
Connecting Text Frames
Creating a Consistent Look
Creating Tables
Working with Pictures and Shapes
New! Wrapping Text Around an Object
Layering Objects
Grouping Objects Together
Aligning with Precision
Rotating and Flipping Objects
Publishing Office Documents on the Web
Opening a Web Page
Previewing a Web Page
Creating a Hyperlink
Adding Hyperlinks to Slide Objects
Formatting a Cell Hyperlink
Changing Web Page Options
Saving a Web Page
Publishing a Web Page
Saving Slides as Web Graphics
Creating Refreshable Web Queries
Getting Data from Web Queries
Saving Web Queries
Accessing Office Information on the Web
Getting Documents from the Web
Protecting and Securing Office Documents
Inspecting Documents
Protecting a Worksheet
Locking or Unlocking Worksheet Cells
Adding Security Encryption to a Document
Adding Password Protection to a Document
Adding a Digital Signature
Adding a Signature Line
Avoiding Harmful Attacks
Using the Trust Center
New! Selecting Trusted Publishers and Locations
Setting Document Related Security Options
New! Setting Add-in Security Options
Setting ActiveX Security Options
Setting Macro Security Options
Changing Message Bar Security Options
Setting Privacy Options
Setting External Content Security Options
Working with Office Safe Modes
Marking a Document as Read-Only
Reviewing and Sharing Office Documents
Sharing Workbooks
Creating and Reading a Cell Comment
Editing and Deleting a Cell Comment
Adding Comments to a Presentation
Tracking Workbook Changes
Comparing and Merging Presentations
New! Creating and Opening OneNotes
New! Sending a Document for Review Using E-Mail
Sending a Document by Internet Fax
Creating a PDF Document
Creating an XPS Document
Working with XML
New! Creating an XML Data Map
Exporting and Saving Data in X ML
Sharing Information Between Programs
Exporting and Importing Data
New! Linking and Embedding Files
New! Consolidating Data in Excel
Linking Data in Excel
Getting External Data in Excel
Connecting to Data in Excel
Getting Query Data from a Database
Getting Data from Access
Getting Text Data in Excel
Saving a Document to a SharePoint Server
Saving Documents to Windows Live
New! Publishing Slides to a Library
Broadcasting a Presentation
New!
Expanding Office Functionality
Viewing and Managing Add-ins
New! Loading and Unloading Add-ins
Enhancing a Document with VBA
Viewing the Visual Basic Editor
Setting Developer Options
Understanding How Macros Automate Your Work
Recording a Macro
Creating a Macro
Running a Macro
Controlling a Macro
Building a Macro
New! Adding a Digital Signature to a Macro Project
Assigning a Macro to a Toolbar
Saving a Document with Macros
Opening a Document with Macros
Inserting ActiveX Controls
Using ActiveX Controls
Setting ActiveX Control Properties
Adding VBA Code to an ActiveX Control
Playing a Movie Using an ActiveX Control
Changing the Document Information Panel
Working with Other Office Tools
Viewing the OneNote Window
Working with OneNote
Viewing the InfoPath Designer Window
Working with InfoPath Designer
Viewing the InfoPath Filler Window
Working with InfoPath Filler
Organizing Clips
Managing Pictures
Working with SharePoint Workspaces
New! Working with Office Online
New! New Features
New! Microsoft Certified Applications Specialist
Index