Your Office Microsoft Office 2013, Volume 1

by Kinser, Amy S.; Kinser, Eric; Lending, Diane; Moriarity, Brant; O'Keefe, Timothy; Pope, Charles; Shah, Anci

• ISBN13: 9780133142693
• ISBN10: 0133142698
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2013-03-22
• Publisher: Pearson

Summary

This book covers introductory Word, Excel, Access, and PowerPoint, with additional sections on integrating those applications, as well as a Windows 8 workshop. Ideal for business courses.

Make Microsoft Office, Your Office

The Your Office series prepares you to use both technical and soft skills in the real world. Our modern approach weaves the technical content into realistic business scenarios and focuses on using Office as a decision-making tool. Students learn best by doing, so you will be active from page 1. There is plenty of guidance at first, but the case exercises will ask more from you as the book progresses. Innovative features help you progress from a basic understanding to mastery of each application, empowering you to perform with confidence in Windows 8, Word, Excel, Access, and PowerPoint, even on mobile devices. No matter what career path you’re on, the Your Office series will give you the foundation to succeed.

Table of Contents

Contents

Workshop 1: Understand the Windows 8 Interface

PREPARE CASE: Painted Paradise Golf Resort and Spa—Employee Introduction to Microsoft Windows 8

Understanding Windows 8

Starting and Shutting Down Windows 8

Exploring the Windows 8 Interface

Explore the Windows 8 Start Screen

Use the Snipping Tool

Use WordPad

Switch Between Programs

Open and Close Programs

Using Charms and Windows Search

Using Gestures

Protecting Windows 8

Log in Using a Microsoft Account

Use Picture Passwords

Add a PIN Login

Log in Using PINs and Picture Passwords

Add a Trusted PC

Using Internet Explorer 10

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

WORKSHOP 2: Manage Files, Folders, and the Windows Desktop

PREPARE CASE: Painted Paradise Golf Resort and Spa Updates to Microsoft Windows 8

Using File Explorer

Open and Navigate File Explorer

Add Folders to Libraries

Working with Folders

Create and Name a New Folder

Copy, Move, Rename, and Delete Folders

Copying Folders

Moving Folders

Renaming Folders

Deleting Folders

Working with Files

Copy, Move, Rename, and Delete Files

Copying a Single File

Copying a Group of Files

Copying a Nonadjacent Group of Files

Moving a Single File

Previewing Files

Renaming and Deleting Files

Zip Files

Extract Files

Add Tags to Files

Searching for Tagged Files

Exploring the Windows 8 Desktop

Identify Desktop Elements

Understand the Taskbar

Working with Windows

Open and Manage Windows

Moving and Sizing a Window

Minimizing and Restoring a Window

Maximizing, Snapping, and Closing a Window

Work with Multiple Windows

Switching Between Windows Using Taskbar Buttons

Switching Between Windows Using a Key Combination

Using Shake

Arranging Windows Using Cascade

Stacking Windows

Arranging Windows Side By Side

Personalizing the Desktop

Change the Appearance of the Desktop

Changing the Desktop Background

Selecting a Screen Saver

Undoing Changes

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Windows 8 MODULE 1 CAPSTONE

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

How Others Perform

Perform in Your Career

 

Common Features

WORKSHOP 1: The Common Features of Microsoft Office

PREPARE CASE: Painted Paradise Resort and Spa Employee Training Preparation

Working with the Office Interface

Understand Office Applications and Accounts

Understanding Versions of Microsoft Office 2013

Using Office 2013 on a Mac

Obtaining a Microsoft Account

Start Office Programs and Manipulate Windows

Opening the Microsoft Word Start Screen

Opening the Microsoft Excel Start Screen

Switching Between Open Programs and Files

Maximizing and Minimizing the Application Window

Zooming and Scrolling

Use the Office Ribbon, Contextual Tools, and Other Menus

Using the Ribbon Tabs

Using Buttons

Using Galleries and Live Preview

Opening Dialog Boxes and Task Panes

Inserting Images and Using Contextual Tools

Accessing the Mini Toolbar

Using Shortcut Menus

Manipulating Files and Finding Help in Office

Manage Files in Office

Using Office Backstage View

Saving a File

Modifying Saved Files

