Your Office Microsoft Office 2013, Volume 1

by Kinser, Amy S.; Lending, Diane; O'Keefe, Tim P.; Pope, Charles; Shah, Anci

• ISBN13: 9780133148190
• ISBN10: 013314819X
• Edition: 1st
• Copyright: 2013-05-22
• Publisher: Pearson

Summary

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.

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

Windows 8

Windows 8 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

 

Windows 8 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

Working with Files

Copy, Move, Rename, and Delete Files

Zip Files

Extract Files

Add Tags to Files

Exploring the Windows 8 Desktop

Identify Desktop Elements

Understand the Taskbar

Working with Windows

Open and Manage Windows

Work with Multiple Windows

Personalizing the Desktop

Change the Appearance of the Desktop

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

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
Start Office Programs and Manipulate Windows
Use the Office Ribbon, Contextual Tools, and Other Menus
Manipulating Files and Finding Help in Office
Manage Files in Office
Get Help
Understanding the Cloud and Touch Integration
Use Windows SkyDrive
Use Touch Mode, Gestures, and Reading Mode

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

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

Share Documents with Mobile Devices

View and Edit Documents on an Android Tablet

View and Edit Documents on a Surface Tablet

Concept Check

Key Terms

Visual Summary

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Team

 

Word Module 1-Understanding Business Documents

Word WORKSHOP 1: Review and Modify a Document

PREPARE CASE: Putts for Paws Golf Tournament Memo

Understanding Business Communication
Using Word Processing Software
Develop Effective Business Documents
Work with Business Correspondence
Editing A Document
Explore the Word Interface
Format Characters
Format Paragraphs
Proofread a Document
Insert a Header and Footer
Save and Close a Document
Print a Document

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform In Your Life

 

Word WORKSHOP 2: Create and Edit a Document

PREPARE CASE: Red Bluff Caddy School Flyer

Creating and Styling a Document
Create a New Document
Understand Word Styles
Copy and Clear Formats
Add Bullets, Numbers, and Symbols
Set Line and Paragraph Indents
Work with Templates
Formatting a Document
Change Page Setup
Change Page Background
Use Themes

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-Impressing with Sophisticated Documents

Word WORKSHOP 3: Include Tables and Objects

PREPARE CASE: Turquoise Oasis Spa Services Publication

Including Objects in a Document
Use WordArt
Create SmartArt
Insert a Text Box
Insert Graphics
Working With Tabs and Tables
Set Tabs
Create a Table
Managing Pages
Work with Page Breaks
Work with Sections
Insert 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

 

Word WORKSHOP 4: Special Document Formatting and Mail Merge

PREPARE CASE: Turquoise Oasis Spa Newsletter

Creating a Research Paper
Format a Research Paper
Develop a Bibliography or Works Cited Page
Revising a Document
Inserting Comments
Tracking Changes
Creating a Newsletter
Work with Columns
Creating a Mail Merge Document
Using Mail Merge
Creating Labels and Envelopes

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-Understanding the Fundamentals

Excel WORKSHOP 1: Navigate, Manipulate, and Print Worksheets

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

Excel Worksheets–What If Data and Information Could Speak?
Understand Spreadsheet Terminology and Components
Navigate Worksheets and Workbooks
Document Your Work!
Enter and Edit Data
Manipulate Cells and Cell Ranges
Manipulate Columns and Rows
Printing Worksheets and Manipulating Workbooks
Preview and Print Worksheets
Manipulate Worksheets and Workbooks

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Excel WORKSHOP 2: Formatting, Functions, and Formulas

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

Worksheet Formatting
Format Cells, Cell Ranges, and Worksheets
Creating Information for Decision Making
What Is a Function?
What Is a Formula?
Decision Making
Documenting Your Work

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-Conducting Business Analysis

Excel WORKSHOP 3: Cell References, Named Ranges, and Functions

PREPARE CASE: Painted Paradise Resort and Spa Wedding Planning

Cell References and Named Ranges
Types of Cell References
Naming a Cell Range
Functions
Function Structure and Construction
Common Math and Statistical Functions
Common Date and Time Functions
Text Functions and Flash Fill
Financial and Lookup & Reference Functions

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Life

 

Excel WORKSHOP 4: Effective Charts

PREPARE CASE: Turquoise Oasis Spa Sales Reports

Designing a Chart
Exploring Chart Characteristics: Types, Layouts, and Styles
Chart Locations
Chart Types
Laying out a Chart
Chart Layouts, Styles, and Data
Editing and Formatting Charts
Strategic Statements with Charts
Recognizing and Correcting Confusing Charts

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-Understanding and Using a Relational Database

