| |
| |
Introduction | |
| |
| |
| |
Introduction | |
| |
| |
| |
Essential Office Techniques | |
| |
| |
Starting New Documents | |
| |
| |
Saving Your Work | |
| |
| |
Opening Existing Documents | |
| |
| |
Working with Text | |
| |
| |
Working with Pictures and Other Objects | |
| |
| |
Working in Different Languages | |
| |
| |
Getting Help | |
| |
| |
| |
Office v. X and the Internet | |
| |
| |
Adding Links | |
| |
| |
Email | |
| |
| |
Other Internet Capabilities | |
| |
| |
| |
Microsoft Word | |
| |
| |
| |
Word Basics | |
| |
| |
Opening a Blank Document | |
| |
| |
The Word Window | |
| |
| |
Working with Text | |
| |
| |
Showing/Hiding Nonprinting Characters | |
| |
| |
Finding and Replacing Text | |
| |
| |
Using the Office Clipboard | |
| |
| |
Setting Margins | |
| |
| |
Aligning Paragraphs | |
| |
| |
Indenting Paragraphs | |
| |
| |
Setting Line Spacing | |
| |
| |
Setting Tabs | |
| |
| |
Creating Bulleted or Numbered Lists | |
| |
| |
Numbering Pages | |
| |
| |
Adding Headers and Footers | |
| |
| |
Checking Your Work | |
| |
| |
Calculating the Word Count | |
| |
| |
| |
Using Templates and Wizards | |
| |
| |
Using Templates | |
| |
| |
Saving a Document as a Template | |
| |
| |
Modifying an Existing Template | |
| |
| |
Using Wizards | |
| |
| |
| |
Document and Text Formatting | |
| |
| |
Changing Views | |
| |
| |
Changing the Paper Size and Orientation | |
| |
| |
Creating Multiple Sections | |
| |
| |
Inserting Page Breaks | |
| |
| |
Using Multiple Columns | |
| |
| |
Applying Borders and Shading | |
| |
| |
Applying a Style | |
| |
| |
Creating a Paragraph Style | |
| |
| |
Creating a Character Style | |
| |
| |
Using Click and Type | |
| |
| |
Automatically Entering Text | |
| |
| |
| |
Adding Graphics | |
| |
| |
Inserting Clip Art and Your Own Images | |
| |
| |
Drawing Lines | |
| |
| |
Creating Shapes | |
| |
| |
Adding Color, Shadows, and 3D Effects | |
| |
| |
Adding Text as an Object | |
| |
| |
Creating Artistic Text | |
| |
| |
| |
Creating Tables | |
| |
| |
Starting a Table | |
| |
| |
Entering Data | |
| |
| |
Building a Table from Scratch | |
| |
| |
Editing the Table Structure | |
| |
| |
Aligning Table Data | |
| |
| |
Working with Numeric Data | |
| |
| |
Deleting Cells | |
| |
| |
Merging and Splitting Cells | |
| |
| |
Adding Rows and Columns | |
| |
| |
Nesting Tables | |
| |
| |
Setting Borders and Cell Shading | |
| |
| |
Converting Text to a Table | |
| |
| |
| |
Creating Newsletters, Labels, and More | |
| |
| |
Using the Contact Toolbar | |
| |
| |
Creating Labels | |
| |
| |
Printing Envelopes | |
| |
| |
Creating Catalogs, Menus, and Newsletters | |
| |
| |
Using the Data Merge Manager | |
| |
| |
| |
Microsoft Excel | |
| |
| |
| |
Entering Information | |
| |
| |
Moving Around in a Worksheet | |
| |
| |
Typing Data into Cells | |
| |
| |
Adding Comments to Cells | |
| |
| |
Naming Ranges of Cells | |
| |
| |
Filling Ranges of Cells | |
| |
| |
Bringing In Data from Outside Excel | |
| |
| |
Editing Cells | |
| |
| |
| |
Working with Lists | |
| |
| |
Creating a List | |
| |
| |
Editing a List | |
| |
| |
Formatting a List | |
| |
| |
Filtering a List | |
| |
| |
Sorting a List | |
| |
| |
Validating Data in a List | |
| |
| |
| |
Entering Calculations | |
| |
| |
Formula Basics | |
| |
| |
Using Common Functions | |
| |
| |
Using the Formula Calculator | |
| |
| |
Copying Formulas | |
| |
| |
Auditing | |
| |
| |
| |
Making It Look Good | |
| |
| |
Changing the Size of Columns and Rows | |
| |
| |
Inserting and Deleting Columns and Rows | |
| |
| |
Inserting and Deleting Cells | |
| |
| |
Moving and Copying Data | |
| |
| |
Working with Large Sheets | |
| |
| |
Automatic Formatting | |
| |
| |
Conditional Formatting | |
| |
| |
Formatting Text | |
| |
| |
Formatting Numbers | |
| |
| |
Borders and Shading | |
| |
| |
Using Styles | |
| |
| |
| |
Using Multiple Worksheets | |
| |
| |
Switching Sheets | |
| |
| |
Viewing Multiple Sheets | |
| |
| |
Naming Sheets | |
| |
| |
Referring to Data from Other Sheets | |
| |
| |
Consolidating to a Sheet | |
| |
| |
| |
Analyzing Data | |
| |
| |
Reorganizing Data Using PivotTables | |
| |
| |
Goal Seeking | |
| |
| |
What-If Analysis | |
| |
| |
Answering Complex Questions with Solver | |
| |
| |
| |
Charts | |
| |
| |
Creating Charts | |
| |
| |
Modifying Charts | |
| |
| |
Adding Error Bars | |
| |
| |
Adding Trendlines | |
| |
| |
| |
Database Techniques | |
| |
| |
Setting Up a Database | |
| |
| |
Filling In the Form | |
| |
| |
Sorting and Filtering | |
| |
| |
Using Databases from Outside Excel | |
| |
| |
| |
Sharing Workbooks | |
| |
| |
Publishing Workbooks on the Web | |
| |
| |
Sharing Workbooks on a Network | |
| |
| |
Protecting Workbooks | |
| |
| |
Tracking and Reviewing Changes | |
| |
| |
| |
Microsoft PowerPoint | |
| |
| |
| |
Getting Started | |
| |
| |
Creating New Presentations | |
| |
| |
Using the AutoContent Wizard | |
| |
| |
Changing Views | |
| |
| |
Adding and Deleting Slides | |
| |
| |
Saving Presentations | |
| |
| |
| |
Creating Your Presentation | |
| |
| |
Adding Text to Slides | |
| |
| |
Working with Text Blocks | |
| |
| |
Adding Graphics to Slides | |
| |
| |
Drawing Objects | |
| |
| |
Creating a Common Graphic Background | |
| |
| |
Applying Background Color and Fill Effects | |
| |
| |
Changing the Color Scheme | |
| |
| |
Saving and Reusing a Custom Design | |
| |
| |
| |
Working with Charts and Graphs | |
| |
| |
Starting a Chart | |
| |
| |
Entering Your Own Data | |
| |
| |
Changing the Chart Type | |
| |
| |
Adding Legends to a Chart | |
| |
| |
Displaying Gridlines | |
| |
| |
Labeling Data Points | |
| |
| |
Specifying the Data Arrangement | |
| |
| |
Formatting a Chart Element | |
| |
| |
Cutting a Pie Chart | |
| |
| |
Creating Stock Charts | |
| |
| |
Working with 3D Charts | |
| |
| |
| |
Organization Charts and Tables | |
| |
| |
Adding an Organization Chart to a Slide | |
| |
| |
Adding People | |
| |
| |
Adding Subordinates | |
| |
| |
Adding Assistants | |
| |
| |
Formatting an Org Chart | |
| |
| |
More Org Chart Tips | |
| |
| |
Adding a Table to a Slide | |
| |
| |
| |
Preparing the Presentation for Viewing | |
| |
| |
Using the Slide Sorter | |
| |
| |
Adding Transition Effects | |
| |
| |
Adding Animation Within Slides | |
| |
| |
Adding Sound and Movies | |
| |
| |
Creating Handouts and Speaker Notes | |
| |
| |
Rehearsing a Presentation | |
| |
| |
Running a Slide Show | |
| |
| |
Publishing a Presentation on the Web | |
| |
| |
| |
Microsoft Entourage | |
| |
| |
| |
Email | |
| |
| |
Setting Up Your Account | |
| |
| |
Sending Mail and Files | |
| |
| |
Reading Mail | |
| |
| |
Replying to Mail | |
| |
| |
Forwarding and Redirecting Mail | |
| |
| |
Organizing Mail | |
| |
| |
Dealing with Junk Mail | |
| |
| |
Managing Mailing Lists | |
| |
| |
| |
Address Book | |
| |
| |
Adding Contacts | |
| |
| |
Deleting Contacts | |
| |
| |
Editing Contact Records | |
| |
| |
Using Electronic Business Cards (vCards) | |
| |
| |
Addressing Email from the Address Book | |
| |
| |
Using Directory Services | |
| |
| |
| |
Calendar | |
| |
| |
Viewing the Calendar | |
| |
| |
Adding and Deleting Events | |
| |
| |
Modifying Events | |
| |
| |
Sending and Responding to Event Invitations | |
| |
| |
Adding and Removing Holidays | |
| |
| |
| |
To-Do Lists (Tasks) | |
| |
| |
Viewing the Tasks List | |
| |
| |
Creating and Deleting Tasks | |
| |
| |
Editing Tasks | |
| |
| |
Recurring Tasks | |
| |
| |
Due Dates and Reminders | |
| |
| |
Marking Tasks Complete | |
| |
| |
| |
Notes | |
| |
| |
Viewing Notes | |
| |
| |
Creating and Deleting Notes | |
| |
| |
Editing Notes | |
| |
| |
| |
Internet Newsgroups | |
| |
| |
Creating a News-Server Account | |
| |
| |
Viewing Newsgroups | |
| |
| |
Updating the Newsgroup List | |
| |
| |
Filtering the Newsgroup List | |
| |
| |
Subscribing to Newsgroups | |
| |
| |
Managing Newsgroup Messages | |
| |
| |
Reading Messages | |
| |
| |
Posting to Newsgroups | |
| |
| |
Downloading Files from Newsgroups | |
| |
| |
| |
Combining the Applications | |
| |
| |
| |
Copying, Embedding, and Linking | |
| |
| |
Using Drag and Drop | |
| |
| |
Embedding an Object | |
| |
| |
Linking Objects | |
| |
| |
| |
Using Programs Together | |
| |
| |
Combining Word and Excel | |
| |
| |
Combining Word and PowerPoint | |
| |
| |
Copying Text from Word to Excel or PowerPoint | |
| |
| |
Combining Excel and PowerPoint | |
| |
| |
Linking Entourage Items | |
| |
| |
Index | |