Office 2013: The Missing Manual Nancy Conner, Matthew MacDonald

Office 2013: The Missing Manual Nancy Conner, Matthew MacDonald - okladka książki

Autorzy:: Nancy Conner, Matthew MacDonald
Wydawnictwo:: O'Reilly Media (Z chęcią przeczytam książkę w języku polskim)
Ocena:: Bądź pierwszym, który oceni tę książkę
Stron:: 1050
Dostępne formaty:: ePub

Mobi

Ebook

118,15 zł ~~139,00 zł~~ (-15%)

29,90 zł najniższa cena z 30 dni

Dodaj do koszyka lub Kup na prezent Kup 1-kliknięciem

Poleć tę książkę znajomemu Poleć tę książkę znajomemu!!

Przenieś na półkę

Do przechowalni

Zostało Ci na świąteczne zamówienie

opcje wysyłki »

Microsoft Office is the most widely used productivity software in the world, but most people just know the basics. This helpful guide gets you started with the programs in Office 2013, and provides lots of power-user tips and tricks when you’re ready for more. You’ll learn about Office’s new templates and themes, touchscreen features, and other advances, including Excel’s Quick Analysis tool.

The important stuff you need to know:

Create professional-looking documents. Use Word to craft reports, newsletters, and brochures for the Web and desktop.
Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks.
Work faster with Excel. Determine the best way to present your data with the new Quick Analysis tool.
Make inspiring presentations. Build PowerPoint slideshows with video and audio clips, charts and graphs, and animations.
Share your Access database. Design a custom database and let other people view it in their web browsers.
Get to know the whole suite. Use other handy Office tools: Publisher, OneNote, and a full range of Office Web Apps.
Create and share documents in the cloud. Upload and work with your Office files in Microsoft’s SkyDrive.

Wybrane bestsellery

Nancy Conner, Matthew MacDonald - pozostałe książki

Ebooka "Office 2013: The Missing Manual" przeczytasz na:

czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
systemach Windows, MacOS i innych

systemach Windows, Android, iOS, HarmonyOS
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi

Masz pytania? Zajrzyj do zakładki Pomoc »

Oceny i opinie klientów: Office 2013: The Missing Manual Nancy Conner, Matthew MacDonald

(0)

Szczegóły książki

ISBN Ebooka:: 978-14-493-5942-3, 9781449359423
Data wydania ebooka :: 2013-05-22 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
Język publikacji:: angielski
Rozmiar pliku ePub:: 29.4MB
Rozmiar pliku Mobi:: 29.4MB

Zgłoś erratę

Kategorie

Kliknij, aby zgłosić błędnie przypisaną kategorię »

Informatyka » Aplikacje biurowe » MS Office

Dostępność produktu

Produkt nie został jeszcze oceniony pod kątem ułatwień dostępu lub nie podano żadnych informacji o ułatwieniach dostępu lub są one niewystarczające. Prawdopodobnie Wydawca/Dostawca jeszcze nie umożliwił dokonania walidacji produktu lub nie przekazał odpowiednich informacji na temat jego dostępności.

Spis treści książki

Office 2013: The Missing Manual
A Note Regarding Supplemental Files
The Missing Credits
- About the Authors
- About the Creative Team
- Acknowledgements
- The Missing Manual Series
Introduction
- What Is Office 2013?
- Flavors of Office 2013
  - Office 2013
  - Office 365
- Whats New in Office 2013
- About This Book
- The Very Basics
  - AboutTheseArrows
- About the Online Resources
  - Missing CD
  - Registration
  - Feedback
  - Errata
- Safari Books Online
1. Using Office
- 1. Using Office 2013s Common Features
  - Opening an Office 2013 Program
  - The Start Screen
  - Working with the Ribbon
    - Using Ribbon-Based Keyboard Shortcuts
  - Going Backstage
    - Saving a File
    - Finding and Opening a Saved File
    - Closing a File or Program
  - Customizing Office Applications
    - Changing the Look of Office
    - Customizing the Quick Access Toolbar
    - Customizing the Ribbon
    - Customizing the Status Bar
2. Word
- 2. Basic Word Processing
  - First Things First: Words Start Page
    - The Word 2013 Window
  - Creating a New Document
    - Creating a New Blank Document
    - Creating a New Document from a Template
    - Creating a New Document from an Existing Document
  - Typing Some Text
  - Saving a Document
    - Saving a Document Using Your Mouse
    - Saving a Document Using Keyboard Shortcuts
    - Using the Save As Page
  - Closing a Document
  - Opening an Existing Document
  - Different Ways to View Your Work
    - Viewing a Document in the Navigation Pane
    - Zooming In and Out
      - The Zoom Slider
      - The Zoom Dialog Box
    - Working with Multiple Windows