Closing a File and Exiting an Application

Opening a File from the Recent Documents List

Get Help

Using the Help Window

Using ScreenTips

Print and Share Files

Printing a File

Exporting a PDF

Understanding the Cloud and Touch Integration

Use Windows SkyDrive

Creating a Document on SkyDrive

Roaming Settings

Inserting Apps for Office

Use Touch Mode, Gestures, and Reading Mode

Using Touch Mode

Using Touch Gestures

Using Reading View

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Perform in Your Life

 

Cloud Mobile computing

WORKSHOP 1: Mobile Computing

PREPARE CASE: Women’s Golf Getaway Collaboration

Understanding Mobile Computing

Understand Different Tablet Computers

View Documents on Mobile Devices

View and Edit Documents on an iPad

Open the Starting File

Editing Word Documents with Quickoffice

Editing Excel Documents with Quickoffice

Entering Formulas with Quickoffice 154

Share Documents with Mobile Devices

Sharing Documents with Quickoffice

View and Edit Documents on an Android Tablet

Editing Documents with Kingsoft Writer

Entering Formulas with Kingsoft Spreadsheets

Freezing Panes with Kingsoft Spreadsheets

Sharing Documents with Kingsoft

View and Edit Documents on a Surface Tablet

Editing Word Documents with Office 2013 RT on a Tablet Computer

Editing Excel Worksheets with Office 2013 RT on a Tablet Computer

Adding a Chart with Office 2013 on a Tablet Computer

Concept Check

Key Terms

Visual Summary

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

 

Word Module 1

WORKSHOP 1: Review and Modify a Document

PREPARE CASE: Putts for Paws Golf Tournament Memo

Understanding Business Communication

Use Word-Processing Software

Open a File

Develop Effective Business Documents

Work with Business Correspondence

Working with Memos and Business Letters

Editing a Document

Explore the Word Interface

Changing the View

Showing Nonprinting Characters

Inserting and Deleting Text

Moving Around a Document

Viewing Backstage and Working with Word Options

Format Characters

Selecting Text

Changing Font Type, Size, and Color

Format Paragraphs

Adjusting Paragraph Alignment

Working with Paragraph Spacing

Working with Line Spacing

Proofread a Document

Checking Spelling and Grammar

Using AutoCorrect

Finding and Replacing Text

Insert a Header and Footer

Adding Fields to a Header or Footer

Save and Close a Document

Saving a Document to SkyDrive

Saving a Document to a PDF File

Editing a PDF File

Print a Document

Exploring Print Settings

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform In Your Life

 

WORKSHOP 2: Create and Edit a Document

PREPARE CASE: Red Bluff Caddy School Flyer

Creating and Styling a Document

Create a New Document

Opening a New Blank Document

Displaying the Ruler

Cutting, Copying, and Pasting Text

Dragging and Dropping Text

Understand Word Styles

Working with Styles

Using the Normal Style

Using the Navigation Pane

Creating a New Style

Modifying a Style

Copy and Clear Formats

Using Format Painter

Using Clear Formatting

Using Format Painter on Multiple Selections

Add Bullets, Numbers, and Symbols

Selecting Bullets and Numbers

Defining New Bullets

Inserting Symbols

Set Line and Paragraph Indents

Paragraph Indentation

Work with Templates

Working with Template Placeholders

Formatting a Document

Change Page Setup

Changing Page Orientation

Changing Margins

Centering a Page Vertically

Change Page Background

Changing Page Color

Inserting a Watermark

Adding a Page Border

Adding Borders and Shading

Use Themes

Working with a Theme

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

WORD MODULE 1 CAPSTONE

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

How Others Perform

 

Word Module 2

WORKSHOP 3: Include Tables and Objects

PREPARE CASE: Turquoise Oasis Spa Services Publication

Including Objects in a Document

Use WordArt

Opening the Starting File

Creating and Selecting a WordArt Object

Formatting a WordArt Object

Resizing a WordArt Object

Repositioning a WordArt Object Using Alignment Guides and Live Layout

Understanding Anchors

Create SmartArt

Identifying Types of SmartArt

Modifying SmartArt

Formatting SmartArt

Insert a Text Box

Creating a Text Box

Modifying a Text Box

