Office 2010 Made Simple by Hart-Davis, Guy -- Read -- Imperial Library of Trantor

Index

Cover Title Page Copyright Contents at a Glance Contents About the Author About the Technical Reviewer Acknowledgments Part I

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

Part II

Introduction

Who Is This Book For? What Does This Book Cover? Conventions Used in This Book

Part III

Chapter 1: 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 Summary

Chapter 2: 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 Summary

Chapter 3: 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 Summary

Chapter 4: 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 Summary

Chapter 5: 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

Summary

Chapter 6: 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

Summary

Part IV

Chapter 7: 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 Summary

Chapter 8: 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

Summary

Chapter 9: 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

Summary

Chapter 10: 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

Summary

Part V

Chapter 11: 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

Summary

Chapter 12: 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

Summary

Chapter 13: 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

Summary

Chapter 14: 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

Summary

Chapter 15: 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

Summary

Part VI

Chapter 16: 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

Summary

Chapter 17: 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

Summary

Chapter 18: 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

Summary

Part VII

Chapter 19: 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 Summary

Chapter 20: 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

Summary

Chapter 21: 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 Summary

Chapter 22: 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

Summary

Part VIII

Chapter 23: 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

Summary

Chapter 24: 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

Summary

Chapter 25: 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

Summary

Chapter 26: 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

Summary

Index

← Prev
Back
Next →

← Prev
Back
Next →