- 3. Editing and Formatting
  - Selecting and Moving Text
    - Four Ways to Move Text
      - Option 1: The Ctrl Key
      - Option 2: Right-Click
      - Option 3: Use the Home Tab
      - Option 4: Use the Clipboard Pane
  - Finding and Replacing Text
    - Searching with the Navigation Pane
    - Setting Search Options
    - Searching with the Find and Replace Dialog Box
    - Replacing Text
  - Text Formatting: Font, Size, and Style
    - The Home Tabs Control Center
    - Copy Formatting with Format Painter
    - Quick Formatting with the Mini Toolbar
    - Styles: Formatting Power
      - Applying Styles Using Style Sets
      - Creating Your Own Style Set
  - Paragraph Formatting: Aligning, Indenting, Spacing
    - Aligning Text
    - Indenting Paragraphs
      - Indenting the First Line
      - Indenting an Entire Paragraph
      - Creating a Hanging Indent
    - Spacing Within a Paragraph
    - Spacing Between Paragraphs
  - Working with Lists
    - Creating a List
    - Formatting Lists
      - Formatting a Bulleted List
      - Formatting a Numbered List
      - Formatting a Multilevel List
  - Formatting a Document
    - Adjusting Page Setup
    - Changing Page Background Settings
      - Adding a Watermark
      - Customizing a Watermark with Text
      - Customizing a Watermark with an Image
      - Editing or Deleting a Watermark
      - Adding Color to Page Backgrounds
      - Adding Patterns to Page Backgrounds
      - Giving Pages a Border
    - Inserting Headers, Footers, and Page Numbers
      - Inserting a Header or Footer
      - Editing a Header or Footer
      - Inserting the Date and Time into a Header or Footer
      - Inserting an Image into a Header or Footer
      - Removing a Header or Footer
      - Inserting Page Numbers
      - Formatting Page Numbers
      - Removing Page Numbers
- 4. Tables, Graphics, and Charts
  - Creating a Table
    - Creating a Table from Scratch
      - Inserting a Table
      - Inserting a Preformatted Table
      - Drawing a Table
    - Creating a Table from Text
  - Adding Information to a Table
  - Editing a Table
    - Selecting Part or All of a Table
      - Using Your Mouse
      - Using the Ribbon
    - Inserting Rows and Columns
    - Moving Rows and Columns
    - Merging and Splitting Cells
    - Deleting All or Part of a Table
  - Formatting a Table
    - Save Time with Ready-to-Use Table Styles
    - Applying Shading and Borders
    - Shading a Table
    - Working with Borders
      - Drawing Borders
  - Inserting Images
    - Inserting a Picture from Your Computer
    - Inserting a Picture from the Web
    - Inserting a Screenshot
  - Editing an Image
    - Changing an Images Size
    - Cropping an Image
    - Removing a Pictures Background
    - Moving and Rotating Images
      - Moving an Image
      - Rotating an Image
    - Adjusting an Images Appearance
    - Using Picture Styles
    - Formatting Pictures
    - Wrapping Text Around an Image
    - Searching for Images
  - Fun with Fonts and Art Thats Smart
    - Creating WordArt
    - Editing WordArt Text
    - Formatting WordArt Using the Format Shape Pane
      - Shape Options
      - Text Options
    - Inserting SmartArt into Word Documents
  - Adding Charts and Diagrams
- 5. Proofing and Research Tools
  - Checking Spelling and Grammar
    - Catching Spelling Mistakes
      - Flagging Frequently Confused Words
      - Checking Spelling in an Entire Document
    - Words Grammar Checker
  - Getting Things Right with AutoCorrect
    - Undoing an AutoCorrect Change
    - Setting AutoCorrect Options
      - Making an Exception
      - Adding Custom Corrections
      - Deleting an AutoCorrect Correction
    - AutoFormatting in Word
  - Words Built-in Research Tools
    - Installing a Dictionary
    - Looking Up a Word in the Dictionary
    - Using the Thesaurus
    - Translating Text
      - Getting a Quick Translation with the Mini Translator
      - Using the Research Pane for Translations
      - Translating an Entire Document