Insert Graphics

Inserting a Picture

Formatting a Picture

Inserting Clip Art

Formatting Clip Art

Working with Tabs and Tables

Set Tabs

Using the Ruler to Set Tabs

Using the Tabs Dialog Box

Create a Table

Entering Data in a Table

Inserting and Deleting Columns and Rows

Merging and Splitting a Row

Formatting a Table

Resizing and Aligning a Table

Converting Text into a Table

Sorting Table Data

Managing Pages

Work with Page Breaks

Avoiding Orphan and Widow Lines

Working with the End of a Page

Work with Sections

Inserting a New Section

Insert Text from Another Document

Creating a Cover Page by Inserting Text from Another Document

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

 

WORKSHOP 4: Special Document Formatting and Mail Merge

PREPARE CASE: Turquoise Oasis Spa Newsletter

Creating a Research Paper

Format a Research Paper

Opening the Starting File

Working with Spacing and Indentation in a Research Paper

Working with Headers in a Research Paper

Inserting Citations

Adding Footnotes and Endnotes

Develop a Bibliography or Works Cited Page

Using an Annotated Bibliography

Creating a Bibliography or Works Cited Page

Editing a Bibliography or Works Cited Page

Reviewing a Document

Work with Comments

Reviewing Comments

Deleting and Adding Comments

Track Changes

Viewing a Changed Document

Accepting and Rejecting Changes

Creating a Newsletter

Work with Columns

Formatting in Columns

Inserting a Drop Cap

Balancing Columns

Using Pictures in a Columnar Layout

Use a Style Guide to Format a Newsletter

Inserting a Company Logo in a Header

Formatting a Newsletter

Creating a Mail Merge Document

Use Mail Merge

Creating a Mail Merge Document

Beginning a Mail Merge

Selecting a Data Source

Completing the Letter

Designing a Salutation Line

Previewing Letters

Completing a Mail Merge

Create Mailing Labels and Envelopes

Selecting Labels

Selecting Recipients and Arranging Labels

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

WORD MODULE 2 CAPSTONE

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

How Others Perform

 

Excel Module 1

WORKSHOP 1: Navigate, Manipulate, and Print Worksheets

PREPARE CASE: Red Bluff Golf Course and Pro Shop Golf Cart Purchase Analysis

Excel—What If Data and Information Could Speak?

Understand Spreadsheet Terminology and Components

What Is a Spreadsheet?

What Is a Workbook?

Navigate Within Worksheets and Workbooks

Navigate Among Worksheets

Navigating Worksheets

Touch Devices

Document Your Work

Using Comments to Document a Workbook

Using a Worksheet for Documentation

Enter and Edit Data

Using Text, Numbers, Dates, and Times

Storing Date and Time Data

Wrapping Text and Line Breaks

Manipulate Cells and Cell Ranges

Cutting, Copying, and Pasting

Selecting Cell Ranges

Dragging and Dropping

Modifying Cell Information

Inserting and Deleting Cells

Merging and Centering vs. Centering Across

Manipulate Columns and Rows

Selecting Contiguous and Noncontiguous Columns and Rows

Inserting Columns and Rows

Adjusting Column Width and Row Height

Changing Column Widths Using AutoFit

Deleting vs. Clearing

Inserting Columns That Contain Data

Manipulating and Printing Workbooks and Worksheets

Manipulate Worksheets and Workbooks

Creating a New Workbook

Moving and Copying Worksheets Between Workbooks

Deleting, Inserting, and Renaming a Worksheet

Using Series (AutoFill)

Moving and Copying a Worksheet

Preview, Export, and Print Worksheets

Exporting a Workbook to PDF

Using Worksheet Views

Using Print Preview and Printer Selection

Using Print Titles

Adding Headers and Footers

Changing Page Margins and Scaling

Changing Page Orientation and Print Range

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

WORKSHOP 2: Formatting, Functions, and Formulas

PREPARE CASE: Red Bluff Golf Course & Pro Shop Sales Analysis

Worksheet Formatting

Format Cells, Cell Ranges, and Worksheets

Number Formatting

Displaying Negative Values and Color

Formatting Date and Time

Aligning Cell Content

Setting Content Orientation

Changing Fill Color

