Microsoft Office 2007 Simplified

Description

This work introduces readers to Office's first new interface since Office 97, and to this major revision's new capabilities, features, tools, enhanced collaboration features, and ability to save PDFs. It covers the following applications in the Microsoft Office suite such as: Word, Excel, PowerPoint, Outlook, Access, and Publisher. New Microsoft Office users will appreciate the easy to follow and nonintimidating approach that will help them get up and running with the application in a short time. The unique Visual format makes it even easier for readers to navigate topics with clear, step by step instructions in full color.

Author description

Sherry Willard Kinkoph has written and edited oodles of books over the past 10 years covering a variety of computer topics, including Microsoft Office programs. Her recent titles include Teach Yourself VISUALLY Photoshop Elements 3.0 and Office 2003 Simplified. Sherry's ongoing quest is to help users of all levels master ever-changing computer technologies. No matter how many times they - the software manufacturers and hardware conglomerates - throw out a new version or upgrade, Sherry vows to be there to make sense of it all and help computer users get the most out of their machines.

Table of contents

Part I: Office Features.1 Office Basics.Start and Exit Office Applications.Navigate the Program Windows.Work with the Ribbon.Customize the Quick Access Toolbar.Find Customizing Options.Turn Off Live Preview.Find Help with Office.Diagnose Office Programs.2 Working with Files.Start a New File.Save a File.Open an Existing File.Close a File.Print a File.Cut, Copy, and Paste Data.View Multiple Files.3 Office Internet and Graphics Tools.Create an HTML File.Add a Hyperlink.Draw AutoShapes.Insert Clip Art.View Clip Art with the Clip Organizer.Insert a Picture.Insert a WordArt Object.Move and Resize an Object.Rotate and Flip Objects.Crop a Picture.Arrange Objects.Control Text Wrapping.Recolor a Picture.Add SmartArt.Part II: Word.4 Adding Text.Change Word's Views.Type and Edit Text.Select Text.Move and Copy Text .Insert Quick Parts.Apply a Template.Insert Symbols.5 Formatting Text.Add Basic Formatting.Use the Mini Toolbar.Change the Font.Change the Font Size.Add Color to Text.Align Text.Set Line Spacing.Set Character Spacing.Apply Color Shading.Highlight Text.Copy Formatting.Clear Formatting.Indent Text.Set Tabs.Create Bulleted or Numbered Lists.Set Margins.Format with Styles.6 Working with Tables.Insert a Table.Insert a Quick Table.Draw a Table.Insert an Excel Spreadsheet.Select Table Cells.Adjust the Column Width or Row Height.Add Columns and Rows.Delete Columns or Rows.Merge Table Cells.Split Table Cells.Apply Table Styles.Change Cell Alignment.Reposition a Table.Resize a Table.7 Adding Extra TouchesAssign a Theme.Add Borders.Create Columns.Add Headers and Footers.Insert Comments.Insert Footnotes and Endnotes.Insert Page Numbers and Page Breaks.8 Reviewing and Printing Documents.Find and Replace Text.Check Spelling and Grammar.Work with AutoCorrect.Use the Thesaurus.Check Your Document for Hidden or Personal Data.Track and Review Document Changes.E-mail a Document.Change Paper Size.Print an Envelope.Part III: Excel.9 Building Spreadsheets.Enter Cell Data.Select Cells .Faster Data Entry with AutoFill.Add Columns and Rows.Delete Columns and Rows.Resize Columns and Rows.Turn On Text Wrapping.Center Data Across Columns.Freeze a Column or Row.Remove Data or Cells.10 Worksheet Basics.Assign Worksheet Names.Delete a Worksheet.Add a Worksheet.Move a Worksheet.Copy a Worksheet.Format the Worksheet Tab Color.Find and Replace Data.Sort Data.Filter Data with AutoFilter.Insert a Comment.Track and Review Workbook Changes.Change Page Setup Options.11 Working with Formulas and FunctionsUnderstanding Formulas.Create Formulas.Define a Range Name.Reference Ranges in Formulas.Reference Cells from Other Worksheets.Apply Absolute and Relative Cell References.Understanding Functions.Apply a Function.Total Cells with AutoSum.Audit a Worksheet for Errors.12 Formatting WorksheetsChange Number Formats.Change the Font and Size.Increase or Decrease Decimals.Change Data Color.Adjust the Cell Alignment.Control Data Orientation.Copy Cell Formatting.Add Borders.Format Data with Styles.Assign Conditional Formatting.13 Working with Charts.Create a Chart.Move and Resize Charts.Change the Chart Type.Change the Chart Style.Change the Chart Layout.Add Axis Titles.Format Chart Objects.Add Gridlines.Change the Chart Data.Part IV: PowerPoint.14 Presentation BasicsCreate a Presentation with a Template.Build a Blank Presentation.Change PowerPoint Views.15 Creating Slides.Add and Edit Slide Text.Change the Font and Size.Change the Text Color.Change the Text Style.Change the Text Alignment.Set Line Spacing.Assign a Theme.Change the Slide Layout.Add a New Text Object.Add Clip Art to a Slide.Add a Chart to a Slide.Add a Table to a Slide.Move a Slide Object.Resize a Slide Object.16 Assembling a Slide Show.Insert and Delete Slides.Reorganize Slides.Define Slide Transitions.Add Animation Effects.Insert a Media Clip.Record Narration.Set Up a Slide Show.17 Presenting a Slide Show.Rehearse a Slide Show.Run a Slide Show.Create Speaker Notes.Package Your Presentation on a CD.Part V: Access.18 Database Basics.Understanding Database Basics.Create a Blank Database.Create a Database Based on a Template.19 Adding Data Using Tables.Create a New Table.Create a Table with a Table Template.Change Table Views.Add a Field.Delete a Field.Hide a Field.Move a Field.Add a Record.Delete a Record.20 Adding Data Using Forms.Create a Form Using a Wizard.Create a Quick Form.Add a Record.Navigate Records.Delete a Record.Change Form Views.Move a Field.Delete a Field.Add a Field.Change the Field Formatting.Apply a Quick Format.21 Finding and Querying Data.Sort Records.Filter Records.Perform a Simple Query.Create a Report.Part VI: Outlook.22 Organizing with OutlookView Outlook Components.Schedule an Appointment.Schedule a Recurring Appointment.Schedule an Event.Plan a Meeting.Create a New Contact.Create a New Task.Add a Note.Organize Outlook Items.Perform an Instant Search.Customize the To-Do Bar.23 E-mailing with OutlookCompose and Send a Message.Read an Incoming Message.Control the Reading Pane.Reply to or Forward a Message.Add a Sender to Your Address Book.Delete a Message.Attach a File to a Message.Clean Up the Mailbox.Screen Junk E-mail.Create a Message Rule.Part VII: Publisher.24 Publisher Basics.Create a Publication.Create a Blank Publication.Zoom In and Out.Add Text.Add a New Text Box.Add a Picture to a Publication.Add Clip Art to a Publication.Fine-Tune a PublicationChange the Text Font and Size.Change the Text Style.Change Text Alignment.Change Text Color.Control Text Wrap.Add a Border.Move a Publication Object.Resize a Publication Object.Connect Text Boxes.Edit the Background Page.Add a Design Gallery Object.Use the Content Library.