- 6. Printing Documents
  - Getting Started with Printing
    - Previewing a Document Before You Print It
    - Printing a Document
  - Selecting Print Options and Settings
    - Choosing a Printer
    - Specifying Settings
  - Sending a Fax
    - Creating a Cover Page
    - Sending a Fax
  - Printing Envelopes
    - Formatting Envelope Addresses
    - Selecting a Feed Method
    - Adding Electronic Postage
  - Printing Labels
  - Merging Names and Addresses with Documents
    - Step 1: Select Document Type
    - Step 2: Select Starting Document
    - Step 3: Select Recipients
    - Step 4: Write Your Letter
    - Step 5: Preview Your Letters
    - Step 6: Complete the Merge
    - Do-It-Yourself Mail Merge with the Mailings Tabs Buttons
- 7. Reports and Long Documents
  - Inserting Page Breaks
  - Breaking a Document into Sections
    - Kinds of Section Breaks
    - Inserting a Section Break
    - Changing the Orientation of a New Section
    - Changing the Page Numbering of a New Section
  - Footnotes and Endnotes
    - Inserting a Footnote
    - Inserting an Endnote
    - Editing a Note
    - Navigating Notes
    - Changing the Position of Footnotes or Endnotes
    - Converting Footnotes to Endnotes (or Vice Versa)
    - Changing Footnote or Endnote Markers
    - Deleting a Note
  - Citations and Bibliographies
    - Creating and Inserting a Citation
    - Inserting an Existing Citation
    - Inserting a Placeholder
    - Editing a Citation or Its Source
    - Deleting a Citation
    - Deleting a Source
    - Building a Bibliography
    - Updating a Bibliography
  - Helping Readers Navigate Your Document
    - Inserting Bookmarks and Cross-References
      - Creating a Bookmark
      - Jumping to a Bookmark
      - Deleting a Bookmark
      - Creating Cross-References
    - Creating a Table of Contents
    - Creating an Index
      - Marking Index Entries
      - Generating an Index
      - Updating an Index
      - Editing Index Entries
      - Deleting an Index Entry
      - Deleting an index
- 8. Customizing Documents with Themes, Templates, and Macros
  - Themes: The Way to Better Designs
    - Choosing a Theme
    - Customizing a Theme
    - Saving a Theme
    - Finding a Saved Theme
    - Setting a Default Theme
  - Templates: Reusable Document Blueprints
    - Choosing a Template
    - Creating Your Own Template
      - Creating a Template from Scratch
      - Creating a Template from a Document
      - Creating a Template from an Existing Template
    - Customizing a Template
      - Changing an Existing Style within a Template
      - Creating a New Style for a Template
      - Copying a Style from One Template to Another
      - Deleting a Style from a Template
  - Saving Time with Macros
    - Recording a Macro
    - Running a Macro
    - Copying a Macro Between Templates
    - Deleting a Macro
- 9. Desktop and Web Publishing
  - Newsletters and Brochures
    - Laying Out Text in Columns
    - Formatting Columns
    - Inserting a Text Box
    - Images and Text Wrapping
      - Inserting an Image into a Document with Columns
      - Inserting an Image into a Document with Text Boxes
  - Web Page Design
    - Saving a Word Document as a Web Page
    - Creating a Web Page from Scratch
      - Creating Your Sites Home Page
        
        Step 1: Set up a table
        
        Step 2: Create a header
        
        Step 3: Add a navigation bar
        
        Step 4: Add a footer
        
        Step 5: Save the page as a template
        
        Step 6: Adding text and images
    - Creating More Pages for Your Site
- 10. Sharing and Collaborating on Documents
  - Sharing a Document
    - Emailing a Document
      - Emailing a Document as an Attachment
      - Emailing a Link to a Document
    - Present a Document over the Internet
    - Saving a Document to SkyDrive
  - Getting Feedback
    - Inserting a Comment
    - Viewing Comments
    - Editing a Comment
    - Deleting a Comment
    - Keeping Track of Revisions
    - Selecting Which Changes to View
    - Accepting or Rejecting Changes
    - Setting Track Changes Options
  - Comparing Documents
  - Combining Documents
  - Protecting Your Documents
    - Removing Hidden Data and Personal Information
    - Restricting Formatting and Editing
    - Restricting Permissions
  - Coauthoring and Simultaneous Editing