Adding Cell Borders

Copying Formats

Paste Options/Paste Special

Using Built-In Cell Styles

Inserting a Picture

Applying Table Styles

Changing Themes

Creating Information for Decision Making

Create Information with Functions

Using the SUM, COUNT, AVERAGE, MIN, and MAX Functions

Using the SUM Function by Selecting Destination Cells

Using SUM Function by Selecting Source Cells

Using COUNT and AVERAGE

Using MIN and MAX

Calculate Totals in a Table

Using Tables and the Total Row

Create Information with Formulas

Using Operators

Applying Order of Operations

Use Conditional Formatting to Assist Decision Making

Highlighting Values in a Range with Conditional Formatting

Applying Conditional Formatting to Assess Benchmarks Using Icon Sets

Using Conditional Formatting to Assess Benchmarks Using Font Formatting

Removing Conditional Formatting

Hide Information in a Worksheet

Hiding Worksheet Rows

Hiding Worksheet Gridlines

Document Functions and Formulas

Showing Functions and Formulas

Updating Existing Documentation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

EXCEL Module 1 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

How Others Perform

 

Excel Module 2

WORKSHOP 3: Cell References, Named Ranges, and Functions

PREPARE CASE: Painted Paradise Resort and Spa Wedding Planning

Referencing Cells and Named Ranges

Understand the Types of Cell References

Opening the Starting File

Using Relative Cell Referencing

Using Absolute Cell Referencing

Using Mixed Cell Referencing

Create Named Ranges

Creating Named Ranges Using the Name Box

Modifying Named Ranges

Using Named Ranges

Creating Named Ranges from Selections

Understanding Functions

Create and Structure Functions

Use and Understand Math and Statistical Functions

Using Math and Trig Functions

Inserting a Function Using Formula AutoComplete

Using Statistical Functions

Use and Understand Date and Time Functions

Using Date and Time Functions

Use and Understand Text Functions

Using Text Functions

Using the Flash Fill

Use Financial and Lookup Functions

Using Lookup and Reference Functions

Using Financial Functions

Use Logical Functions and Troubleshoot Functions

Using Logical Functions

Troubleshooting Functions

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

 

WORKSHOP 4: Effective Charts

PREPARE CASE: Turquoise Oasis Spa Sales Reports

Designing a Chart

Explore Chart Types, Layouts, and Styles

Opening the Starting File

Modifying an Existing Chart

Explore the Positioning of Charts

Creating Charts in an Existing Worksheet

Modifying a Chart’s Position Properties

Placing Charts on a Chart Sheet

Understand Different Chart Types

Creating Pie Charts

Creating Line Charts

Creating Column Charts

Creating Bar Charts

Creating Scatter Charts

Creating Area Charts

Creating Combination Charts

Exploring Chart Layouts

Change Chart Data and Styles for Presentations

Changing the Appearance of a Chart

Inserting Objects

Exploring Titles for the Chart and Axes

Working with the Legend and Labeling the Data

Modifying Axes

Changing Gridlines

Analyzing with Trendlines

Edit and Format Charts to Add Emphasis

Adding Color to Chart Objects

Working with Text

Exploding Pie Charts

Changing 3-D Charts and Rotation of Charts

Effectively Using Charts

Use Sparklines and Data Bars to Emphasize Data

Emphasizing Data

Exploring Sparklines

Inserting Data Bars

Recognize and Correct Confusing Charts

Correcting a Confusing Chart

Preparing to Print a Chart

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

EXCEL Module 2 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

How Others Perform

 

ACCESS MODULE 1

WORKSHOP 1: The Four Main Database Objects

PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament

Understanding Database Basics and Tables

Understand What Access Is

Understanding the Four Main Objects in a Database

Creating a New Database and Templates

Maneuver in the Navigation Pane

Opening and Closing the Shutter Bar

Customizing the Navigation Pane

Using the Search Box

Understanding File Extensions in Access

Understand What a Table Is

Importing a Table

Navigating Through a Table

Navigating Through a Table with the Navigation Bar

Understanding Differences Between Access and Excel

Manually Navigate a Database

Using a Manual Query to Discover a Database

Understanding Queries, Forms, and Reports

Understand What a Query Is

