Hart-Davis G. Office 2010 Made Simple

Apress, 2011. - 704 p. - ISBN: 978-1-4302-3575-0Office 2010 Made Simple for Windows is a practical and highly effective approach to using the Office 2010 Home & Business (Word, Excel, PowerPoint, Outlook, OneNote) and Home & Student (Word, Excel, PowerPoint, OneNote) programs to create and edit documents and get work done efficiently. Conveying information quickly and concisely, the book brings you from a beginner or low intermediate to an experienced and confident user.Illustrated graphical approach shows what happens at each stage
Short sections provide instant access to each task the reader needs to perform
Step-by-step instructions help the reader grasp even complex procedures in full confidenceWhat you’ll learn
Master the Ribbon interface and become expert with keyboard shortcuts
Capture every important piece of information—and find it when you need it
Create attractive documents and powerful presentations
Process incoming mail automatically and keep your Inbox under control
Organize your work life with Outlook’s appointments and tasks
Record and analyze your business data in simple databasesAbout the Author.
About the Technical Reviewer.Quick Start Guide.
Logging On to Windows.
Locating the Office Programs and Launching Word.
Meeting the Major Components of the Word Window.
Closing a Document.
Creating and Saving a New Document.
Closing Word.
Where to Learn More.Who Is This Book For?
What Does This Book Cover?
Conventions Used in This Book.Meeting the Office Programs and Learning What They Do.
Understanding the Office Programs.
Launching a Program.
Identifying the Standard Components of the Office Program Windows.
Creating, Saving, Closing, and Reopening Files.
Creating a File.
Saving a File for the First Time.
Closing a File.
Reopening a File You’ve Used Recently.
Opening a File You Haven’t Used Recently.
Closing a Program.Using the Ribbon, Backstage, and Common Tools.
Using the Ribbon.
Understanding the Ribbon’s Tabs, Groups, and Controls.
Giving Commands Using the Ribbon.
Minimizing the Ribbon.
Giving Ribbon Commands Using the Keyboard.
Using Backstage View.
Entering Text Faster Using AutoCorrect.
Understanding How AutoCorrect Works.
Opening the AutoCorrect Dialog Box.
Creating an AutoCorrect Entry.
Setting AutoCorrect to Work Your Way.
Choosing AutoFormat Settings in Word and Outlook.
Adding Actions to the Context Menu.
Closing the AutoCorrect Dialog Box.
Checking Spelling and Grammar in Your Files.
Checking Spelling.
Checking Grammar in Word and Outlook.
Controlling How the Spelling Checker Works.
Printing Your Documents.Working with Text.
Entering Text in Your Documents.
Entering Text Using the Keyboard.
Entering Text Using Copy and Paste.
Entering Text Using Optical Character Recognition.
Inserting Symbols in Your Documents.
Navigating with the Keyboard and Selecting Document Objects.
Applying Direct Formatting to Text and Objects.
Using Cut, Copy, and Paste.
Using Standard Cut, Copy, and Paste in the Office Programs.
Cutting, Copying, Pasting with the Office Clipboard.
Pasting Exactly What You Want with Paste Options.
Using Find and Replace.
Locating Text with Find.
Replacing Text with Replace.
Laying Out Material with Tables.
Inserting a Table.
Drawing a Table.
Merging and Splitting Cells in a Table.
Adding Content to a Table.
Formatting a Table.
Inserting Hyperlinks in Your Documents.Using Graphics in Your Documents.
Understanding How You Position Graphical Objects in Documents.
Illustrating Your Documents with Clip Art Items.
Inserting a Clip Art Item in a Document.
Adding a Clip Art Item to a Collection.
Previewing a Clip Art Item.
Examining and Adding Keywords.
Inserting Other Pictures in Your Documents.
Inserting Shapes in Your Documents.
Positioning Graphical Objects.
Wrapping Text Around Graphical Objects in Word and Outlook.
Making Your Pictures Look the Way You Want Them.
Adjusting a Picture’s Sharpness, Brightness, Contrast, and Colors.
Applying a Picture Style to Give a Particular Look.
Cropping a Picture.
Creating Illustrations by Inserting SmartArt Graphics.
Arranging Graphical Objects to Control Which Are Visible.Coauthoring in Real Time and Sharing Documents.
Working on Documents with Your Colleagues.
Coauthoring in Real Time.
Preparing a Document for Coauthoring.
Opening a Document for Coauthoring.
Editing a Document During Coauthoring.
Saving Your Changes and Getting Others’ Saved Changes.
Resolve Conflicts During Coauthoring.
Sharing Documents on a Network.
Working on Separate Copies of the Same Document.
Sharing Documents via E-mail, SkyDrive, and Electronic Documents.
Sending a Document via E-mail.
Sending a Document to the Web.
Sharing a Document as a PDF or XPS File.Making the Office Programs Work Your Way.
Customizing the Quick Access Toolbar.
Using the Customize Quick Access Toolbar Menu.
Adding Commands to the Quick Access Toolbar from the Ribbon.
Customizing the Quick Access Toolbar Using the Options Dialog Box.
Remove a Button from the Quick Access Toolbar.
Resetting the Quick Access Toolbar to Its Default Buttons.
Customizing the Status Bar.
Customizing the Ribbon.
Opening the Customize Ribbon Pane in the Options Dialog Box.
Choosing the Tab You Want to Affect.
Creating a New Group.
Adding Commands to a New Group.
Moving an Existing Group.
Moving an Existing Tab.
Resetting the Ribbon to Its Default Settings.
Sharing Quick Access Toolbar and Ribbon Customizations with Other PCs.
Creating Custom Keyboard Shortcuts in Word.
Setting Essential Options.
Opening the Options dialog box.
Choosing General Options.
Choosing Save Options in Word, Excel, and PowerPoint.Entering and Editing Text in Your Documents.
Creating and Saving a New Document.
Entering Text in Your Word Documents.
Inserting the Contents of a File in a Document.
Inserting Preexisting Blocks of Text with AutoText.
Creating Formatted AutoCorrect Entries.
Selecting Text and Navigating Through Your Documents.
Selecting Text Quickly with the Mouse.
Moving with Keyboard Shortcuts.
Moving with the Browse Object Panel.
Learning the Secrets of the Vertical Scroll Bar.
Creating Your Own Templates.
Creating a Template.
Telling Word Where to Find Your Templates.
Setting Word to Create Backup Documents Automatically.
Working the Smart Way by Using Views and Windows.
Choosing the Best View for Your Writing or Editing Tasks.
Opening Extra Windows to See More of the Same Document.
Splitting the Document Window into Two Panes.
Navigating Your Documents Quickly with the Navigation Pane.Formatting Your Documents Easily and Efficiently.
Why You Should Use Styles Rather Than Direct Formatting.
Applying Styles to a Document.
Changing to a Different Set of Quick Styles.
Changing the Colors, Fonts, or Paragraph Spacing.
Putting the Styles You Need in the Quick Styles Gallery.
Applying Styles Using the Apply Styles Pane.
Applying Styles Using Keyboard Shortcuts.
Using the Style Area to See Which Styles the Paragraphs Use.
Managing Styles with the Styles Pane and the Manage Styles Dialog Box.
Managing Styles with 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.Adding Headers, Footers, Tables, and Columns.
Using Sections to Create Complex Layouts.
Adding Headers, Footers, and Page Numbers.
Adding Headers and Footers to a Document.
Adding Page Numbers to a Document.
Adding Tables to Your Documents.
Converting Existing Text to a Table.
Nesting One Table Inside Another Table.
Converting a Table to Text.
Creating Newspaper-Style Columns of Text.
Breaking Your Columns with Column Breaks.
Removing Multiple Columns from a Section or Document.Revising, Finalizing, and Printing Your Documents.
Revising a Document.
Tracking Revisions with the Track Changes Feature.
Working with Comments.
Comparing or Combining Different Versions of the Same Document.
Finalizing a Document.
Removing Sensitive Information from a Document.
Marking a Document as Final.
Encrypting a Document with a Password.
Signing a Final Document with a Digital Signature.
Printing Your Documents.
Printing a Custom Range of Pages.
Choosing Whether to Print Markup—Or Only Markup.
Printing Document Properties, Styles, AutoText Entries, and Key Assignments.Creating Workbooks and Entering Data.
Creating and Saving a New Workbook.
Navigating the Excel Interface, Worksheets, and Workbooks.
Understanding Workbooks, Worksheets, Columns, and Rows.
Moving the Active Cell.
Selecting a Range of Cells.
Entering Data in Your Worksheets.
Typing Data in a Cell.
Editing a Cell.
Entering Data Quickly Using AutoFill.
Pasting Data into a Worksheet with Paste, Paste Options, and Paste Special.
Copying and Moving Data with Drag and Drop.
Inserting, Renaming, Deleting, and Rearranging Worksheets.
Inserting a Worksheet.
Renaming a Worksheet.
Deleting a Worksheet.
Rearranging the Worksheets in a Workbook.
Displaying Worksheets the Way You Prefer to See Them.
Using Excel’s Views Effectively.
Viewing Two or Four Separate Parts of a Worksheet at the Same Time.
Opening Extra Windows to Show Other Parts of a Workbook.
Zooming In or Out to Show the Data You Need to See.
Comparing Two Windows Side by Side.
Freezing Rows and Columns So That They Stay on Screen.
Sharing Your Workbooks and Tracking Changes.
Tracking Changes to a Workbook.
Sharing a Workbook So That Your Colleagues Can Edit It.
Working in a Shared Workbook.
Reviewing Tracked Changes in a Shared Workbook.Editing Worksheets and Applying Formatting.
Working with Rows and Columns.
Inserting and Deleting Columns, Rows, and Cells.
Inserting Columns and Rows.
Deleting Columns and Rows.
Inserting Cells.
Deleting Cells.
Setting Row Height.
Setting Column Width.
Hiding Rows and Columns.
Formatting Cells and Ranges.
Meeting the Three Main Tools for Applying Formatting.
Setting the Workbook’s Overall Look by Applying a Theme.
Controlling How Data Appears by Applying Number Formatting.
Setting Alignment.
Choosing Font Formatting.
Applying Borders and Fills.
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.Performing Calculations with Formulas and Functions.
Understanding the Difference Between Formulas and Functions.
Referring to Cells and Ranges in Formulas and Functions.
Referring to a Cell or Range on the Same Worksheet.
Referring to a Cell or Range on a Different Worksheet.
Referring to a Cell or Range in a Different Workbook.
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 Charts to Present Your Data.
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 Using the Chart Category Buttons.
Creating a Chart Using the Insert Chart Dialog Box.
Resizing or Repositioning an Embedded Chart.
Changing a Chart from an Embedded Chart to a Chart Sheet.
Switching the Rows and Columns in a Chart.
Changing the Source Data for a Chart.
Choosing the Layout for the 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 Data Labels to the Chart.
Choosing Which Gridlines to Display.
Formatting the Chart Wall and Chart Floor.
Formatting Individual Chart Elements.Creating Databases and Solving Business Problems.
Creating Databases.
Understanding the Type of Databases You Can Create in Excel.
Creating a Database and Entering Data.
Entering Data in a Database.
Resizing a Database.
Sorting a Database by One or More Fields.
Sorting Quickly by a Single Field.
Sorting a Database by Multiple Fields.
Filtering a Database.
Solving Business Problems with Scenarios and Goal Seek.
Examining Different Scenarios in a Worksheet.
Using Goal Seek.Getting Up to Speed and Taking Notes.
Meeting the OneNote User Interface.
Launching OneNote and Creating Your First Notebook.
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.
Adding Text to a Page.
Adding Graphics to Pages.
Capturing Screen Clippings in Your Notebooks.
Creating Drawings on Pages.
Creating Tables.
Sending Printouts 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.Searching, Protecting, and Synchronizing Your Notes.
Searching for Information in Your Notebooks.
Protecting Your Notes with Passwords.
Unlocking a Password-Protected Section to Work in It.
Locking Password-Protected Sections Manually.
Removing Password Protection from a Section of a Notebook.
Sharing an Existing Notebook.
Opening a Shared 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.Customizing OneNote and Using It with Word, Excel, PowerPoint, and Outlook.
Choosing the Most Important Options for OneNote.
Choosing Display Options.
Choosing Save & Backup Options.
Choosing Send to OneNote Options.
Choosing Audio & Video Options.
Choosing Advanced 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.
Previewing and Printing Your Notebook Pages.
Previewing a Notebook Page.
Printing Notebook Pages.
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.
When Creating an Outlook Task from OneNote.
Retrieving Material from the Notebook Recycle Bin.Starting a Presentation.
Creating a Presentation.
Changing the Presentation’s Theme, Colors, Fonts, and Effects.
Changing the Slide Size or Orientation.
Navigating the PowerPoint Window.
Adding, Deleting, and Rearranging Slides.
Adding a Slide.
Deleting a Slide.
Rearranging Slides.
Add Content to a Slide.
Using Views to Work on Your Presentation.
Creating Your Slides in Normal View.
Rearranging Your Slides in Slide Sorter 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.Building Effective Slides for Your Presentation.
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 Effectively in Your Slides.
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.Giving a Presentation Life and Impact.
Adding Pictures to a Presentation.
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.
PowerPoint’s Three Types of Transitions.
Applying a Transition to a Slide.
Choosing Options for a Transition.
Adding a Sound to the Transition.
Changing the Duration of the Transition.
Choosing How to Advance to the Next Slide.
Adding Animations to Slides.
PowerPoint’s Four Categories 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 and Charts.
Keeping Extra Information Up Your Sleeve with Hidden Slides.Delivering a Presentation in Person or Online.
Preparing to Deliver a Presentation in Person.
Setting Up Your Display and Choosing the Resolution.
Choosing the Presentation Display and Turning on Presenter View.
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.
Checking That Your Microphone Is Working.
Starting to Record Narration.
Checking Your Narration and Rerecording if Necessary.
Exporting and Sharing a Presentation.
Broadcasting a Slide Show.
Publishing Slides to a Slide Library or a SharePoint Site.Setting Up Outlook and Meeting the Interface.
Set Up Your E-mail Accounts in Outlook.
Changing the Default Settings for an E-mail Account.
Meeting the Outlook Interface.
Using and Customizing the Navigation Pane.
Using and Customizing the Message List.
Using and Customizing the Reading Pane.
Using and Customizing the To-Do Bar.
Using and Customizing the People Pane.
Using the Ribbon.Sending and Receiving E-mail.
Sending an E-mail Message.
Creating a New Message.
Choosing Which Account to Send the Message From.
Addressing the Message.
Adding the Subject Line and Message Contents.
Choosing Options for a Message.
Checking the Spelling in a Message.
Sending the 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.
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.Managing Your Contacts with Outlook.
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.Organizing Your Schedule, Tasks, and Notes.
Organizing Your Schedule with the Calendar.
Displaying the Dates You Want to Work With.
Understanding Appointments, Events, and Meetings.
Understanding and Using the Calendar Views.
Creating Appointments and Events.
Scheduling Meetings.
Working with Tasks.
Meeting the Tasks Interface.
Viewing the Task List.
Creating a One-Shot Task by Working in the Task List.
Creating a One-Shot Task Using a Task Window.
Creating Recurring Tasks.
Adding Details to a Task.
Marking a Task for Follow-Up.
Sending a Status Report on a Task.
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.