3. Outlook
- 11. Getting Started with Outlook
  - Setting Up Outlook
  - Taking a Quick Look Around
    - Mail
    - Calendar
    - People
    - Tasks
    - Notes
    - Folders
    - Shortcuts
    - Customizing the Navigation Bar
  - Composing and Sending Email
    - Sending an Email to More than One Recipient
    - Proofreading a Message
    - Attaching a File to an Email Message
    - Inserting a Picture into an Email Message
    - Adding a Signature
      - Creating a Signature
      - Editing a Signature
      - Choosing a Signature to Add
      - Deleting a Signature
    - Adding a Theme or Stationery
    - Setting a Messages Priority and Confidentiality
    - Making Sure They Got the Message
    - Setting a Delivery Time
    - Directing Replies to Another Address
    - Adding Voting Buttons
    - Working Offline
  - Receiving Email
    - Replying to or Forwarding an Email
    - Opening an Attachment
    - Getting Notified
    - Deleting a Message
    - Marking a Message as Unread
    - Flagging a Message
      - Flagging a Message Youve Received
      - Flagging an Outgoing Message
      - Finding Flagged Messages
    - Organizing Messages
      - Grouping Messages into Conversations
      - Organizing Messages into Folders
    - Routing Incoming Messages
    - Translating a Message
  - Printing a Message
  - Fighting Spam
    - What If Its Not Spam?
    - Setting Up a Safe Senders List
    - Managing Junk Email
  - Saving Time with Quick Steps
    - Applying a Quick Step
    - Customizing a Quick Step
    - Creating Your Own Quick Step
    - Deleting a Quick Step
  - Managing Multiple Email Accounts
    - Adding Another Email Account
    - Keeping Accounts Straight
    - Choosing Which Account to Send From
- 12. Outlooks Address Book
  - Adding and Editing Contacts
    - Adding Contacts
      - Creating a New Contact from Scratch
      - Creating a New Contact from an Email Message
    - Importing Email Addresses from Another Program
      - Exporting Contacts from Outlook
      - Exporting Contacts from a Different Email Program
      - Importing Contacts from an Outlook Data File
      - Importing Contacts from a CSV File
    - Viewing a Contact
    - Editing a Contacts Information
      - Editing All Fields
      - Creating a New Field
      - Adding Details
      - Editing Business Cards
      - Deleting a Contact
  - Finding a Contact
  - Viewing Contacts
    - Sorting and Grouping Contacts
      - Sorting Contacts
      - Grouping Contacts
    - Customizing a View
    - Saving a View
    - Deleting a View
    - The People Pane
  - Communicating with a Contact
  - Gathering Contacts into a Group
    - Creating a Contact Group
    - Sending Email to a Contact Group
    - Managing a Contact Group
  - Printing Your Contacts
  - Contacts and Social Networking
    - Adding a Social Network to Outlook
- 13. Getting Organized with Folders
  - Finding Folders in the Navigation Pane
  - Creating a New Folder
  - Filling Up and Managing Folders
    - Copying a Folder
    - Moving a Folder
    - Renaming a Folder
    - Deleting a Folder
  - Categorizing Items
    - Assigning a Category
    - Creating a New Category
    - Viewing Items by Category
    - Clearing Categories
    - Renaming a Category
  - Searching Folders
    - Searching the Current Folder
    - Repeating a Search
    - Setting the Scope of Your Search
      - Speeding Up Your Search with Keyboard Shortcuts
    - Refining Your Search
    - Doing an Advanced Search
    - Creating a Search Folder for Email
    - Changing Search Settings
  - Cleaning Out Folders
    - Archiving Old Data
      - Setting Up AutoArchive
      - Adjusting AutoArchive Settings for a Specific Folder
      - Archiving Manually
    - Cleaning up Your Mailbox
- 14. Getting Organized with Outlooks Calendar, Tasks, and Notes
  - Your Schedule, Your Calendar
  - Creating an Appointment or Meeting
    - Scheduling an Appointment
    - Setting Up a Meeting
    - Accepting an Invitation to a Meeting
    - Adding or Removing Attendees
    - Keeping Track of Whos Attending
    - Canceling a Meeting
  - Editing Events
    - Turning an Appointment into a Meeting
    - Making an Event Recur
    - Getting Reminders
    - Deleting an Appointment
  - Viewing Your Schedule
  - Tasks
  - Adding a Task
    - Creating a Task
      - Creating a Recurring Task
      - Assigning a Task
    - Accepting a Task
  - Managing Tasks
    - Editing a Task
    - Flagging Tasks
    - Marking a Task as Completed
  - Viewing Tasks
  - Taking Notes in Outlook
    - Adding a Note
    - Working with Notes
    - Viewing Notes
      - Icon View
      - Notes List View
      - Last 7 Days View