Creating a Query Using a Wizard

Selecting a Value Using Design View

Selecting Values in a Query

Sorting Query Results

Printing Query Results

Understand What a Form Is

Creating a Form

Entering Data via a Form

Understand What a Report Is

Creating a Report Using a Wizard

Printing a Report

Backing Up a Database

Creating a Backup

Compact a Database

Compacting Your Database

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

WORKSHOP 2: Tables, Keys, and Relationships

PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament Database

Inserting Data into a Database

Understand Database Design

Opening the Starting File

Understanding Data and Design Views of Tables

Import Data from Other Sources

Copying and Pasting

Importing a Worksheet

Importing from a Named Range

Importing from a Text File

Enter Data Manually

Entering Data Using Datasheet View

Removing Data

Understanding Tables and Keys

Create a Table in Design View

Defining Data Types

Determining Field Size

Changing Data Type

Understand Masks and Formatting

Defining Input Masks

Formatting

Understand and Designate Keys

Understanding Primary Keys

Understanding Foreign Keys

Composite Keys

Understanding Natural vs. Numeric Keys

Understanding Relational Databases

Understand Basic Principles of Normalization

Representing Entities and Attributes

Minimizing Redundancy

Understand Relationships Between Tables

Using the Relationships Window

Determining Relationship Types

Create a One-to-Many Relationship

Forming the Relationship

Using Two Related Tables in a Report

Create a Many-to-Many Relationship

Forming a New Many-to-Many Relationship

Creating a Junction Table

Creating Two One-to-Many Relationships

Populating the Junction Table

Defining One-to-One Relationships

Understand Referential Integrity

Enforcing Referential Integrity

Selecting Cascade Update

Selecting Cascade Delete

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 1 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

 

Access Module 2

WORKSHOP 3: Queries and Data Access

PREPARE CASE: Turquoise Oasis Spa Data Management

Working with Datasheets

Find and Replace Records in the Datasheet

Opening the Starting File

Finding Records in a Table

Finding and Replacing Data in a Datasheet

Using a Wildcard Character

Applying a Filter to a Datasheet

Filtering by Selection

Using a Text Filter

Modify Datasheet Appearance

Changing the Look of a Datasheet

Querying the Database

Run Query Wizards

Creating a Find Duplicates Query

Creating a Find Unmatched Query

Create Queries in Design View

Creating a Single-Table Query

Viewing Table Relationships

Creating a Query from Multiple Tables

Removing a Table from a Query to Fix an Undesirable Multiplier Effect

Sort Query Results

Sorting by One Field

Sorting by More than One Field

Define Selection Criteria for Queries

Using a Comparison Operator

Hiding Fields That Are Used in a Query

Sorting on a Field That You Do Not Show

Using Is Null Criteria

Using the AND Logical Operator

Using the OR Logical Operator

Combining the AND and OR Logical Operators

Combining Multiple AND and OR Logical Operators

Combining Operators and Multiple Criteria

Using Special Operators and Date Criteria

Combining Special Operators and Logical Operators

Create Aggregate Functions

Adding a Total Row

Using Aggregate Functions in a Query

Changing Field Names

Creating Calculations for Groups of Records

Troubleshooting an Aggregate Query

Formatting a Calculated Field

Create Calculated Fields

Building a Calculated Field Using Expression Builder

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

WORKSHOP 4: Access Information from an Access Database

PREPARE CASE: Turquoise Oasis Spa's New Database

Creating Customized Forms

Navigate in Datasheets and Forms

Opening the Starting File

Editing a Table in Datasheet View

Navigating Forms and Subforms

Navigating a Main Form

Navigating a Form with a Subform

Navigating a Split Form

Using the Find Command in a Form

Update Table Records Using Forms

Adding Records

Editing Records

Deleting Records

Create a Form Using the Form Wizard

Exploring Form Views

Creating Subforms (Multiple-Table Forms)

Creating a Split Form

Modify a Form's Design

Changing the Form Theme

Resizing and Changing Controls

Adding a Picture to the Form

Printing a Record from a Form

Creating Customized Reports

Create a Report Using the Report Wizard

Creating a Single-Table Report

Creating a Multiple-Table Report

Exploring Report Views

