Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Contents
Part I: Common Office Features
Chapter 1: Welcome to Microsoft Office 2013
Learning about Office Applications
Taking Advantage of Other Office Applications
Previewing New Features
Starting an Application
Closing an Application
Finding Files
Getting Help
Summary
Chapter 2: Navigating in Office
The Office Look
Your Interface to Faster File Creation
Using an Application Start Screen
Touring an Office Application Screen
Exploring the File Tab
Controlling the Ribbon Display
Gestures and Touch Navigation
Setting Application Options
Working with Dialog Boxes
Summary
Chapter 3: Mastering Fundamental Operations
Working with Files
Printing a File
Working with Multiple Windows
Moving and Copying Information
Undoing and Redoing Actions
Finding and Replacing
Using Go To
Spell Checking
AutoCorrect, AutoFormat, and Actions
Styles and Live Preview
Working with User Accounts
Summary
Part II: Creating Documents with Word 2013
Chapter 4: Diving Into Document Creation
Creating a Blank File
Creating a File from a Template
Opening an Existing File
Saving and File Formats
Compatibility with Previous Versions of Word
Navigation and Selection Tips and Tricks
Choosing the Right Word View for the Task at Hand
Summary
Chapter 5: Font/Character Formatting
Reviewing the Ways You Can Format Text in Word
Formatting Characters Directly or with Styles
Applying Character Formatting
Summary
Chapter 6: Paragraph Formatting
Choosing between Styles and Paragraph Formatting
Finding Paragraph Formatting Tools
Structuring Text with Paragraph Formatting
Setting Off Text with Paragraph Decoration
Summary
Chapter 7: Using Styles to Create a Great Looking Document
Using the Styles Group to Apply Styles
Modifying and Creating Styles
Changing the Whole Document via Style Sets
Managing Styles
Style Inspector
Summary
Chapter 8: Controlling Document Appearance with Sections and More
Changing Basic Page Setup
Section Formatting
Headers and Footers Overview
Header and Footer Navigation and Design
Adding Header and Footer Material
Changing the Number of Columns
Adding and Removing Page Borders
Working More Effectively with Themes
Summary
Chapter 9: Adding Tables and Graphics to a Document
Getting a Quick Start with Quick Tables
Table Basics
Working with Table Layout and Design
Adding a Shape
Inserting a Picture from a File
Adding an Online Picture
Pasting or Snapping a Picture
Manipulating Inserted Pictures (and Other Graphics)
Creating WordArt
Inserting SmartArt
Arranging Pictures and Other Objects
Using the Selection Pane
Summary
Chapter 10: Data Documents and Mail Merge
Previewing the Mail Merge Process
Data Considerations
Reviewing Data File Formats
Choosing the Data Document Type
Attaching a Data Source
Assembling a Merge Document
Mail Merge Pane/Wizard
Summary
Chapter 11: Managing Document Security, Comments, and Tracked Changes
Protection Types
Comments and Tracked Changes
Accepting and Rejecting Changes
Combining Collaborative Documents
Comparing Documents
Combining Documents That Contain Tracked Changes
Summary
Part III: Making the Numbers Work with Excel 2013
Chapter 12: Using Excel Worksheets and Workbooks
Identifying What Excel Is Good For
Seeing What’s New in Excel 2013
Understanding Workbooks and Worksheets
Moving around a Worksheet
Introducing Excel’s Ribbon Tabs
Creating Your First Excel Workbook
Summary
Chapter 13: Entering and Editing Worksheet Data
Exploring Data Types
Entering Text and Values into Your Worksheets
Entering Dates and Times into Your Worksheets
Modifying Cell Contents
Applying Number Formatting
Summary
Chapter 14: Essential Worksheet and Cell Range Operations
Learning the Fundamentals of Excel Worksheets
Controlling the Worksheet View
Working with Rows and Columns
Understanding Cells and Ranges
Copying or Moving Ranges
Using Names to Work with Ranges
Adding Comments to Cells
Summary
Chapter 15: Introducing Formulas and Functions
Understanding Formula Basics
Entering Formulas into Your Worksheets
Editing Formulas
Using Cell References in Formulas
Using Formulas in Tables
Correcting Common Formula Errors
Tips for Working with Formulas
Summary
Chapter 16: Working with Dates and Times
How Excel Handles Dates and Times
Date-Related Worksheet Functions
Time-Related Functions
Summary
Chapter 17: Creating Formulas That Count and Sum
Counting and Summing Worksheet Cells
Basic Counting Formulas
Advanced Counting Formulas
Summing Formulas
Conditional Sums Using a Single Criterion
Conditional Sums Using Multiple Criteria
Summary
Chapter 18: Getting Started Making Charts
What Is a Chart?
Understanding How Excel Handles Charts
Creating a Chart
Hands On: Creating and Customizing a Chart
Working with Charts
Understanding Chart Types
Summary
Chapter 19: Communicating Data Visually
Creating a Table
Changing the Look of a Table
Working with Tables
About Conditional Formatting
Conditional Formats That Use Graphics
Working with Conditional Formats
Introducing Sparklines
Sparkline Types
Creating Sparklines
Customizing Sparklines
Auto-Updating Sparklines
Displaying a Sparkline for a Dynamic Range
Summary
Part IV: Persuading and Informing with PowerPoint 2013
Chapter 20: A First Look at PowerPoint 2013
Who Uses PowerPoint and Why?
What’s New in PowerPoint 2013?
Starting and Exiting PowerPoint
Changing the View
Zooming In and Out
Enabling Optional Display Elements
Opening a New Display Window for the Same Presentation
Summary
Chapter 21: Creating a Presentation, Slides, and Text
Starting a New Presentation
Saving Your Work
Setting Passwords for File Access
Closing and Reopening Presentations
Setting File Properties
Creating New Slides
Inserting Content from External Sources
Managing Slides
Using Content Placeholders
Creating Text Boxes Manually
Working with Text Boxes
Summary
Chapter 22: Working with Layouts, Themes, and Masters
Understanding Layouts and Themes
Changing a Slide’s Layout
Applying a Theme
Managing Themes
Changing Colors, Fonts, and Effects
Changing the Background
Working with Placeholders
Customizing and Creating Layouts
Managing Slide Masters
Summary
Chapter 23: Working with Tables and Charts
Creating a New Table
Moving around in a Table
Selecting Rows, Columns, and Cells
Editing a Table’s Structure
Applying Table Styles
Formatting Table Cells
Understanding Charts
Starting a New Chart
Working with Chart Data
Chart Types and Chart Layout Presets
Working with Chart Elements
Controlling the Axes
Formatting a Chart
Rotating a 3-D Chart
Summary
Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures
Understanding SmartArt Types and Their Uses
Inserting a SmartArt Graphic
Editing SmartArt Text
Modifying SmartArt Structure
Modifying a Hierarchy Graphic Structure
Formatting a SmartArt Graphic
Saving a SmartArt Graphic as a Picture
Choosing Appropriate Artwork
Inserting Clip Art
Understanding Raster Graphics
Inserting Photos
Sizing and Cropping Photos
Adjusting and Correcting Photos
Compressing Images
Summary
Chapter 25: Building Animation Effects, Transitions, and Support Materials
Understanding Animation and Transitions
Assigning Transitions to Slides
Animating Slide Content
The When and How of Handouts
Creating Handouts
Creating Speaker Notes
Printing an Outline
Printing Slides
Summary
Chapter 26: Delivering a Live Presentation
Starting and Ending a Show
Using the On-Screen Show Controls
Using the On-Screen Pen
Hiding Slides for Backup Use
Using Custom Shows
Giving a Presentation on a Different Computer
Presenting an Online Show
Working with Audio-Visual Equipment
Summary
Part V: Organizing Messages, Contacts, and Time with Outlook
Chapter 27: Fundamentals of E-mail
Setting Up Your E-mail Accounts
Modifying Account Settings
Using Outlook Profiles
Composing and Sending Messages
Reading and Replying to Messages
Understanding the Inbox Display
Understanding Files and Folders
Outlook Data Files
Working with Outlook Folders
Deleting Items and Using the Deleted Items Folder
Setting Options for an Individual E-mail Message
Setting Global E-mail Options
Summary
Chapter 28: Processing and Securing E-mail
Understanding Junk E-mail Filtering
Setting Junk E-mail Options
Blocking and Allowing Specific Addresses
Understanding E-mail Rule Basics
Creating a New Rule
Some Rule Examples
Managing Rules
Protecting against Viruses
Dealing with Attachments
Macro Security
Using Certificates and Digital Signatures
HTML Message Dangers
Summary
Chapter 29: Working with Contacts
Understanding Outlook Contacts (People)
The Contacts Window
Adding Contacts
Sending an E-mail to a Contact or Group
More about Contacts
Performing a Mail Merge from Your Contacts
Setting Contact Options
Summary
Chapter 30: Working with Appointments and Tasks
Understanding the Outlook Calendar
Using the Calendar
Working with Appointments
Searching the Calendar
Setting Calendar Options
Understanding Tasks
Using the Tasks Feature
Creating a New Task
Working with Assigned Tasks
Other Ways of Viewing Tasks
Setting Task Options
Summary
Part VI: Designing Publications with Publisher
Chapter 31: Introducing Publisher
The Publisher Workspace
Using a Template to Create a Publication
Working with Text
Working with Graphics
Working with Tables
Summary
Chapter 32: Designing Dazzling Publications with Publisher
Adding Special Effects
Using Building Blocks
Updating a Publication
Fine-Tuning Objects
Working with Pages
Checking and Printing
Preparing for Outside Printing
Saving a Publication for Online Photo Center Printing
Summary
Part VII: Managing Information with Access and OneNote
Chapter 33: An Introduction to Database Development
The Database Terminology of Access
Relational Databases
Access Database Objects
A Five-Step Design Method
Summary
Chapter 34: Creating Access Tables
The Access Start Screen
How to Create a Blank Desktop Database
The Access 2013 Environment
Creating an Example Table
Setting the Primary Key
Indexing Access Tables
Printing a Table Design
Saving the Completed Table
Manipulating Tables
Adding Records to a Database Table
Navigating Records in a Datasheet
Changing Values in a Datasheet
Understanding Attachment Fields
Summary
Chapter 35: Creating and Entering Data with Basic Access Forms
Formulating Forms1232
Working with Controls
Introducing Properties
Using Form View
Changing Values in a Form
Printing a Form
Summary
Chapter 36: Selecting Data with Queries
Introducing Queries
Creating a Query
Working with Query Fields
Adding Criteria to Your Queries
Printing a Query’s Recordset
Saving a Query
Creating Multi-Table Queries
Working with the Table Pane
Creating and Working with Query Joins
Summary
Chapter 37: Presenting Data with Access Reports
Introducing Reports
Creating a Report, from Beginning to End
Summary
Chapter 38: Keeping Information at Hand with OneNote
Who Needs OneNote and Why
Touring OneNote
Creating a Notebook
Creating a Section
Creating a Page
Inserting Notes
Inserting an Outlook Task
Inserting a Picture or File
Inserting a Screen Clipping
Writing on a Page
Using Linked Note Taking
Using Send To OneNote
Organizing, Finding, and Sharing
Working with Notes in the Cloud
Summary
Part VIII: Sharing and Collaborating in the Cloud and Applications
Chapter 39: Collaborating in the Cloud with SkyDrive
Understanding SkyDrive Pro and SkyDrive for Windows
Saving to the Cloud with SkyDrive
SkyDrive for Windows Application versus SkyDrive in Office
Accessing Your SkyDrive Pro Library on Office 365
Summary
Chapter 40: Integrating Office Application Information
Excel
PowerPoint
Outlook
Access Imports and Exports
OneNote
Summary
Appendix A: Customizing Office
Appendix B: Optimizing Your Office Installation
Appendix C: International Support and Accessibility Features
Introduction
← Prev
Back
Next →
← Prev
Back
Next →