4. Excel
- 15. Creating Your First Spreadsheet
  - Starting a Workbook
  - Adding Information to a Worksheet
    - Adding Column Titles
    - Adding Data
    - Editing Data
    - Editing Cells with the Formula Bar
  - Using the Ribbon
    - Collapsing the Ribbon
    - Using the Ribbon with the Keyboard
  - Using the Status Bar
  - Saving Files
    - The Excel File Format
    - Sharing Your Spreadsheet with Older Versions of Excel
    - Saving Your Spreadsheet for Excel 2003
    - Saving Your Spreadsheet As a PDF
    - Disaster Recovery
      - AutoRecover Settings
  - Opening Files
    - Opening Files in Other Formats
    - Protected View
    - Working with Multiple Open Spreadsheets
  - Adding Different Types of Data
    - How Excel Identifies Text
    - How Excel Identifies Numbers
    - How Excel Identifies Dates and Times
    - Regional Dating
  - Printing
    - How to Print an Excel File
    - Page Layout View: A Better Print Preview
    - Creating Headers and Footers
  - Controlling Pagination
    - Page Breaks
    - Scaling
    - Page Break Preview: A Birds-Eye View of Your Worksheet
- 16. Moving Data
  - Selecting Cells
    - Making Continuous Range Selections
    - Making Noncontiguous Selections
    - Automatically Selecting Your Data
    - Making Selections with the Keyboard
  - Moving Cells Around
    - A Simple Cut-and-Paste or Copy-and-Paste
    - A Quicker Cut-and-Paste or Copy-and-Paste
    - Fancy Pasting Tricks
    - Paste Special
    - Copying Multiple Items with the Clipboard
  - Adding and Moving Columns or Rows
    - Inserting Columns
    - Inserting Rows
    - Inserting Copied or Cut Cells
    - Deleting Columns and Rows
  - Worksheets and Workbooks
    - Adding and Removing Worksheets
    - Moving Between Worksheets
    - Hiding Worksheets
    - Naming and Rearranging Worksheets
    - Moving Worksheets from One Workbook to Another
- 17. Formatting Cells
  - Formatting Cell Values
    - Changing the Cell Value Format
    - Formatting Numbers
      - General
      - Number
      - Currency
      - Accounting
      - Percentage
      - Fraction
      - Scientific
      - Text
    - Formatting Dates and Times
    - Special Formats for Special Numbers
  - Formatting Cell Appearance
    - Alignment and Orientation
    - Fonts and Color
      - Special Characters
    - Borders and Fills
- 18. Building Basic Formulas
  - Creating a Basic Formula
    - Excels Order of Operations
    - Cell References
    - How Excel Formats Cells That Contain Cell References
  - Functions
    - Using a Function in a Formula
    - Using Cell References with a Function
    - Using Cell Ranges with a Function
    - Excel Compatibility Functions
  - Formula Errors
  - Logical Operators
  - Formula Shortcuts
    - Point-and-Click Formula Creation
    - Point-and-Click Formula Editing
    - The Formulas Tab
    - Using the Insert Function Button
  - Copying Formulas
    - Absolute Cell References
    - Partially Fixed References
    - Referring to Other Worksheets
- 19. Math and Statistical Functions
  - Rounding Numbers
    - ROUND(), ROUNDDOWN(), ROUNDUP(): Rounding Numbers
  - Manipulating Text
    - CONCATENATE(): Joining Strings of Text Together
    - LEFT(), MID(), and RIGHT(): Copying Portions of a Text String
    - TRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing Characters
    - SUBSTITUTE(): Replacing One Sequence of Characters with Another
  - Solving Formula Errors
    - Step-by-Step Evaluation
    - Tracing Precedents and Dependents
    - Error-Checking
- 20. Creating Basic Charts
  - Charting 101
    - Embedded and Standalone Charts
    - Adding a Recommended Chart
    - Picking from the Full Range of Charts
    - Selecting a Chart
  - Basic Tasks with Charts
    - Moving and Resizing a Chart
    - Creating a Standalone Chart
    - Editing and Adding to Chart Data
    - Filtering Chart Data
    - Changing the Chart Type
    - Printing Charts
      - Embedded Charts
      - Standalone Charts
  - Practical Charting
    - Charts with Multiple Series of Numbers
    - Controlling the Data Excel Plots on the X-Axis
    - Data That Uses a Date or Time Scale
    - Noncontiguous Chart Ranges
    - Changing the Order of Your Data Series
    - Changing the Way Excel Plots Blank Values
  - Chart Types
    - Column
    - Bar
    - Line
    - Pie
    - Area
  - Chart Styles and Layouts
    - Chart Styles
    - Chart Colors
    - Chart Layouts
  - Adding Chart Elements
    - Adding Titles
    - Adding a Legend
    - Adding Data Labels to a Series
    - Adding Individual Data Labels
    - Adding a Data Table