Creating Totals Using the Report Wizard

Customize a Report

Moving, Resizing, and Formatting Report Controls

Enhancing a Report with Conditional Formatting

Applying Grouping and Sorting

Adding Subtotals

Save a Report as a PDF File

Creating a PDF File

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 2 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

PowerPoint Module 1

WORKSHOP 1: Presentation Fundamentals

PREPARE CASE: The Red Bluff Golf Course & Pro Shop Putts for Paws Golf Tournament Presentation

Understanding the Purpose of PowerPoint

Plan Your Presentation with a Purpose for an Intended Outcome

Informing Your Audience

Persuading Your Audience

Preparing Your Audience

Telling a Story

Define the Purpose, Scope, and Audience of a Presentation

Opening PowerPoint

Considering the Target Audience and Their Needs

Understanding Commonality with Your Audience

Anticipating Audience Expectations

Understanding Your Audience’s Interaction with the Presentation

Plan the Presentation Content

Using a Storyboard

Using Anecdotes and Quotations

Encouraging Audience Participation

Including Quantitative and Statistical Content

Using Appropriate Media

Respecting Copyrights

Work with the PowerPoint Window and Views

Displaying the Presentation in Various Views

Navigate in Slide Show View and Outline View

Navigating the Presentation in Various Views

Promoting, Demoting, and Moving Text in Outline View

Understanding Effective Communication

Understand the Difference Between a Theme and a Template

Applying a Design Theme

Modifying a Theme

Using Color Strategically

Create a Presentation from a Template

Using a Template to Create a New Presentation

Reusing Slides

Inserting Footers

Modifying the Slide Background

Add and Delete Slides, Change Slide Layouts, and Rearrange Slides

Adding a New Slide

Changing the Slide Layout

Deleting Slides

Moving Slides in the Left Hand Pane

Edit Slides and Move Slide Content

Editing Slides

Moving Slide Content

Replace Words Using the Research Pane

Saving and Printing a Presentation

Save a Presentation

Saving Your Presentation in Different Formats

Preview and Print a Presentation

Printing Slides

Printing Handouts

Printing the Outline

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

WORKSHOP 2: Text and Graphics

PREPARE CASE: The Red Bluff Caddy School Presentation

Using Text Effectively

Modify Text

Understanding Print-Friendly and Screen-Friendly Fonts

Making Font Selections

Providing an Appropriate Amount of Text on a Slide

Modifying Fonts in a Presentation

Aligning Text

Use Text Hierarchy to Convey Organization

Using Lists

Reuse Formats

Using the Format Painter

Use Special Symbols

Using the Symbol Dialog Box

Selecting and Using Appropriate Graphics

Work with Images and Art

Adding Guides

Inserting Graphics

Resizing and Cropping Graphics

Rotating and Flipping Graphics

Changing the Color of Graphics

Modifying the Picture Style of Graphics

Work with Shape and Line Graphics

Applying Line Gradients

Applying Shape Gradients

Applying Shape Styles

Duplicating Shapes

Arranging Shapes

Aligning Shapes

Merging Shapes

Using Elements to Communicate Information

Create a Table

Inserting a Table

Changing the Table Style and Applying Table Effects

Changing the Table Layout

Create and Insert Charts

Inserting a Chart

Changing the Chart Type

Changing the Chart Layout

Changing Chart Elements

Create a SmartArt Graphic

Using SmartArt

Customizing SmartArt

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Power Point MODULE 1 CAPSTONE

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

How Others Perform

 

PowerPoint Module 2

WORKSHOP 3: Multimedia and Motion

PREPARE CASE: The Turquoise Oasis Spa Presentation for Marketing

Using Motion and Multimedia in a Presentation

Use Transitions and Animations

Opening the Starting File

Applying Effective Transitions

Editing Transitions

Animating Objects for Emphasis

Adding Motion Paths

Create Hyperlinks Within a Presentation

Linking to Other Slides

Creating Hyperlinks to Websites

Adding Action Buttons

Hiding Slides

Adding a Trigger

Apply and Modify Multimedia in Presentations

Inserting Audio Files

Recording Slide Narration

Inserting Video Files

Creating Useful Photo Albums

Create a PowerPoint Photo Album

Selecting Photographs

