You are previewing Office 2013 In Depth.
O'Reilly logo
Office 2013 In Depth

Book Description

Both an unparalleled reference and an exceptionally practical deskside resource, Office 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for Office 2013 users who wants to maximize their productivity.

¿

Renowned Office 2013 expert and college instructor Joe Habraken delivers specific, proven solutions through a task-based approach that introduces features within the context of how they are used in the real world. Throughout, Habraken illuminates the most valuable new features in Word, Excel, PowerPoint, Outlook, and Publisher.

¿

Straightforward and conversational, Office 2013 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out.


Packed with insights, techniques, tips, and shortcuts, it’s all you need to master all these programs: Word 2013, Excel 2013, PowerPoint 2013, Outlook 2013, Publisher 2013, and OneNote 2013!

¿

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. Dedication
  7. Acknowledgments
  8. We Want to Hear from You!
  9. Reader Services
  10. Introduction
    1. Who Should Buy This Book
    2. How This Book Is Organized
    3. Conventions Used in This Book
  11. Part I. Introduction to the Office 2013 Application Suite
    1. 1. Getting Oriented to the Office 2013 Applications
      1. Introducing Office 2013
      2. New Features and Tools in Office 2013
      3. The Office 2013 Suite Applications
      4. The Different Versions of the Office 2013 Suite
      5. Hardware and Software Requirements for Office 2013
      6. Installing Office 2013
      7. Getting Help in the Office Applications
    2. 2. Navigating and Customizing the Office Interface
      1. Getting Familiar with the Office Interface
      2. Navigating the Office Applications
      3. Customizing an Application Interface
      4. Configuring Application Options
      5. Adding Apps to the Office Applications
      6. Using the Trust Center
    3. 3. Managing and Sharing Office Files
      1. Understanding Office File Formats
      2. Configuring Save File Options
      3. Creating and Managing Files
      4. Searching for Office Files
      5. Sharing Files Using Homegroup
      6. Protecting an Office File
      7. Prepare a File for Sharing
    4. 4. Using and Creating Graphics
      1. The Office 2013 Options for Graphics and Pictures
      2. Working with Your Digital Pictures
      3. Inserting Online Pictures
      4. Using Shapes and the Office Drawing Tools
      5. Using the Screenshot Feature
      6. Using WordArt
    5. 5. Using the Office Web Apps
      1. What the Web Apps Can Do
      2. Where the Web Apps Live
      3. Saving Office Application Files to the Cloud
      4. Using the Word Web App
      5. Using the Excel Web App
      6. Using the PowerPoint Web App
      7. Using the OneNote Web App
  12. Part II. Word
    1. 6. Requisite Word: Essential Features
      1. Introducing Word 2013
      2. Options for Creating a New Word Document
      3. Using Templates
      4. Navigating a Word Document
      5. Moving Around a Document with the Keyboard
      6. Understanding Document Formatting
      7. Working with Fonts and Text Formatting
      8. Working with Paragraph Formatting
      9. Page Layout: Margins and Page Options
      10. Printing Documents
    2. 7. Enhancing Word Documents
      1. Creating Better Documents
      2. Creating Bulleted and Numbered Lists
      3. Working with Borders and Shading
      4. Formatting with Themes
      5. Creating Headers and Footers
      6. Inserting Pictures, Clip Art, and Charts
      7. Changing the Document Display
      8. Using the Review Tools
      9. Working with Quick Parts
      10. Configuring AutoCorrect
      11. Understanding Styles
    3. 8. Working with Tables, Columns, and Sections
      1. Options for Adding a Table
      2. Formatting Tables
      3. Sorting Table Data
      4. Using Formulas in Tables
      5. Adding Columns to a Document
      6. Understanding Sections
    4. 9. Managing Mailings and Forms
      1. Options for Mail-Related Documents
      2. Creating an Envelope
      3. Creating a Label or Labels
      4. Understanding Word’s Options for Mass Mailings
      5. Performing a Mail Merge
      6. Understanding Word Fields
      7. Building a Form with Form Controls
    5. 10. Creating Special Documents
      1. Options for Large Documents
      2. Creating a Table of Contents
      3. Working with Captions and Tables of Figures
      4. Using Cross-References
      5. Generating an Index
      6. Working with Citations and Bibliographies
      7. Inserting Footnotes and Endnotes
      8. Tracking Document Changes
      9. Building a Better “Big” Document
      10. Creating a Master Document
  13. Part III. Excel
    1. 11. Requisite Excel: Essential Features
      1. Introducing Excel 2013
      2. Navigating the Excel Workspace
      3. Creating Workbooks and Worksheets
      4. Managing Excel Workbooks
      5. Entering Data in a Worksheet
      6. Filling and Entering Series
      7. Copying, Moving, and Deleting Cell Contents
      8. Editing Cell Content
      9. Viewing Worksheets
      10. Printing Worksheets
    2. 12. Worksheet Formatting and Management
      1. Formatting Text Entries
      2. Formatting Values
      3. Adding Comments to Cells
      4. Using Themes
      5. Formatting Cells Using Borders and Color
      6. Using Cell Styles and the Format Painter
      7. Using Conditional Formatting
      8. Manipulating Cells and Cell Content
      9. Working with Columns and Rows
      10. Working with Worksheets
      11. Naming Ranges
      12. Adding Images and Graphics to Worksheets
    3. 13. Getting the Most from Formulas and Functions
      1. Performing Calculations in Excel Worksheets
      2. Relative Versus Absolute Referencing
      3. Creating and Editing Formulas
      4. Working with Excel Functions
      5. Entering a Function in a Cell
      6. Using Range Names in Formulas and Functions
      7. Referencing Cells or Ranges on Other Worksheets
      8. Copying and Moving Formulas and Functions
      9. Choosing the Right Function
      10. Proofing Your Formulas and Functions
    4. 14. Enhancing Worksheets with Charts
      1. Understanding Excel Charts
      2. Creating Charts
      3. Modifying a Chart
      4. Working with Chart Elements
      5. Creating a Combination Chart
    5. 15. Using Excel Tables and PivotTables
      1. Excel and Databases
      2. Defining a Table Range
      3. Creating a Table Using Styles
      4. Sorting Table Data
      5. Filtering Table Data
      6. Using the Data Form
      7. Creating Outlines and Subtotals
      8. Working with External Data
      9. Working with PivotTables
    6. 16. Validating and Analyzing Worksheet Data
      1. Taking Advantage of Data Validation
      2. Performing a What-If Analysis
      3. Using Goal Seek and Solver
  14. Part IV. PowerPoint
    1. 17. Requisite PowerPoint: Essential Features
      1. New Features in PowerPoint 2013
      2. Options for Creating a New Presentation
      3. Creating a Template
      4. Inserting New Slides
      5. Modifying a Slide’s Layout
      6. Working with Slides in Different Views
      7. Opening a New Presentation Window
      8. Rearranging and Deleting Slides
      9. Modifying Bulleted Lists
      10. Using Numbered Lists
      11. Viewing a Presentation During Editing
    2. 18. Advanced Presentation Formatting, Themes, and Masters
      1. Working with Text Boxes and Formatting
      2. Arranging Text in Tables
      3. Working with Themes
      4. Using Headers and Footers
      5. Understanding Masters
      6. Altering and Creating Master Slides
      7. Creating Layout Masters
      8. Using Slide Sections
    3. 19. Better Slides with Clip Art, Pictures, and SmartArt
      1. Using Graphics to Enhance Slides
      2. Inserting a Picture
      3. Adding Online Images to Slides
      4. Creating a Photo Album
      5. Working with Shapes
      6. Using SmartArt Graphics
      7. Adding Charts to Slides
      8. Working with Slide Objects
      9. Adding Hyperlinks to Slides
    4. 20. Enhancing Slides with Animation, Transitions, and Multimedia
      1. Animations Versus Transitions
      2. Assigning Animation to a Slide Object
      3. Advanced Animation Techniques
      4. Managing Slide Animations
      5. Adding Transitions to Slides
      6. Modifying Transitions
      7. Adding Sound to a Slide
      8. Editing Sound Options
      9. Adding Video to a Slide
    5. 21. Delivering a Presentation and Creating Support Materials
      1. Planning Your Presentation
      2. Checking the Presentation for Spelling and Grammar Errors
      3. Running Through a Completed Presentation
      4. Using the Presenter View
      5. Using Hidden Slides
      6. Creating a Custom Slide Show
      7. Creating a Self-Running Presentation
      8. Creating an Interactive Presentation
      9. Presenting a Slide Show Online
      10. Working with the Notes and Handouts Masters
      11. Printing Presentations, Notes, and Handouts
      12. Exporting a Presentation
      13. Sharing Your Presentation
  15. Part V. Outlook
    1. 22. Requisite Outlook: Configuration and Essential Features
      1. Introducing Outlook 2013
      2. Outlook and Email Accounts
      3. Configuring Outlook at First Start
      4. Understanding Outlook Profiles
      5. Understanding Outlook Data Files
      6. Importing and Exporting Data
      7. Navigating the Outlook Workspace
      8. Working with Views in Outlook
      9. Categorizing Outlook Items
      10. Searching for Outlook Items
      11. Printing Outlook Items
    2. 23. Managing Email in Outlook
      1. Working in the Mail Folder
      2. Creating an Email Message
      3. Using the Outlook Address Book
      4. Setting Message Options
      5. Attaching Files and Items to a Message
      6. Using Themes and Email Stationery
      7. Adding a Signature
      8. Sending Mail
      9. Recalling a Message
      10. Working with Received Email
      11. Managing Email
      12. Managing Email Accounts
      13. Setting Outlook Mail Options
    3. 24. Using the Calendar for Appointments and Tasks
      1. Navigating the Calendar
      2. Scheduling an Appointment
      3. Searching the Calendar
      4. Sharing Calendars
      5. Setting Calendar Options
      6. Working with Tasks
    4. 25. Working with Contacts and Planning Meetings
      1. Navigating the Contacts List
      2. Creating a New Contact
      3. Editing Contact Information
      4. Searching the Contacts Folder
      5. Organizing Contacts with Groups
      6. Forwarding and Sharing Contacts
      7. Accessing Contacts on Social Networks
      8. Communicating with Contacts
      9. Contact Actions
      10. Printing Contact Information
      11. Setting Contact Options
      12. Scheduling Meetings
      13. Responding to Meeting Requests
    5. 26. Using the Journal and Notes
      1. Using the Outlook Journal
      2. Viewing the Journal
      3. Working with Notes
      4. Viewing and Managing Notes
      5. Creating Appointments and Tasks from Notes
    6. 27. Securing and Maintaining Outlook
      1. Security Overview
      2. Configuring Outlook Security Settings
      3. Encrypting Email and Using Digital Signatures
      4. The Perils of HTML Email
      5. Dealing with Message Attachments
      6. Coping with Junk Email
      7. Creating Email Rules
      8. Managing Rules
      9. Archiving Outlook Items
      10. Configuring an Autoreply Message
  16. Part VI. Publisher
    1. 28. Requisite Publisher: Essential Features
      1. Introducing Publisher 2013
      2. Planning Your Publication
      3. Working with Publication Templates
      4. Creating a New Publication
      5. Creating a Business Information Set
      6. Working with Text
      7. Inserting Illustrations
      8. Using Building Blocks
      9. Printing Publications
    2. 29. Advanced Publisher Features
      1. Adding Pages to a Publication
      2. Configuring Page Settings
      3. Changing the Current Template
      4. Working with Master Pages
      5. Using Tables in Publications
      6. Manipulating Publication Objects
      7. Merging Data into a Publication
      8. Fine-Tuning Your Publications
  17. Part VII. OneNote
    1. 30. Requisite OneNote: Essential Features
      1. Introducing OneNote
      2. Navigating the OneNote Workspace
      3. Creating a Notebook
      4. Modifying Notebook Properties
      5. Working with Sections
      6. Working with Pages
      7. Restoring Sections and Pages from the Notebook Recycle Bin
      8. Inserting and Formatting Notes
      9. Using Tags
      10. Finding Tagged Notes
      11. Using Tables to Store Information
    2. 31. Working with Notebook Pages
      1. Managing Pages
      2. Modifying the Page Setup and View
      3. Viewing Page Versions
      4. Viewing Recent Edits
      5. Viewing Changes by Author
      6. Adding Objects to Notebook Pages
      7. Printing Notebook Pages
    3. 32. Integrating OneNote with Other Office Applications
      1. Taking Linked Notes
      2. Using File Printout
      3. Adding Links
      4. Attaching Files
      5. Inserting Screen Clips
      6. Integrating OneNote and Outlook
  18. Part VIII. Appendixes
    1. A. Office Application Integration
      1. Sharing Application Data
      2. Understanding Object Linking and Embedding
      3. Linking Objects
      4. Updating and Breaking Links
      5. Editing Embedded Objects
      6. Sharing Data with Outlook Using Actions
    2. B. Office Macros
      1. Macros and Office 2013
      2. Understanding Macros
      3. Creating a Macro
      4. Running Macros
      5. Editing Recorded Macros
      6. Digitally Signing Macros
  19. Index
  20. Ad Page