5. PowerPoint
- 21. Creating a Presentation
  - Creating a New Presentation
    - Creating a New Presentation from a Template
    - Choosing a Theme
    - Varying a Theme
    - Adding Text to a Slide
    - Creating a New Slide
    - Adding Content
    - Deleting Content
  - Saving a Presentation
  - Opening an Existing Presentation
    - Open a Recent Presentation from the Windows 8 Start Screen
    - Open a Recent Presentation from the Windows 7 Start Menu
    - Open a Recent Presentation in PowerPoint
    - Open Any Saved Presentation in PowerPoint
  - Adding Notes
  - Viewing a Presentation
    - Normal View
    - Outline View
    - Slide Sorter View
    - Notes Page View
    - Reading View
    - Slide Show View
    - Zooming In and Out
  - Printing a Presentation
- 22. Editing Slides
  - Editing Text
    - Formatting Text
    - Adjusting Character Spacing
    - Positioning Text
    - Formatting a Text Box
    - Creating Lists
    - Linking Text to a Web page
    - Checking Your Spelling
    - Turning Text into WordArt
  - Embedding Other Files in Slides
    - Embedding an Existing File in a Slide
    - Updating Links
    - Creating a New Embedded File
  - Adding Tables to Slides
    - Inserting a Table
      - Inserting a Table When You Add a New Slide
      - Inserting a Table on an Existing Slide
      - Insert a Table Using an Excel-Style Spreadsheet
      - Drawing a Table
    - Adding Information to a Table
    - Editing a Table
      - Selecting All or Part of a Table
      - Resizing a Table
      - Moving a Table
      - Changing a Tables Style
  - Adding Images to Slides
    - Creating a Photo Album
      - Setting Up a Photo Album
      - Editing a Photo Album
    - Working with Shapes
      - Inserting a Shape
      - Changing a Shapes Size or Position
      - Adding Text to a Shape
      - Formatting a Shape
    - Working with SmartArt
      - Inserting SmartArt
      - Converting Text to SmartArt
      - Adding a Shape
      - Reordering Shapes
      - Applying a Different Layout
      - Adjusting a SmartArt Graphics Style
      - Formatting Shapes within a SmartArt Graphic
      - Rotating a SmartArt Graphic
      - Resizing a SmartArt Graphic
    - Working with Charts and Diagrams
      - Creating a Chart or Diagram Using Excel
      - Creating a Diagram Using Shapes
  - Arranging Objects on a Slide
    - Aligning Objects Using the Arrange Button
    - Aligning Objects Manually
    - Ordering Objects
    - Grouping Objects
- 23. Editing a Presentation
  - Copying, Rearranging, and Deleting Slides
    - Copying a Slide
    - Duplicating a Slide
    - Inserting a Slide from a Different Presentation
    - Rearranging Slides in a Presentation
    - Deleting a Slide
    - Hiding Slides
  - Headers and Footers
    - Time-Stamping Slides
    - Adding a Footer to Slides
    - Numbering Slides
    - Adding a Header and Footer to Notes and Handouts
  - Organizing Your Presentation with Sections
    - Creating a Section
    - Naming a Section
    - Collapsing and Expanding Sections
    - Moving a Section Within a Presentation
    - Hiding All Slides Within a Section
    - Removing a Section from a Presentation
  - Navigating with Links and Action Buttons
    - Inserting a Hyperlink to Another Slide
    - Creating a Table of Contents for Your Presentation
    - Linking to a Hidden Slide
    - Inserting an Action Button
    - Opening an Inserted File
  - Slide Masters: Powerful Slide Blueprints
    - Changing the Look of All Slides in Your Presentation
    - Changing the Layout for a Particular Type of Slide
    - Creating a New Layout
    - Working with Masters for Handouts and Notes
      - Modifying the Handout Master
      - Modifying the Notes Master
  - Collaborating with Others
    - Adding and Reading Comments
      - Inserting a Comment
      - Reading Comments
      - Editing a Comment
      - Hiding Comments
      - Deleting Comments
    - Comparing Versions of a Presentation