Modifying Photographs

Arranging Photographs

Inserting Text

Selecting a Theme

Editing a Photo Album

Create a Custom Slide Show

Customizing a Slide Show

Save a Presentation in Multiple Formats

Saving and Sending a Presentation via E-Mail

Saving a PowerPoint Presentation as a Video

Packaging a Presentation for a CD

Creating Handouts in Word Format

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

WORKSHOP 4: Customization and Collaboration

PREPARE CASE: Corporate Identity Template

Creating a Corporate Identity with a Custom Template

Create a Custom Template Using the Slide Master

Opening the Starting File

Modifying the Slide Master Theme

Customizing Slide Master Layouts

Adding a New Slide Layout

Placing Text on the Slide

Customize the Notes Master

Modifying Headers and Footers

Modifying Slide and Notes Placeholders

Customize the Handout Master

Modifying the Headers and Footers

Setting Up the Page

Develop a Presentation from a Custom Template and an Outline

Using a Custom Template

Importing an Outline into a Presentation

Use Slide Sections and Proofing Tools to Organize and Prepare a Presentation

Using Slide Sections

Using Proofing Tools

Collaborating and Presenting

Create Comments

Navigate Comments

Create and use Speaker Notes

Mark Presentations as Final and Apply Password Protection

Delivering a Presentation

Develop Skills in Delivering Presentations

Overcoming Presentation Nervousness

Being Prepared

Engaging Your Audience

Introducing and Providing a Road Map for Your Audience

Annotating Slides

Displaying the Presentation in Presenter View

Concluding Your Presentation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

Power Point MODULE 2 CAPSTONE

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

How Others Perform

 

Integrated Projects

WORKSHOP 1: Word and Excel Integration

PREPARE CASE: Updated Menu

Object Linking and Embedding

Linking Objects

Link an Object

Linking an Excel Chart to a Word Document

Update a Linked Object

Updating a Linked Excel Chart in a Word Document

Embedding Objects

Embed an Object

Embedding an Excel Chart in a Word Document

Modify an Embedded Object

Modifying an Embedded Chart in a Word Document

Modifying a Chart in an Excel Workbook

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Practice Case 2

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Career

How Others Perform

 

WORKSHOP 2: Word, Excel, and Access Integration

PREPARE CASE: Coupon Mailing

Use Excel Data in Access

Prepare Excel Data for Export to Access

Preparing an Excel List for Export

Import Excel Data into Access

Importing an Excel List into an Access Table

Use Access Data in Word

Prepare Access Data for a Mail Merge

Querying Data in an Access Database

Export Access Query Results to Word

Exporting Data for a Mail Merge

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Practice Case 2

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Career

How Others Perform

 

WORKSHOP 3: Word, Excel, Access, and PowerPoint Integration

PREPARE CASE: Indigo5 Restaurant Training

Integrating Word and PowerPoint

Work in Outline View

Working with Levels in Outline View

Rearranging a Word Outline

Create a PowerPoint Presentation from a Word Outline

Creating PowerPoint Slides from a Word Outline

Resetting Formatting of Slides Inserted from an Outline

Integrating Access and PowerPoint

Insert Access Data into a PowerPoint Presentation

Copying and Pasting Access Data

Integrating Access, Excel, and PowerPoint

Import Access Data into Excel 1

Creating a Chart with Imported Access Data

Linking an Excel Chart to a PowerPoint Presentation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Practice Case 2

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Career

How Others Perform

APENDIX

APPENDIX: Efficient Interaction with a Touchscreen

PREPARE CASE: Painted Paradise Resort and Spa Works with Touch Features

Interacting with a Windows 8 Tablet PC

Variations in Tablets

Methods of Interacting with a Tablet PC

Inputting Text with Speech Recognition

Using the Keyboard and Trackpad

Using the Digitizer Pen

Understanding When the Touch Interface Is Effective

Using the Touch-Screen Interface

Types of Touch Gestures

Using Flick Gestures

Using Touch Gestures

Using Bezel Gestures

Gestures Inside Office 2013

Other Touch Features

Using the Touch Keyboard

Using Alternatives to a Touch Screen

Concept Check

Key Terms

GLOSARY Available on Companion Website

INDEX