Comprising of short, easy to follow lessons, this book shows the reader how to accomplish basic Office tasks quickly and efficiently.

Table of Contents:
Introduction. 1. Getting Started with Office. Starting Office Applications. Working with Menus. Using Shortcut Menus (the Right Mouse Button). Working with Toolbars. Switching Between Office Documents and Applications. Using the Task Pane. Exiting an Application. Getting Help. Finding Files. Setting Up Speech Recognition. Dictating Your Text and Data. Using Voice Commands. 2. Getting Started with Word. Entering and Inserting Text. Moving Around in Documents. Selecting Text. Moving Text. Saving a Document. Closing a Document. Creating a New Document. Opening a Document. Changing the Document View. Previewing a Document. Printing a Document. 3. Editing Documents. Cutting, Copying, and Pasting Text. Overwriting and Deleting Text. Undoing and Redoing Changes. Checking the Word Count. Finding Text. Replacing Text. Inserting a Picture from a File. Resizing and Moving Objects. Using AutoCorrect Options. Checking Spelling and Grammar. Researching with the Thesaurus. Sharing Documents with Others. Comparing Documents. Tracking Document Changes. Accepting or Rejecting Tracked Changes. 4. Formatting Text. Changing Text Font, Size, and Color. Applying Bold, Italic, and Underline. Applying Font Effects. Highlighting Text. Adding a Border to Text. Adding Shading to Text. Changing Text Alignment. Adding Numbers and Bullets. Indenting Paragraphs. Changing Line Spacing. Changing Character Spacing. Changing Capitalization. Inserting a Drop Cap. Setting Tab Stops with the Ruler. Copying Formatting. Clearing Formatting. 5. Formatting Documents. Inserting a Page Break. Inserting a Section Break. Adding Columns. Setting Page Margins. Centering Text on a Page. Inserting Page Numbers. Inserting a Header and Footer. Inserting Footnotes. Inserting Symbols. Inserting and Viewing Comments. 6. Advanced Document Formatting. Performing a Simple Mail Merge. Assigning a Style to Text. Inserting a Table of Contents. Creating a New Table. AutoFormatting a Table. Adding and Deleting Rows and Columns. Altering Row Height and Column Width. Deleting a Table. 7. Getting Started with Excel. Entering Data. Entering Repeat Cell Text. Selecting Cells. Selecting a Range of Cells. Automatically Filling a Series of Data. Renaming and Coloring Worksheet Tabs. Inserting and Deleting Worksheets. Moving or Copying Worksheets. Saving a Workbook. Closing a Workbook. Creating a New Workbook. Opening a Workbook. 8. Editing Worksheets. Inserting and Deleting Rows and Columns. Inserting Cells. Deleting Cells. Using Merge and Center on Cells. Cutting, Copying, and Pasting Data. Moving Data. Overwriting and Deleting Data. Inserting a Picture from a File. Undoing and Redoing Changes. Finding Data. Replacing Data. Adding and Viewing Cell Comments. Protecting and Sharing Workbooks. Tracking Changes. Accepting or Rejecting Tracked Changes. Checking Spelling. 9. Working with Data and Charts. Formatting the Display of Numeric Data. Performing Calculations with AutoSum. Entering a Formula. Copying a Formula. Entering a Function. Correcting Formula and Function Errors. Inserting Charts. Editing Charts with the Chart Toolbar. Using AutoCalculate. Sorting Data Lists. Freezing Rows and Columns. 10. Preparing for Printing Worksheets. Using Print Preview. Setting the Print Area. Setting Page Margins. Printing a Worksheet on One Page. Printing in Portrait or Landscape Orientation. Centering a Worksheet on a Page. Printing Gridlines and Row/Column Headers. Printing Headers and Footers. Printing Repeating Row and Column Titles. Printing Worksheets. 11. Formatting Worksheet Data. Changing the Font and Font Size. Changing Column Width. Wrapping Data in a Cell. Changing Row Height. Applying Bold, Italic, and Underline. Changing the Cell Background and Font Color. Changing Horizontal Data Alignment. Changing Vertical Data Alignment. Changing Cell Orientation. Changing Borders. Copying Formatting. Using AutoFormat. Using Conditional Formatting. 12. Getting Started with PowerPoint. Starting a Blank Presentation. Starting a Design Template Presentation. Starting a Presentation with the AutoContent Wizard. Editing AutoContent Slide Text. Inserting Slide Text. Saving a Presentation. Closing a Presentation. Opening a Presentation. Changing the Slide Text's Font. Applying Slide Text Effects. Altering Slide Text Alignment. Working with Numbered and Bulleted Lists. Adding and Deleting Slides. Duplicating Slides. Changing the Slide Layout. Changing the Slide Design. Changing the Slide Color Scheme. Spell Checking Slide Text. 13. Enhancing PowerPoint Presentations. Inserting a Table. Inserting a Chart. Inserting Clip Art. Inserting a Diagram or an Organizational Chart. Inserting a Picture from a File. Resizing or Moving Objects. Reordering Slides. Viewing a Slide Show. Adding Slide Transitions. Adding Animation Effects. Adding Action Buttons. Preparing the Presentation for Another Computer. Rehearsing a Presentation. Printing a Presentation. 14. Getting Started with Outlook. Moving Around in Outlook. Changing Your Email Preferences. Creating an Address Book Contact. Creating and Sending an Email Message. Checking For and Reading Email Messages. Saving Email Attachments. Replying to an Email Message. Forwarding an Email Message. Attaching Files to an Email Message. Deleting an Email Message. Finding an Email Message. Scheduling an Appointment. Scheduling a Meeting. Adding Tasks to a To-Do List. Creating Notes. Creating a Journal Entry. 15. Advanced Office and Web Features. Copying and Linking to Office Documents. Automating Repetitive Tasks with Macros. Saving Data to Use in Another Application (Exporting). Using Data from Another Application (Importing). Surfing the Web with the Web Toolbar. Saving a Web Page As a Text File. Saving Documents As Web Pages. Viewing Documents As Web Pages. Adding Email Address Links to Documents. Typing Web (URL) Links Directly into Documents. Inserting a Web (URL) Link Directly into a Document. Adding Document Links to Your Documents. Changing a Link's Default ScreenTip Text. Linking to the Web in a Document. Updating a Link. Removing a Link. Sending a Document As an Email Message. Sending a Document As an Email Attachment. Glossary. Index.