- 24. Adding Multimedia and Movement
  - Putting Media Clips in a Presentation
    - Adding Video Thats Stored on Your Computer
    - Adding a Video from SkyDrive
    - Adding Video from a Website
    - Finding and Adding Video via Bing or YouTube
    - Adding Sound Thats Stored on Your Computer
    - Adding Clip Art Audio
    - Recording Audio
    - Playing Audio Throughout a Slideshow
    - Formatting Video Clips
      - Adjust Brightness and Contrast
      - Add a Frame or Border
      - Add Effects
      - Crop the Player
    - Formatting Audio Clips
    - Editing Media Clips
      - Using Bookmarks
      - Trimming a Media Clip
      - Fading in and Fading Out
      - Hide a Clip Until You Want it to Play
      - Other Media Clip Settings
  - Animating Objects
    - Animating an Object
    - Changing an Animation
    - Adjusting Effect Options
      - Adding Sound to an Animation
      - Dimming Text
      - Animating Paragraphs and Words
    - Adding More Animation
    - Creating a Motion Path
    - Triggering an Animation
    - Timing Animations
    - Reordering Animations
    - Removing an Animation
    - Using the Animation Pane
    - Animating Lists
      - Adjusting Animation for Individual List Items
      - Giving Sub-Items their Own Animation
      - Animating a List as a Single Block of Text
    - Stacking Objects
    - Animating SmartArt Graphics
  - Creating Transitions Between Slides
    - Adding a Transition
    - Tweaking Transition Effects
    - Adding Sound to a Transition
    - Timing Transitions
- 25. Its Showtime! Giving a Presentation
  - Start, Navigate, End: Tips and Shortcuts
    - Starting a Slideshow
    - Moving From Slide to Slide
    - Ending a Slideshow
  - Before the Show: Prep Work
    - Adding Narration to Your Presentation
      - Recording a Narration
      - Playing Back a Narrated Slideshow
      - Turning Off Narration
    - Creating a Custom Slideshow
    - Creating a Handout
    - Setting Up Your Show
      - Following your Notes in Presenter View
  - At the Event
    - Settings to Check
    - Launching a Slideshow
    - During the Show
      - Zooming in
      - Hiding or Showing the Pointer
      - Marking Up Slides
      - Changing Markup Color
      - Erasing Markup
      - Making the Mouse Pointer a Laser Pointer
      - Making the Screen go Blank
      - Switching to Another Program (and Back)
    - Ending the Show
  - Other Presentation Options
    - Presenting a Slideshow Online
      - Editing an Online Presentation
    - Creating a Slideshow That Runs by Itself
    - Creating an Interactive Slideshow
    - Turning Your Presentation into a Video
  - Sharing Your Presentation
    - Packaging Your Presentation on a CD or DVD
6. Access
- 26. Creating Your First Database
  - Understanding Access Databases
  - Starting a Database
  - Building Your First Table
    - Creating a Simple Table
    - Editing a Table
      - Edit Mode
      - Datasheet Shortcut Keys
      - Cut, Copy, and Paste
  - Saving Databases
    - Making Backups
    - Saving a Database with a Different Name
    - Saving a Database in a Different Format
    - Shrinking a Database
  - Opening Databases
    - Designating a Database as Trusted
    - Opening More Than One Database at Once
    - Opening a Database Created in an Older Version of Access
  - The Navigation Pane
    - Browsing Tables with the Navigation Pane
    - Managing Database Objects
- 27. Building Smarter Tables
  - Understanding Data Types
  - Design View
    - Organizing and Describing Your Fields
    - How Updates Work in Design View
  - Access Data Types
    - Short Text
      - Text Length
    - Long Text
      - Formatted Text
    - Number
      - Number Size
      - Number Formatting
    - Currency
    - Date/Time
      - Custom Date Formats
    - Yes/No
    - Hyperlink
    - Attachment
    - AutoNumber
      - Using AutoNumbers Without Revealing the Size of your Table
      - Using Replication IDS
    - Calculated
  - The Primary Key
    - Creating Your Own Primary Key Field
  - Six Principles of Database Design
    - 1. Choose Good Field Names
    - 2. Break Down Your Information
    - 3. Include All the Details in One Place
    - 4. Avoid Duplicating Information
    - 5. Avoid Redundant Information
    - 6. Include an ID Field
  - Blocking Bad Data
  - Data Integrity Basics
    - Preventing Blank Fields
      - Blank Values and Empty Text
    - Setting Default Values
    - Preventing Duplicate Values with Indexes
      - Multifield Indexes
  - Lookups
    - Creating a Simple Lookup with Fixed Values
    - Adding New Values to Your Lookup List
- 28. Mastering the Datasheet: Sorting, Searching, and Filtering
  - Datasheet Customization
    - Formatting the Datasheet
    - Rearranging Columns
    - Resizing Rows and Columns
    - Hiding Columns
    - Freezing Columns
  - Datasheet Navigation
    - Sorting
      - Sorting on Multiple Fields
    - Filtering
      - Quick Filters
      - Filter by Selection
      - Filter by Condition
    - Searching
  - Printing the Datasheet
    - Print Preview
      - Moving Around the Print Preview
      - Changing the Page Layout
    - Fine-Tuning a Printout
