Hart-Davis G. Beginning Microsoft Office 2010

Apress, 2010. — 719 p.Do you need to get your work done with the Office programs—smoothly, easily, and quickly?
If so, you’ve picked up the right book.
This book is designed to help beginning and intermediate users get up to speed quickly with the Office 2010 programs and immediately become productive with them.
If you need to learn to use Word, Excel, PowerPoint, Outlook, and OneNote to accomplish everyday tasks, at work or at home, you’ll benefit from this book’s focused approach and detailed advice. You can either start from the beginning of the book and work through it, or use the Table of Contents or the Index to find the topic you need immediately, and then jump right in there.About the Author.
About the Technical Reviewers.Getting Started with Office 2010
Meeting the Office Programs and Learning What You Can Do With Them.
Microsoft Word.
Microsoft Excel.
Microsoft PowerPoint.
Microsoft Outlook.
Microsoft OneNote.
Understanding the Common Features of the Programs.
The Title Bar and Minimize, Maximize, and Close Buttons.
The Control Menu and the Quick Access Toolbar.
The Ribbon.
Backstage.
The Status Bar.
Opening Programs.
Opening a Program the Standard Way.
Making a Program Easy to Run.
Making a Program Launch Automatically.
Creating a Document. Saving a Document.
Closing a Document.
Opening a Document.
Closing a Program.Head in the Cloud: Experiencing Software as a Service
Coming to Grips with Software as a Service.
Understanding What Software as a Service Is.
Understanding the Office Web Apps, Windows Live, and SkyDrive.
Deciding Whether Software as a Service Meets Your Needs.
Getting Started with the Office Web Apps.
Signing Up for the Office Web Apps.
Opening an Office Web App.
Saving Changes to a Document in the Office Web Apps.
Transferring Documents Between SkyDrive and Your PC.
Saving Documents to SkyDrive from the Desktop Office Programs.
Copying Documents from Your PC to SkyDrive.
Downloading Documents from SkyDrive to Your PC.Learning Common Tools Across the Office Suite
Using the Ribbon.
Giving Commands from the Ribbon.
Minimizing the Ribbon.
Controlling the Ribbon with the Keyboard.
Using Backstage.
Sharing a Document with Other People.
Sending a Document via E-mail.
Saving a Document to SkyDrive.
Saving a Document to a SharePoint Server. Saving Time and Effort with AutoCorrect.
Choosing Options on the AutoCorrect Tab of the AutoCorrect Dialog Box.
Choosing AutoFormat As You Type Options.
Choosing Math AutoCorrect Options.
Creating AutoCorrect Entries.
Creating AutoCorrect Exceptions.
Working with Actions.
Checking Spelling and Grammar.
Checking Spelling.
Checking Grammar in Word and Outlook.
Taking Control over Spelling Checks with Custom Dictionaries.
Printing Documents.Working with Text and Graphics
Entering Text in Your Documents.
Entering Text in Documents Using Copy and Paste.
Entering Text by Scanning a Document and Using Optical Character Recognition.
Entering Text by Using Speech Recognition.
Inserting Symbols in a Document.
Navigating with the Keyboard and Selecting Objects.
Applying Direct Formatting to Text and Objects.
Using Cut, Copy, and Paste.
Using Standard Cut, Copy, and Paste in the Office Programs.
Using the Office Programs’ Clipboard.
Using Paste Options.
Setting Paste Options in Word.
Using Find and Replace.
Locating Text with Find.
Replacing Text with Replace. Creating Tables.
Inserting a Table.
Drawing a Table.
Merging and Splitting Cells in a Table.
Adding Content to a Table.
Formatting a Table.
Using Pictures and Shapes in Your Documents.
Understanding How You Position Graphical Objects.
Choosing Where to Insert a Graphical Object.
Inserting Clip Art.
Inserting Pictures in Your Documents.
Adding and Formatting a Shape.
Rotating a Graphical Object.
Positioning a Graphical Object.
Choosing Text Wrapping in Word and Outlook.
Making a Picture Look the Way You Want It.
Inserting SmartArt.
Arranging Graphical Objects to Control Which Is Visible.
Creating Hyperlinks.Customizing Office to Suit You
Customizing the Quick Access Toolbar, Ribbon, and Status Bar.
Customizing the Quick Access Toolbar.
Customizing the Ribbon.
Sharing Customizations with Other PCs.
Customizing the Status Bar.
Choosing Essential Options.
Choosing General Options.
Choosing Save Options in Word, Excel, and PowerPoint.Entering Text and Using Views
Entering Text in Your Word Documents.
Inserting the Text from a File in a Document.
Inserting Prebuilt Blocks of Text with AutoText.
Selecting Text in Word-Specific Ways.
Selecting Text with the Mouse.
Selecting Text with the Extend Selection Feature.
Selecting Multiple Items at Once.
Moving with Keyboard Shortcuts and the Browse Object.
Telling Word Where to Find Your Templates.
Customizing Keyboard Shortcuts in Word.
Creating Backup Documents and Recovering from Disaster.
Using Views and Windows to See What You Need.
Picking the Right View for What You’re Doing.
Opening Extra Windows.
Splitting the Document Window into Two Panes.Adding Style: Formatting Your Documents
Understanding Word’s Many Types of Formatting.
Understanding Direct Formatting and When to Use It.
Understanding Styles and When to Use Them.
Formatting Your Documents the Best Way.
Applying Styles to a Document.
Applying Different Quick Styles, Colors, Fonts, or Paragraph Spacing.
Changing the Styles in the Quick Style Gallery.
Using the Apply Styles Pane.
Applying Styles Using the Keyboard.
See Which Styles a Document Uses.
Managing Styles with the Styles Pane and the Manage Styles Dialog Box. Creating Custom Styles.
Creating a Custom Style by Example.
Modifying an Existing Style.
Applying Direct Formatting on Top of Styles.
Copying and Pasting Formatting Using the Format Painter.
Seeing Which Formatting You’ve Applied to Text.
Navigating Quickly Around Your Documents.
Using the Navigation Pane.
Using Find.
Replacing Text, Formatting, and Styles.
Navigating with Go To.Creating Complex Documents and Layouts
Working with Word’s Extra Table Features.
Converting Existing Text into a Table.
Converting a Table to Text.
Nesting One Table Inside Another Table.
Creating Complex Documents with Multiple Sections.
Adding Headers, Footers, and Page Numbers.
Adding Headers and Footers to a Document.
Inserting Page Numbers in a Document.
Creating Newspaper-Style Columns of Text.
Breaking Your Columns with Column Breaks.
Removing Multiple Columns from a Section or Document.
Using Bookmarks, Fields, and References.
Marking Important Parts of a Document with Bookmarks.
Inserting Automated Information with Fields.
Adding Cross-References to Other Parts of a Document.
Creating Long Documents with Outline View.
How Outlines Work. Developing the Outline of a Document.
Promoting and Demoting Headings.
Expanding and Collapsing the Outline and Headings.
Moving Paragraphs Up and Down the Document.
Returning from Outline View to Your Previous View.
Adding Footnotes and Endnotes.
Adding a Footnote.
Adding an Endnote.
Customizing Footnotes and Endnotes to Suit Your Document.
Converting Footnotes to Endnotes or Endnotes to Footnotes.
Navigating Among and Viewing Footnotes or Endnotes.Revising and Reviewing Documents
Understanding How You Can Work on Documents with Your Colleagues.
Editing a Document Simultaneously with Your Colleagues.
Sharing Documents with Your Colleagues on a Network.
Tracking the Changes in a Document.
Choosing Which Changes to Track.
Turning On Track Changes for a Document.
Ensuring Your Colleagues Use the Track Changes Feature.
Working in a Document with Track Changes On.
Choosing How to View the Document’s Changes and Markup.
Controlling Which Changes Word Displays.
Integrating Tracked Changes into a Document.
Using Track Changes in Full Screen Reading view.
Adding Comments to a Document.
Adding a Comment.
Viewing and Reviewing Comments.
Deleting Comments.
Comparing or Combining Different Versions of the Same Document. Using Word’s Document Versions.Printing, Finalizing, and Sharing Documents
Using Word’s Features for Printing Documents.
Printing a Custom Range of Pages.
Choosing Whether to Print Markup—Or Only Markup.
Printing Document Properties, Styles, AutoText Entries, and Key Assignments.
Finalizing a Document.
Removing Sensitive Information from a Document.
Marking a Document as Final.
Encrypting a Document with a Password.
Limiting the People Who Can Open, Edit, and Print the Document.
Signing a Final Document with a Digital Signature.
Making a Document You Can Open with Earlier Versions of Word.
Creating Documents for Digital Distribution.Creating Workbooks and Entering Data
Creating and Saving a New Workbook.
Creating a New Workbook.
Saving a Workbook.
Navigating the Excel Interface, Worksheets, and Workbooks.
Understanding Workbooks, Worksheets, Columns, and Rows.
Moving the Active Cell.
Selecting and Manipulating Cells.
Entering Data in Your Worksheets.
Typing Data in a Cell.
Editing a Cell.
Entering Data Quickly Using AutoFill.
Pasting Data into a Worksheet. Copying and Moving Data with Drag and Drop.
Inserting, Deleting, and Rearranging Worksheets.
Inserting and Deleting Worksheets.
Rearranging the Worksheets in a Workbook.
Making Excel Display Worksheets the Way You Need.
Understanding Excel’s Views.
Splitting the Window to View Separate Parts of a Worksheet.
Opening Extra Windows to Show Other Parts of a Workbook.
Changing the Window and Arranging Open Windows.
Zooming to Show the Data You Need to See.
Comparing Two Windows Side by Side.
Freezing Rows and Columns So That They Stay on Screen.Formatting Your Worksheets
Working with Rows and Columns.
Inserting and Deleting Rows, Columns, and Cells.
Setting Row Height.
Setting Column Width.
Hiding Rows and Columns.
Formatting Cells and Ranges.
Understanding the Three Main Tools for Applying Formatting.
Controlling How Data Appears by Applying Number Formatting.
Setting the Workbook’s Overall Look by Applying a Theme.
Setting Alignment.
Choosing Font Formatting.
Applying Borders and Fills.
Applying Protection to Cells.
Applying Conditional Formatting to Identify Particular Values.
Understanding Excel’s Preset Types of Conditional Formatting.
Applying a Preset Form of Conditional Formatting. Using Data Validation to Check for Invalid Entries.
Formatting Quickly with Table Formatting and Styles.
Formatting with Table Formatting.
Formatting with Styles.
Adding Headers and Footers to Your Worksheets.
Printing Your Excel Worksheets and Workbooks.
Telling Excel Which Part of the Worksheet to Print.
Checking the Page Layout and Where the Page Breaks Fall.
Printing a Worksheet or Workbook.
Sharing Your Workbooks with Your Colleagues.
Protecting a Workbook or Some of Its Worksheets.
Sharing a Workbook So That Your Colleagues Can Edit It.
Working in a Shared Workbook.
Resolving Conflicts in a Shared Workbook.Crunching Numbers with Formulas and Functions
Understanding the Difference Between Formulas and Functions.
Referring to Cells and Ranges in Formulas and Functions.
Referring to a Cell.
Referring to Ranges.
Referring to Named Cells and Ranges.
Performing Custom Calculations by Creating Formulas.
Meeting Excel’s Calculation Operators.
Using the Calculation Operators.
Understanding the Order in Which Excel Evaluates Operators.
Nesting Parts of Formulas to Override Operator Precedence.
Entering Formulas Quickly by Copying and Using AutoFill.
Troubleshooting Common Problems with Formulas.
Performing Standard Calculations by Inserting Functions.
Understanding Function Names and Arguments. Inserting Functions with the Function Drop-Down List.
Finding the Functions You Need with the Insert Function Dialog Box.
Inserting Functions with the Function Library.
Providing the Arguments for the Function.
Inserting Functions by Typing Them into a Worksheet.Creating Powerful and Persuasive Charts
Learning the Essentials of Charts in Excel.
Understanding Embedded Charts and Chart Sheets.
Understanding the Components of a Chart.
Understanding Excel’s Chart Types and Choosing Which to Use.
Creating, Laying Out, and Formatting a Chart.
Creating a Chart.
Changing a Chart from an Embedded Chart to a Chart Sheet.
Changing the Chart Type.
Switching the Rows and Columns in a Chart.
Changing the Source Data for a Chart.
Choosing the Layout for the Chart.
Changing the Order of the Data Series.
Adding a Separate Data Series to a Chart.
Applying a Style to a Chart.
Adding a Title to a Chart.
Adding Axis Titles to the Chart.
Changing the Scale or Numbering of an Axis.
Adding a Legend to a Chart.
Adding Axis Labels from a Range Separate from the Chart Data.
Adding Data Labels to the Chart.
Choosing Which Gridlines to Display.
Formatting a Chart Wall and Chart Floor.
Naming an Embedded Chart. Formatting Individual Chart Elements.
Copying Chart Formatting.
Reusing Your Own Designs by Creating Custom Chart Types.Creating and Using Excel Database Tables
Understanding What You Can and Can’t Do with Excel Database Tables.
Creating a Database Table and Entering Data.
Creating a Database Table.
Customizing the Database Table’s Looks.
Entering Data in a Database Table.
Resizing a Database Table.
Sorting a Database Table by One or More Fields.
Sorting Quickly by a Single Field.
Sorting a Database Table by Multiple Fields.
Identifying and Removing Duplicate Records in a Database Table.
Filtering a Database Table.Starting to Build a Presentation
Creating a Presentation.
Changing the Slide Size or Orientation.
Navigating the PowerPoint Window.
Add Content to a Slide.
Adding, Deleting, and Rearranging Slides.
Adding a Slide.
Deleting a Slide.
Rearranging Slides.
Using Views to Work on Your Presentation.
Creating Your Slides in Normal View.
Rearranging Your Slides in Slide Sorter View. Creating Notes Pages in Notes Page View.
Viewing a Presentation in Reading View.
Running a Presentation in Slide Show View.
Opening Extra Windows to See Different Parts of the Presentation.
Creating the Outline of a Presentation.
Organizing Your Slides into Sections.
Collaborating on a Presentation with Your Colleagues.
Editing a Presentation Simultaneously with Your Colleagues.
Comparing Two Copies of the Same Presentation.Creating Clear and Compelling Slides
Planning the Slides in Your Presentation.
Choosing Slide Layouts to Suit the Contents.
Using PowerPoint’s Built-in Slide Layouts.
Creating Custom Slide Layouts.
Formatting Text on Your Slides.
Changing the Font, Font Size, and Alignment.
Changing the Indentation and Line Spacing of Text.
Rotating Text.
Using Bulleted Lists.
Adding Tables, SmartArt, Charts, and Hyperlinks to Slides.
Adding Tables to Slides.
Adding SmartArt Graphics to Slides.
Adding Charts to Slides.
Adding Hyperlinks to Slides.Adding Life and Interest to a Presentation
Adding Pictures to a Presentation.
Creating a Photo Album. Adding Movies and Sounds to a Presentation.
Adding a Movie to a Slide.
Adding a YouTube Video to a Slide.
Adding a Sound to a Slide.
Adding Transitions to Slides.
Adding Animations to Slides.
Understanding the Essentials of Animations.
Adding an Animation to an Object.
Changing the Order of Animations.
Using Animation to Display Bulleted Paragraphs One at a Time.
Animating SmartArt Graphics, Charts, and Tables.
Keeping Extra Information Up Your Sleeve with Hidden Slides.
Creating Custom Slide Shows within a Presentation.
Opening the Custom Shows Dialog Box.
Creating a Custom Slide Show.
Playing a Custom Slide Show.
Editing or Deleting a Custom Slide Show.Delivering a Presentation Live or Online
Getting Ready to Deliver a Presentation in Person.
Setting Up Your Display and Choosing the Resolution.
Using Presenter View.
Practicing Your Presentation.
Rehearsing Timings for Slides.
Delivering a Presentation to a Live Audience.
Starting a Presentation.
Displaying the Slides You Need.
Annotating the Slides.
Controlling a Presentation Using the Keyboard. Displaying a White Screen or Black Screen.
Creating a Handout for a Presentation.
Recording Narration into a Presentation.
Exporting and Sharing a Presentation.
Broadcasting a Slide Show.
Publishing Slides to a Slide Library or a SharePoint Site.Making the Most of E-mail
Setting Up Outlook.
Changing the Default Settings for an E-mail Account.
Meeting the Outlook Interface.
Using the Ribbon.
Using and Customizing the Navigation Pane.
Using and Customizing the Message List and Reading Pane.
Using and Customizing the Reading Pane.
Using and Customizing the To-Do Bar.
Using and Customizing the People Pane.
Sending and Receiving Messages.
Sending an E-mail Message.
Receiving and Reading Messages.
Sending and Receiving Attachments.
Sending a File As an Attachment.
Receiving a File as an Attachment.
Replying to and Forwarding Messages.
Deleting, Storing, and Organizing Messages.
Moving a Message to a Mail Folder.
Creating a New Mail Folder.
Adding Consistent Closings to Your Messages with Signatures. Dealing with Spam.
Removing Non-Spam Messages from the Junk E-mail Folder.
Marking Spam Messages as Junk.Keeping Your Contacts in Order
Creating Contacts.
Creating a Contact from Scratch.
Importing Contacts from Other Address Books.
Mapping Custom Fields When Importing Contact Data.
Working with Contacts.
Viewing and Sorting Your Contacts.
Editing Contact Information.
Communicating with Your Contacts.Managing Your Calendar
Meeting the Calendar Interface.
Displaying the Dates You Want.
Customizing the Calendar Settings.
Understanding Appointments, Events and Meetings.
Understanding and Using the Calendar Views.
Creating Appointments and Events.
Creating One-Shot Appointments.
Creating Repeating Appointments.
Scheduling Meetings.
Setting Up a Meeting.
Tracking the Status of Meeting Invitations You’ve Sent.
Dealing with Invitations to Meetings.Working with Tasks and Notes.
Creating Tasks.
Meeting the Tasks Interface.
Viewing the Task List.
Creating One-Shot Tasks.
Creating Recurring Tasks.
Managing Your Tasks.
Assigning Tasks to Other People.
Dealing with Tasks Other People Send to You.
Taking Notes.
Meeting the Notes Interface.
Creating a Note.
Viewing and Using Your Notes.Taking Notes
Getting to Grips with the OneNote Interface.
Working with Notebooks, Section Groups, Sections, and Pages.
Working with Notebooks.
Working with Sections and Section Groups.
Working with Pages.
Entering Notes on a Page.
Understanding Which Types of Information You Can Save in OneNote.
Adding Text to a Page.
Adding Graphics to Pages.
Capturing Screen Clippings in Your Notebooks.
Creating Drawings on Pages.
Creating Tables.
Printing to OneNote.
Sending Outlook Items to OneNote.
Sending Web Content to OneNote. Inserting a Scanner Printout.
Performing Calculations.
Using Views, Windows, and Side Notes.
Using Normal View, Full Page View, and Dock to Desktop View.
Opening Extra Windows.
Working with Side Notes.Organizing, Synchronizing, and Sharing Your Notes
Organizing Your Pages, Sections, and Notebooks.
Moving Pages, Sections, and Section Groups.
Merging Sections Together.
Splitting a Section into Two.
Merging and Splitting Notebooks.
Changing the Display Name for a Notebook.
Searching for Information.
Protecting Your Notes with Passwords.
Unlocking a Password-Protected Section.
Locking Password-Protected Sections Manually.
Removing Password Protection from a Section of a Notebook.
Sharing Notebooks and Creating Shared Notebooks.
Creating a New Shared Notebook.
Sharing an Existing Notebook.
Opening a Shared Notebook.
Working in a Shared Notebook.
Reviewing Changes to a Notebook.
Choosing How to Update a Shared Notebook.
Using Different Versions of Pages.
Viewing or Recovering an Earlier Page Version.
Getting Rid of Old Page Versions to Save Space. Storing Notes on the Web.Making OneNote Work Your Way
Choosing Essential OneNote Options.
Choosing Display Options.
Choosing Save & Backup Options.
Choosing Send to OneNote Options.
Choosing Advanced Options.
Choosing Audio & Video Options.
Recording Audio and Video into Your Notebooks.
Recording Audio into a Notebook.
Recording Video into a Notebook.
Exporting or Removing an Audio or Video File.
Searching for Words in Audio and Video Recordings.
Printing Your Notebooks.
Using Print Preview.
Printing.
Using OneNote with the Other Office Programs.
Exporting a Page or Section to a Word Document.
Exporting Data to an Excel Worksheet or a PowerPoint Presentation.
Creating an Outlook Message from OneNote.
Creating an Outlook Task from OneNote.
Transferring a OneNote Notebook to Another PC.
Retrieving Material from the Notebook Recycle Bin.