Books & Videos

Table of Contents

  1. Using Office

    1. Chapter 1 Using Office 2013’s Common Features

      1. Opening an Office 2013 Program
      2. The Start Screen
      3. Working with the Ribbon
      4. Going Backstage
      5. Customizing Office Applications
  2. Word

    1. Chapter 2 Basic Word Processing

      1. First Things First: Word’s Start Page
      2. Creating a New Document
      3. Typing Some Text
      4. Saving a Document
      5. Closing a Document
      6. Opening an Existing Document
      7. Different Ways to View Your Work
    2. Chapter 3 Editing and Formatting

      1. Selecting and Moving Text
      2. Finding and Replacing Text
      3. Text Formatting: Font, Size, and Style
      4. Paragraph Formatting: Aligning, Indenting, Spacing
      5. Working with Lists
      6. Formatting a Document
    3. Chapter 4 Tables, Graphics, and Charts

      1. Creating a Table
      2. Adding Information to a Table
      3. Editing a Table
      4. Formatting a Table
      5. Inserting Images
      6. Editing an Image
      7. Fun with Fonts and Art That’s Smart
      8. Adding Charts and Diagrams
    4. Chapter 5 Proofing and Research Tools

      1. Checking Spelling and Grammar
      2. Getting Things Right with AutoCorrect
      3. Word’s Built-in Research Tools
    5. Chapter 6 Printing Documents

      1. Getting Started with Printing
      2. Selecting Print Options and Settings
      3. Sending a Fax
      4. Printing Envelopes
      5. Printing Labels
      6. Merging Names and Addresses with Documents
    6. Chapter 7 Reports and Long Documents

      1. Inserting Page Breaks
      2. Breaking a Document into Sections
      3. Footnotes and Endnotes
      4. Citations and Bibliographies
      5. Helping Readers Navigate Your Document
    7. Chapter 8 Customizing Documents with Themes, Templates, and Macros

      1. Themes: The Way to Better Designs
      2. Templates: Reusable Document Blueprints
      3. Saving Time with Macros
    8. Chapter 9 Desktop and Web Publishing

      1. Newsletters and Brochures
      2. Web Page Design
    9. Chapter 10 Sharing and Collaborating on Documents

      1. Sharing a Document
      2. Getting Feedback
      3. Comparing Documents
      4. Combining Documents
      5. Protecting Your Documents
      6. Coauthoring and Simultaneous Editing
  3. Outlook

    1. Chapter 11 Getting Started with Outlook

      1. Setting Up Outlook
      2. Taking a Quick Look Around
      3. Composing and Sending Email
      4. Receiving Email
      5. Printing a Message
      6. Fighting Spam
      7. Saving Time with Quick Steps
      8. Managing Multiple Email Accounts
    2. Chapter 12 Outlook’s Address Book

      1. Adding and Editing Contacts
      2. Finding a Contact
      3. Viewing Contacts
      4. Communicating with a Contact
      5. Gathering Contacts into a Group
      6. Printing Your Contacts
      7. Contacts and Social Networking
    3. Chapter 13 Getting Organized with Folders

      1. Finding Folders in the Navigation Pane
      2. Creating a New Folder
      3. Filling Up and Managing Folders
      4. Categorizing Items
      5. Searching Folders
      6. Cleaning Out Folders
    4. Chapter 14 Getting Organized with Outlook’s Calendar, Tasks, and Notes

      1. Your Schedule, Your Calendar
      2. Creating an Appointment or Meeting
      3. Editing Events
      4. Viewing Your Schedule
      5. Tasks
      6. Adding a Task
      7. Managing Tasks
      8. Viewing Tasks
      9. Taking Notes in Outlook
  4. Excel

    1. Chapter 15 Creating Your First Spreadsheet

      1. Starting a Workbook
      2. Adding Information to a Worksheet
      3. Using the Ribbon
      4. Using the Status Bar
      5. Saving Files
      6. Opening Files
      7. Adding Different Types of Data
      8. Printing
      9. Controlling Pagination
    2. Chapter 16 Moving Data

      1. Selecting Cells
      2. Moving Cells Around
      3. Adding and Moving Columns or Rows
      4. Worksheets and Workbooks
    3. Chapter 17 Formatting Cells

      1. Formatting Cell Values
      2. Formatting Cell Appearance
    4. Chapter 18 Building Basic Formulas

      1. Creating a Basic Formula
      2. Functions
      3. Formula Errors
      4. Logical Operators
      5. Formula Shortcuts
      6. Copying Formulas
    5. Chapter 19 Math and Statistical Functions

      1. Rounding Numbers
      2. Manipulating Text
      3. Solving Formula Errors
    6. Chapter 20 Creating Basic Charts

      1. Charting 101
      2. Basic Tasks with Charts
      3. Practical Charting
      4. Chart Types
      5. Chart Styles and Layouts
      6. Adding Chart Elements
  5. PowerPoint

    1. Chapter 21 Creating a Presentation

      1. Creating a New Presentation
      2. Saving a Presentation
      3. Opening an Existing Presentation
      4. Adding Notes
      5. Viewing a Presentation
      6. Printing a Presentation
    2. Chapter 22 Editing Slides

      1. Editing Text
      2. Embedding Other Files in Slides
      3. Adding Tables to Slides
      4. Adding Images to Slides
      5. Arranging Objects on a Slide
    3. Chapter 23 Editing a Presentation

      1. Copying, Rearranging, and Deleting Slides
      2. Headers and Footers
      3. Organizing Your Presentation with Sections
      4. Navigating with Links and Action Buttons
      5. Slide Masters: Powerful Slide Blueprints
      6. Collaborating with Others
    4. Chapter 24 Adding Multimedia and Movement

      1. Putting Media Clips in a Presentation
      2. Animating Objects
      3. Creating Transitions Between Slides
    5. Chapter 25 It’s Showtime! Giving a Presentation

      1. Start, Navigate, End: Tips and Shortcuts
      2. Before the Show: Prep Work
      3. At the Event
      4. Other Presentation Options
      5. Sharing Your Presentation
  6. Access

    1. Chapter 26 Creating Your First Database

      1. Understanding Access Databases
      2. Starting a Database
      3. Building Your First Table
      4. Saving Databases
      5. Opening Databases
      6. The Navigation Pane
    2. Chapter 27 Building Smarter Tables

      1. Understanding Data Types
      2. Design View
      3. Access Data Types
      4. The Primary Key
      5. Six Principles of Database Design
      6. Blocking Bad Data
      7. Data Integrity Basics
      8. Lookups
    3. Chapter 28 Mastering the Datasheet: Sorting, Searching, and Filtering

      1. Datasheet Customization
      2. Datasheet Navigation
      3. Printing the Datasheet
    4. Chapter 29 Linking Tables with Relationships

      1. Relationship Basics
      2. Using a Relationship
      3. More Exotic Relationships
  7. Other Office Tools

    1. Chapter 30 Publisher

      1. Creating a New Publication
      2. Adding Text
      3. Adding Pictures, Shapes, and Other Objects
      4. Designing and Laying Out Pages
      5. Reviewing Your Design
      6. Printing a Publication
    2. Chapter 31 OneNote

      1. What Is OneNote?
      2. Creating and Filling Up a Notebook
      3. Organizing a Notebook
      4. Managing Individual Notes
      5. Viewing Your Notebooks
      6. Sharing Notes
      7. Using OneNote with Other Office Programs
    3. Chapter 32 SkyDrive and Office Web Apps

      1. Introducing Office on the Web
      2. Setting Up Office Web Apps
      3. What’s New in Office Web Apps
      4. Creating and Editing Files
      5. Working with Folders in SkyDrive
      6. Managing Files in SkyDrive
      7. Sharing Files and Folders
      8. Docs.com: Office Web Apps for Facebook