- 29. Linking Tables with Relationships
  - Relationship Basics
    - Redundant Data vs. Related Data
    - Matching Fields: The Relationship Link
    - Linking with the ID Column
    - The Parent-Child Relationship
  - Using a Relationship
    - Defining a Relationship
    - Editing Relationships
    - Referential Integrity
      - Blank Values for Unlinked Records
      - Cascading Deletes
      - Cascading Updates
    - Navigating a Relationship
    - Lookups with Related Tables
  - More Exotic Relationships
    - One-to-One Relationship
    - Many-to-Many Relationship
      - Junction Tables
      - Multi-Value Fields
7. Other Office Tools
- 30. Publisher
  - Creating a New Publication
    - Creating a Publication from a Template
    - Creating a Publication from Scratch
    - Viewing the Page
    - Entering Text
    - Inserting an Image
    - Adding Pages
    - Navigating Pages
    - Saving a Publication
  - Adding Text
    - Editing and Formatting Text
      - Aligning Text within a Text Box
      - Fitting Text to a Text Box
      - Adjusting Hyphenation
      - Working with Character Spacing
      - Formatting Text
      - Adding Some Style to Your Text
    - Inserting Your Business Information
    - Flowing Text from One Box to Another
      - Flowing Text Manually
      - Connecting Text Boxes to Autoflow Text
    - Flowing Text Around an Object
  - Adding Pictures, Shapes, and Other Objects
    - Formatting Objects
      - Formatting Pictures
      - Formatting Shapes and WordArt
    - Stacking and Grouping Objects
  - Designing and Laying Out Pages
    - Setting Up Pages
    - Choosing a Color Scheme
    - Choosing a Font Scheme
    - Using Layout Guides
    - Snapping an Object to a Guide
  - Reviewing Your Design
  - Printing a Publication
    - Preparing a Publication for a Commercial Printer
- 31. OneNote
  - What Is OneNote?
    - Getting Familiar with the OneNote Workspace
  - Creating and Filling Up a Notebook
    - Adding Notes to a Page
      - Typing a Note
      - Pasting in a Note
      - Drawing a Note
      - Inserting a Screen Clipping
      - Recording Audio and Video Notes
  - Organizing a Notebook
    - Working with Sections and Pages
      - Moving a Section
      - Merging Sections
      - Moving a Page
      - Changing a Pages Level
    - Deleting Notebooks, Sections, and Pages
  - Managing Individual Notes
    - Writing Quick Notes
    - Linking a Note to its Source
    - Tagging a Note
      - Tagging your to-do Items
      - Creating a Custom Tag
      - Finding Tagged Notes
      - Removing a Tag
    - Finding a Note
      - Searching a Page
      - Changing the Scope of your Search
  - Viewing Your Notebooks
  - Sharing Notes
    - Sharing a Notebook via a Link
    - Sharing a Notebook with an Online Meeting
    - Finding Changes Others Have Made
    - Emailing a Page
  - Using OneNote with Other Office Programs
    - Linking Notes to Their Source
      - Viewing Note Links
      - Removing Links from Linked Notes
      - Turning off Linked Notes
    - Getting Office Files into OneNote
      - Attaching a File to a Note
      - Inserting a Copy of a File into OneNote
- 32. SkyDrive and Office Web Apps
  - Introducing Office on the Web
  - Setting Up Office Web Apps
    - Signing in to SkyDrive
  - Whats New in Office Web Apps
  - Creating and Editing Files
    - Saving a Web App File in SkyDrive
  - Working with Folders in SkyDrive
    - Creating a Folder
    - Viewing Folders and Files
    - Finding Folders and Files
    - Viewing Files in a Folder
    - Renaming a Folder
    - Deleting a Folder
  - Managing Files in SkyDrive
    - Opening a File
    - Uploading Files to SkyDrive from Your Computer
      - Starting Point: SkyDrive
      - Starting Point: an Office Program
    - Downloading Files from SkyDrive to Your Computer
    - Move, Rename, Delete: File Management Tips
  - Sharing Files and Folders
    - Sharing in Office Web Apps
      - Sharing in Office Web Apps
      - Sharing on a Social Network
      - Sharing a File as a Web Page
      - Making a Shared Folder or File Private
    - Real-Time Collaborating
  - Docs.com: Office Web Apps for Facebook
    - Adding a Doc
      - Creating a Doc from Scratch
      - Creating a Doc from a Template
      - Uploading a File from your Computer
    - Viewing Your Docs
    - Editing a Doc
    - Sharing a Doc
    - Viewing Friends Docs
Index
About the Authors
Copyright