New Perspectives on Microsoft Office 2007 Brief Video Companion DVD

by Shaffer, Ann; Carey, Patrick M.; Finnegan, Kathy T.; Adamski, Joseph J.; Zimmerman, Beverly B.

• ISBN13: 9781439039403
• ISBN10: 1439039402
• Edition: 1st
• Format: Digital
• Copyright: 2009-04-02
• Publisher: Cengage Learning

Summary

Help your students learn and retain the most challenging and important topics of Microsoft Office 2007 using a medium that they use daily: video! NEW PERSPECTIVES ON MICROSOFT OFFICE 2007, BRIEF, VIDEO COMPANION contains 45 illustrative videos between 5-7 minutes in length that go beyond simply showing how to complete tasks. Each video begins with a conceptual explanation and then is followed by a practical demonstration of that skill within the application. This video companion maps directly to the New Perspectives on Microsoft Office 2007, Brief textbook.

Table of Contents

Welcome Video.

Downloading Student Data Files

Exploring the Basics of Microsoft Windows Vista

Touring the Windows Vista Desktop

Exploring Your Computer

Managing Your Files

Organizing Files and Folders

Working with Files and Folders

Getting Started with Microsoft Office 2007

Exploring Common Window Elements

Using Contextual Tools

Word Tutorial 1: Creating a Document

Exploring the Word Window

Correcting Errors

Understanding Line and Paragraph Spacing

Previewing and Printing a Document

Word Tutorial 2: Editing and Formatting a Document

Moving Text in a Document

Changing Margins

Aligning Text

Working with Themes and Fonts

Excel Tutorial 1: Getting Started with Excel

Understanding Spreadsheets

Planning a Workbook

Working with Formulas

Introducing Functions

Excel Tutorial 2: Formatting a Workbook

Formatting Data

Formatting Worksheet Cells

Working with Table Styles

Introducing Conditional Formats

Excel Tutorial 3: Working with Formulas and Functions

Understanding Cell References When Copying Formulas

Understanding Function Syntax

Working with AutoFill

Working with Logical Functions

Working with Financial Functions

Access Tutorial 1: Creating a Database

Introduction to Database Concepts

Creating a Table in Datasheet View

Entering Records

Managing a Database

Access Tutorial 2: Building a Database and Defining Table Relationships

Guidelines for Setting Field Properties

Creating a Table in Design View

Specifying the Primary Key

Defining Table Relationships

Access Tutorial 3: Maintaining and Querying a Database

Introduction to Queries

Defining Record Selection Criteria for Queries

Defining Multiple Selection Criteria for Queries

Creating a Calculated Field

Powerpoint Tutorial 1: Creating a Presentation

Switching Views and Navigating a Presentation

Modifying a Presentation

Adding a New Slide and Choosing a Layout

Promoting, Demoting, and Moving Outline Text

Table of Contents provided by Publisher. All Rights Reserved.