Access 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
Maneuvering in the Navigation Pane
Understand what a Table Is
Manually Navigate a Database
Understanding Queries, Forms, and Reports
Understand what a Query Is
Understand what a Form Is
Understand what a Report Is
Backing Up Your Database
Compact and Repair a Database

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 2: Tables, Keys, and Relationships

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

Inserting Data into a Database
Importing Data from Other Sources
Manual Data Entry
Understanding Tables and Keys
Creating a Table in Design View
Understand Masks and Formatting
Understanding and Designating Keys
Understanding Relational Databases
Understanding Basic Principles of Normalization
Understanding Relationships
Create a One-to-Many Relationship
Create a Many-to-Many Relationship
Understanding Referential Integrity

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-Accessing, Maintaining, and Presenting Information

Access WORKSHOP 3: Queries and Data Access

PREPARE CASE: Turquoise Oasis Spa Data Management

Work With Datasheets
Find and Replace Records in the Datasheet
Modify Datasheet Appearance
Queries
Run Other Query Wizards
Create Queries in Design View
Sort Query Results
Define Selection Criteria for Queries
Create Aggregate Functions
Create Calculated Fields

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

Access WORKSHOP 4: Access Information from an Access Database

PREPARE CASE: Turquoise Oasis Spa's New Database

Creating Customized Forms
Navigate in datasheets and forms
Update Table Records Using Forms
Create a Form Using the Form Wizard
Modify a Form’s Design
Creating Customized Reports
Create a Report Using the Report Wizard
Use and Customize Access Themes
Modify a Report’s Design
Save a Report as 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

 

PowerPoint Module 1-Understanding the Art of Presentation

PowerPoint WORKSHOP 1: Presentation Fundamentals

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

Understanding the Purpose of PowerPoint
Presenting with a purpose for an intended outcome
Defining the purpose, scope, and audience of a presentation
Planning the presentation content
Working with the PowerPoint window and view modes
Navigating in slide show view and outline view
Understanding effective communication
Understanding the difference between a theme and a template
Creating a presentation from a template
Adding and deleting slides, changing slide layouts and rearranging slides
Editing slides and moving slide content
Using the research pane
Saving and Printing a Presentation
Saving a presentation
Previewing and appropriate printing of a presentation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

PowerPoint WORKSHOP 2: Text and Graphics

PREPARE CASE: The Red Bluff Caddy School Presentation

Using Text Effectively
Modifying text
Using Text hierarchy to Convey Organization
Reusing formats
Using Special Symbols
Selecting and using appropriate graphics
Working with images and art
Selecting and using appropriate graphics
Working with shape and line graphics
Using Elements to Communicate Information
Creating a table
Creating and inserting charts
Creating a SmartArt graphic

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-Collaborating and Invoking Emotion with the Audience

PowerPoint WORKSHOP 3: Multimedia and Motion

PREPARE CASE: The Turquoise Oasis Spa Presentation for Marketing

Using motion in a presentation
Using transitions and animations
Using Multimedia in a presentation
Using linking
Inserting audio
Inserting Video
Working with photo albums
Creating a custom slide show
Using Multimedia in a presentation
Saving and sending a presentation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

 

PowerPoint WORKSHOP 4: Customization and Collaboration

PREPARE CASE: Corporate Identity Template

Creating a corporate identity with a custom template
Modifying the slide master
Customizing the Notes and handout master
Using a custom template
Importing an outline
Using Slide sections
Using Proofing Tools and Checking Spelling
Collaborating with others on a presentation
Co-authoring & Sharing Presentations
Creating speaker notes
Protecting presentations
Delivering a presentation
Overcoming presentation nerves and being prepared
Engaging your audience and providing a roadmap for your audience
Annotating slides
New Presentation Mode including Auto Extend
Using presenter view, widescreen and slide zoom
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

Object Linking and Embedding
Link an Object
Update a Linked Object
Embed an Object
Modify an Embedded Object

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 Import
Import Excel Data
Use Access Data in Word
Prepare Access Data for a Mail Merge
Export Query Results from Access to Word

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: Integrating Word, Excel, Access, and PowerPoint

PREPARE CASE: Restaurant Training

Integrate Word and PowerPoint
Open Outline View
Integrate Access and PowerPoint
Insert Access Data into a PowerPoint Presentation
Integrate Access, Excel, and PowerPoint
Import Access Data into Excel

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