Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title Page
Copyright Page
Contents at a Glance
Contents
About the Authors
Acknowledgments
Introduction
Conventions Used in This Book
Chapter 1: Stepping into Office
Open and Close an Office Program
Start an Office Program in Windows 7
Start an Office Program in Windows 8
Close an Office Program
Open, Close, and Save an Office Document
Using Touch
Open a New Office Document
Locate and Open an Existing Document
Using Templates
Using SkyDrive
Save a Document for the First Time
Save a Document Automatically
Save a Document as a Copy or as a Template
Close an Office Document
Explore an Office Program
Explore an Office Program Window
Understanding the Ribbon
Use the Mouse
Use the Mini Toolbar
Use Tabs and Menus
Use Various Views
Personalize and Customize Office 2013 Programs
Work with the Quick Access Toolbar
Show or Hide ScreenTips
Change the Screen Color
Add Identifying Information
Set General Preferences
Use AutoCorrect
Use Common Office Tools
Open Help
Use the Thesaurus
Translate a Document
Use the Office Clipboard
Check Spelling
Make Accessibility Changes
Chapter 2: Working with Documents in Word
Step into Word
Use the Start Screen for Word
Create a New Document
Locate and Open an Existing Document
Import a Document
Using View Buttons
Write a Document
Enter Text
Determine Where Text Will Appear
Insert Text or Type Over It
Insert Line or Page Breaks
Select Text
Copy and Move Text
Delete Text
Enter Symbols and Special Characters
Navigate a Document
Move Around in a Document
Find and Replace Text
Using Wildcards
Use Word Writing Aids
Use Building Blocks
Count Characters and Words
Use Highlighting
Add Hyphenation
Chapter 3: Formatting a Document
Format Text
Survey the Text-Formatting Tools
Apply Character Formatting
Reset Font Defaults
Change Character Spacing and OpenType Features
Change Capitalization
Create a Drop Cap
Format a Paragraph
Survey the Paragraph-Formatting Tools
Set Paragraph Alignment
Indenting a Paragraph
Change and Remove Indents
Use the Ruler for Indents
Understand Line and Paragraph Spacing
Set Line Spacing
Use Numbered and Bulleted Lists
Define New Multilevel Lists
Add Horizontal Lines, Borders, and Shading
Format a Page
Turn On Formatting Marks
Set Margins
Copy Formatting
Use the Page Setup Dialog Box to Format a Page
Use Mirror Margins with the Menu
Determine Page Orientation
Specify Paper Size
Track Inconsistent Formatting
Set Vertical Alignment
Chapter 4: Customizing a Document
Use Styles
Understanding Themes and Styles
Identify Text with a Style
Apply Predefined Style Sets to a Document
Create a New Style
Modify a Style
Clear a Style from Text or a Document
Delete/Restore a Style from the Gallery
Examine Current Styles
Use Themes
Assign a Theme to Your Document
Change a Theme
Create a Custom Theme
Work with Documents
Create Section Breaks
Create and Use Columns
Use Tabs
Add Headers and Footers
Add Footnotes and Endnotes
Create an Index
Create a Table of Contents
Handling Subdocuments
Create and Use Outlines
Chapter 5: Entering and Editing Data in Excel
Enter Data
Understanding Data Types
Enter Text
Complete an Entry
Enter Numeric Data
Enter Dates
Format Numbers
Use Times
Understanding Excel Dates and Times
Add Data Quickly
Edit Data
Edit Cell Data
Remove Cell Contents
Select Cells and Ranges
Copy and Paste Data
Find and Replace Data
Verify Spelling
Modify Automatic Corrections
Edit Workbooks in the Excel Web App
Chapter 6: Formatting a Worksheet in Excel
Work with Cells, Rows, and Columns
Adjust Row Height
Adjust Column Width
Hide and Unhide Rows and Columns
Add and Remove Rows, Columns, and Cells
Change Cell Borders
Add a Comment
Format Comments
Apply Formatting
Understanding Excel Formatting
Apply Themes
Create Custom Themes
Search for Themes
Use Cell Styles
Change Fonts
Change Alignment and Orientation
Add a Background
Copy Formatting
Arrange and Organize Worksheets
Lock Rows and Columns
Split a Worksheet
Work with Worksheets
View Worksheets from Multiple Workbooks
Compare Workbooks
Chapter 7: Using Formulas and Functions
Reference Cells
Understanding Cell Referencing Types
Change Cell References
Change to R1C1 References
Use Cell Reference Operators
Name Cells
Go to a Named Cell
Use the Name Manager
Build Formulas
Create a Formula
Edit a Formula
Use Formulas
Move Formulas
Copy Formulas
Recalculate Formulas
Use External References in Formulas
Add a Symbolic Formula
Understanding the Trust Center
Format Conditionally
Use Functions
Use Functions Quickly
Enter a Function
Enter a Sum in Columns or Rows Quickly
Find and Correct Errors
Check for Errors
Trace Precedent and Dependent Cells
Watch a Cell
Evaluate a Formula in Pieces
Chapter 8: Creating a Presentation in PowerPoint
Step into PowerPoint
Use the PowerPoint Start Screen
See the PowerPoint Views
Understanding PowerPoint Terminology
Take the PowerPoint Tour
Use PowerPoint Ribbon Tabs
Using Menus and “Launchers” from the Ribbon
Create a Presentation
Create a Presentation from Another Presentation
Create a Presentation Using a Template
Create a Presentation from Scratch
Complete Your Look and Content
Choose a Slide Layout
Apply Themes to Slides
Add Content to a Slide
Outline a Presentation
Create an Outline
Understanding the Outlining Feature
Use the Outlining Commands
Preview and Print the Outline
Chapter 9: Working with Slides
Navigate and Manipulate Slides
Navigate from Slide to Slide
Insert a Slide
Display Multiple Presentations at Once
Duplicate One or More Slides
Move or Copy Slides
Reviewing the Paste Options
Copy a Design Using Browse
Use Zoom
Use a Keyboard with Slides
Using Variants of Themes
Change the Look and Feel of Slides
Change a Theme
Create a Custom Theme
Copy Attributes with the Format Painter
Work with Hyperlinks
Use Footers on Slides
Work with Text
Use a Text Layout
Insert a New Text Box
Changing Font Attributes
Change Regular Text to WordArt Styles
Work with Text Boxes
Use Lists
Use the Font Dialog Box
Align Text
Moving or Copying Text
Spiff Up Your Presentation with SmartArt
Use Transitions and Animations
Work with Transitions
Add Animations to Your Slides
Chapter 10: Polishing and Publishing Your Presentations
Work with Master Slides
Edit a Slide Master or Layout Master
Perform Additional Slide Master Tasks
Understand the Slide Master Ribbon
Work with the Notes Master
Change the Handout Master
Work with Notes
Display the Notes Pane
Understanding PowerPoint Images and Illustrations
Preview Speaker Notes
Use Headers and Footers on Notes and Handouts
Print Notes and Handouts
Share Your Presentation
Share in a Variety of Ways
Export Your Presentation
Present a Slide Show
Set Controls for Two Monitors
Understanding Equipment Setup for Presenting with Dual Monitors
Choosing a Presentation Format
Set Up Your Slide Show
Use a Presenter View Slide Show
Start the Slide Show
Set Up an Automated Slide Show
Record Narrations and Timings
Rehearse Your Timing
Chapter 11: Using Outlook
Set Up E-mail
Set Up Your Outlook Account
Upgrade to Outlook
Explore Outlook
Explore the Outlook Window
Change Views
Use the Navigation Pane
Receive E-mail
Check for E-mail
Read E-mail
Filter Junk Mail
Write Messages
Create a Message
Address a Message
Add Carbon and Blind Copies
Edit a Message
Attach Files
Including Hyperlinks
Send Messages
Reply to Messages
Forward Messages
Handle E-mail Messages
Find a Message
Archiving Messages
Delete Messages
Manage Attachments
Create Contacts in People View
Add a New Contact
Create a Contact Group
Explore the Calendar
Create an Appointment
Create a New Task
Chapter 12: Printing, Using Mail Merge, and Working with Graphics
Print Documents
Set a Default Printer
Define How a Document Is Printed
Print a Document
Merge Lists with Letters and Envelopes
Perform a Mail Merge Using the Wizard
Use Rules
Merge to Envelopes
Merge to Labels
Work with Graphics
Add Pictures
Using the Picture Tools Format Tab
Remove Unwanted Areas
Add Shapes
Create a Diagram
Take a Screenshot
Modify Graphics
Understanding Graphic Positioning in Office Programs
Resize and Rotate Graphics Precisely
Position Graphics
Work with Graphics
Combine Graphics by Grouping
Index
← Prev
Back
Next →
← Prev
Back
Next →