OPAMP Opamp Technical Books
1033 N. Sycamore Ave.
Los Angeles, CA 90038
WWW.OPAMP.COM
1 - 800 - 468 - 4322

8:00am-4:30pm M-F
9:00am-5:30pm Sat
  • DISCOUNTS APPLY TO SHIPPED ORDERS ONLY!
  • Price and Availability subject to change.
  • We confirm your order status by e-mail.
 

Keywords: microsoft office 2010
Your search found 182 books
Now viewing Books 1 - 25
In stock items ship IMMEDIATELY.
Other titles usually ship within 2-3 days.

70-667: Microsoft Office SharePoint 2010 Configuration Lab Manual
Microsoft Official Academic Course (Mic2011
WILEYSISBN-10: 0470538686
ISBN-13: 9780470538685
  PGS: 0List: 34.95     YOUR PRICE: 33.20

70-667: Microsoft Office SharePoint 2010 Configuration Textbook
Microsoft Official Academic Course (Mic2011
WILEYSISBN-10: 0470538678
ISBN-13: 9780470538678
  PGS: 0List: 132.95     YOUR PRICE: 126.30

70-667: Microsoft Office SharePoint 2010 Configuration, Package
Microsoft Official Academic Course (Mic2011
Chapter 1: Introducing SharePoint 2010@pChapter 2: Installing SharePoint 2010@pChapter 3: Configuring SharePoint 2010@pChapter 4: Managing Web Applications@pChapter 5: Deploying and Managing SharePoint Features and Solution Packages@pChapter 6: Managing Accounts and User Roles@pChapter 7: Configuring Service Applications@pChapter 8: Configuring Indexes and Searches@pChapter 9: Monitoring SharePoint@pChapter 10: Managing Authentication Providers@pChapter 11: Backing Up and Restoring the SharePoint Environment@pChapter 12: Optimizing SharePoint Performance@p
WILEYSISBN-10: 0470487364
ISBN-13: 9780470487365
  PGS: 0List: 136.95     YOUR PRICE: 130.10

A Guided Tour of Microsoftr Office 2010, 1st Ed.
Corinne Hoisington2011
Contents: Welcome to Office 2010. WHAT'S NEW IN WORD 2010 PART 1. Screen Clipping. New Graphics Tools. Backstage. New Print features. WHAT'S NEW IN WORD 2010 PART 2. Paste Preview feature. Find feature. Online Collaboration. Author Permissions. Manage Versions feature. WHAT'S NEW IN EXCEL 2010 PART 1. Sparklines. Data Slicer. Improved Conditional Formatting. WHAT'S NEW IN POWERPOINT 2010 PART 1. New Graphics Tools. Background Removal Tool. Screen Clipping. New Animations and Transitions. WHAT'S NEW IN POWERPOINT 2010 PART 2. Better Smart Art. Equation Editor. Action Tool. WHAT'S NEW IN ACCESS 2010. Data Type Gallery. Office Themes. Backstage View. Auto Scale. Center Vertically. WHAT'S NEW IN PUBLISHER 2010. Ribbon Interface. Create an Event Flyer. Most Dramatic Change in Office 2010. WHAT'S NEW IN ONENOTE 2010. Basics of OneNote 2010. Ribbon Interface. Note taking Features of OneNote 2010. Audio & Video Features. MICROSOFT CLOUD COMPUTING WITH OFFICE 2010. Windows Live. Microsoft Live ID. SkyDrive. Photo Sharing. Office Web Application Sharing.
These engaging movie tutorials will help get you up and running on Microsoft Office 2010! Dynamic and engaging author Corrine Hoisington presents the highlights of Office 2010, the coolest new features, and how to transition smoothly from Office 2007 to Office 2010.
Course Technology - CENGAGEISBN-10: 0538750464
ISBN-13: 9780538750462
  PGS: N/AList: 23.95     YOUR PRICE: 22.75

Computer Concepts Brief and Microsoft Office 2010 Illustrated Introductory, 1st Ed.
June Jamrich Parson Dan Oja David Beskee2013
Course Technology - CENGAGESISBN-10: 1133611540
ISBN-13: 9781133611547
  PGS: N/AList: 162.95     YOUR PRICE: 154.80

Computer Concepts Brief and Microsoft Office 2010 Illustrated Introductory, 1st Ed.
David Beskeen Carol M. Cram Jennifer Duf2013
Course Technology - CENGAGEHISBN-10: 1133611583
ISBN-13: 9781133611585
  PGS: N/AList: 135.25     YOUR PRICE: 128.49

Discovering Computers and Microsoftr Office 2010: A Fundamental Combined Approach, 1st Ed.
Gary B. ShellyMisty E. Vermaat2011
Course Technology - CENGAGEISBN-10: 0538473932
ISBN-13: 9780538473934
  PGS: N/AList: 193.95     YOUR PRICE: 184.25

DVD Disk 1: Word and Excel for Cram/Friedrichsen/Wermers' Microsoft Office 2010: Illustrated Third Course, 1st Ed.
N/A2012
This video companion is your personal companion to Microsoft Office 2010 Illustrated - Third Course, containing over 120 video tutorials that are based on lessons in the book. Each five-minute video maps to a two-page lesson in the text and provides a visually dynamic overview of the key concepts and steps in that lesson. Combined with the book, these videos provide a rich learning experience to keep all students engaged and help them learn and retain skills.
Course TechnologyISBN-10: 1133191053
ISBN-13: 9781133191056
  PGS: 0List: 31.95     YOUR PRICE: 30.35

DVD for Beskeen/Cram/Duffy/Friedrichsen's Computer Concepts Brief and Microsoft Office 2010 Illustrated Introductory, 1st Ed.
N/A2013
Course Technology - CENGAGEISBN-10: 1133611591
ISBN-13: 9781133611592
  PGS: N/AList: 67.95     YOUR PRICE: 64.55

DVD: Microsoft Office 2010 Illustrated Introductory Video Companion, 1st Ed.
N/A2011
Course Technology - CENGAGE - CENGAGEISBN-10: 1111577560
ISBN-13: 9781111577568
  PGS: 0List: 67.95     YOUR PRICE: 64.55

Easy Microsoft Office 2010
Bunzel, Tom2010
Que - PEARSONISBN-10: 0789743280
ISBN-13: 9780789743282
  PGS: N/AList: 21.99     YOUR PRICE: 20.89

Exam 77-885 Microsoft Access 2010 with Microsoft Office 2010 Evaluation Software
Microsoft Official Academic Course (Mic2011
Lesson 1: Database Essentials@pLesson 2: Create Database Tables@pLesson 3: Work with Tables/Database Records@pLesson 4: Modify Tables and Fields@pLesson 5: Create Forms@pLesson 6: Create Reports@pLesson 7: Use Controls in Reports and Forms@pLesson 8: Create and Modify Queries@pLesson 9: Advanced Tables@pLesson 10: Creating and Formatting Advanced Forms@pLesson 11: Creating and Formatting Advanced Reports@pLesson 12: Advanced Queries@pLesson 13: Display and Share Data@pLesson 14: Import and Export Data@pLesson 15: Database Tools@p
WILEYSISBN-10: 0470907681
ISBN-13: 9780470907689
  PGS: 0List: 83.95     YOUR PRICE: 79.75

Exploring Microsoft Office 2010 Brief, 1st Ed.
Grauer, Robert T.
Poatsy, Mary Anne
2011
Prentice Hall - PEARSONSISBN-10: 0131367404
ISBN-13: 9780131367401
  PGS: N/AList: 147.40     YOUR PRICE: 140.03

Exploring Microsoft Office 2010 Getting Started with VBA, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne
M
2011

Exploring Getting Started with VBA for Microsoft Office 2010

 

Chapter 1 Getting Started with VBA

Chapter 2 Excel and VBA

Chapter 3 Customizing Access with VBA

Pearson Learning SolutionsSISBN-10: 1256184055
ISBN-13: 9781256184058
  PGS: N/AList: 33.00     YOUR PRICE: 31.35

Exploring Microsoft Office 2010 Getting Started with Web 2.0, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne
D
2010
Pearson Learning SolutionsSISBN-10: 0558727212
ISBN-13: 9780558727215
  PGS: N/AList: 33.00     YOUR PRICE: 31.35

Exploring Microsoft Office 2010 Getting Started with Web Apps, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne
L
2011

CHAPTER ONE ¤ Introduction to Windows Live 1

CASE STUDY: THE BELLINGHAM CORPORATION 1

OBJECTIVES 1

COLLABORATION ON THE WORLD WIDE WEB 2

Describing Cloud Computing 2

Accessing SkyDrive 5

Identifying the Components of the Windows Live Interface 7

HANDS-ON EXERCISE 1:

Collaboration on the World Wide Web 11

WINDOWS LIVE SKYDRIVE FEATURES 16

Using Folders on SkyDrive 16

Sharing Folders on SkyDrive 18

HANDS-ON EXERCISE 2:

Windows Live SkyDrive Features 21

WINDOWS LIVE SETTINGS AND HELP 25

Changing Windows Live Settings 25

Getting Help for Windows Live SkyDrive 28

HANDS-ON EXERCISE 3:

Windows Live Settings and Help 30

CHAPTER OBJECTIVES REVIEW 36

KEY TERMS 36

MULTIPLE CHOICE 37

PRACTICE EXERCISES 38

MID-LEVEL EXERCISES 40

CAPSTONE EXERCISE 42

BEYOND THE CLASSROOM 43

OFFICE WEB APPS

 

CHAPTER TWO ¤ Introduction to Office Web Apps 45

CASE STUDY: THE GET FIT WELLNESS PROGRAM 45

OBJECTIVES 45

DOCUMENT CREATION USING CLOUD COMPUTING 46

Identifying the Components of Office Web Apps 46

Uploading, Opening, Modifying, and Saving an Existing Word Document 49

Creating, Saving, and Sharing a Word Document 51

HANDS-ON EXERCISE 1: Document Creation Using Cloud Computing 54

WORKBOOKS AND PRESENTATIONS 58

Uploading, Opening, Modifying, and Saving an Existing Excel Workbook 58

Creating, Saving, and Sharing an Excel Workbook 60

Opening, Viewing, and Printing an Existing PowerPoint Presentation 62

Creating, Saving, and Sharing a PowerPoint Presentation 65

HANDS-ON EXERCISE 2: Workbooks and Presentations 67

ELECTRONIC NOTEBOOKS 72

Creating, Saving, and Sharing a New

OneNote Notebook 72

HANDS-ON EXERCISE 3: Electronic Notebooks 78

CHAPTER OBJECTIVES REVIEW 81

KEY TERMS 81

MULTIPLE CHOICE 82

PRACTICE EXERCISES 83

MID-LEVEL EXERCISES 85

CAPSTONE EXERCISE 87

BEYOND THE CLASSROOM 88

GLOSSARY 89

INDEX 91

Pearson Learning SolutionsSISBN-10: 1256022179
ISBN-13: 9781256022176
  PGS: N/AList: 33.00     YOUR PRICE: 31.35

Exploring Microsoft Office 2010 Plus, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne S.
2011
WINDOWS 7
Chapter 1 Getting Started with Windows 7

OFFICE

Chapter 1 Office Fundamentals and File Management

Word
Chapter 1 Introduction to Word
Chapter 2 Document Presentation
Chapter 3 Collaboration and Research
Chapter 4 Document Productivity

Excel
Chapter 1 Introduction to Excel
Chapter 2 Formulas and Functions
Chapter 3 Charts
Chapter 4 Datasets and Tables
Chapter 5 Subtotals, PivotTables, and PivotCharts
Chapter 6 What-If Analysis
Chapter 7 Specialized Functions

Access

Chapter 1 Introduction to Access
Chapter 2 Relational Databases and Queries
Chapter 3 Customize, Analyze, and Summarize Query Data
Chapter 4 Creating and Using Professional Forms and Reports
Chapter 5 PivotTables and PivotCharts
Chapter 6 Data Validation Techniques

PowerPoint
Chapter 1 Introduction to PowerPoint
Chapter 2 Presentation Development

Prentice Hall - PEARSONISBN-10: 0135091497
ISBN-13: 9780135091494
  PGS: N/AList: 159.00     YOUR PRICE: 151.05

Exploring Microsoft Office 2010 Volume 2, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne S.
2011

Exploring Office Volume 2

Table of Contents

 

 

WORD
Chapter 5: Desktop Publishing and Graphic Design

Creating a Newsletter, Working with Graphics, and Linking Objects

Chapter 6: Time Saving Tools

Using Templates, Themes, and Multiple Documents

Chapter 7: Document Automation

Forms, Macros, and Security

Chapter 8: Word and the Internet

Creating Web Pages, XML, and Blogs

 

EXCEL

Chapter 5: Subtotals, PivotTables, and PivotCharts

Summarizing and Analyzing Data

Chapter 6: What-If Analysis

Using Decision-Making Tools

Chapter 7: Specialized Functions

Analyzing Statistics, Databases, and Finances

Chapter 8: Multiple-Sheet Workbook Management

Ensuring Quality Control

Chapter 9: Imports, Web Queries, and XML

Managing Data

Chapter 10: Collaboration and Workbook Distribution

Sharing Data with Others

Chapter 11: Templates, Styles, and Macros

Standardizing Workbooks

 

ACCESS

Chapter 5: PivotTables and PivotCharts

Data Mining

Chapter 6: Data Validation Techniques

Using Tables, Forms, and Reports to Reduce Errors

Chapter 7: Advanced Queries

Moving Beyond the Select Query

Chapter 8: Get Connected

Exchanging Data Between Access and Other Applications

Chapter 9: Fine-Tuning the Database

Analyzing and Improving Database Performance

Chapter 10: Using Macros and SQL in Access

Advanced Techniques

 

POWERPOINT

Chapter 5: Infographics

Creating Text Charts, Tables, and Graphs

Chapter 6: Interactivity and Advanced Animation

Engaging the Audience

Chapter 7: Customization

Customizing PowerPoint and the Slide Show

Chapter 8: Collaboration and Distribution

Collaborating, Preparing, Securing, and Sharing a Presentation

 

Prentice Hall - PEARSONISBN-10: 013509108X
ISBN-13: 9780135091081
  PGS: N/AList: 154.20     YOUR PRICE: 146.49

Exploring Microsoft Office 2010, Volume 1, 1st Ed.
Grauer, Robert T.
Poatsy, Mary Anne
2011
Prentice Hall - PEARSONSISBN-10: 0136122329
ISBN-13: 9780136122326
  PGS: N/AList: 154.20     YOUR PRICE: 146.49

Exploring Microsoft Office 2010, Volume 1, 2nd Ed.
Grauer, Robert
Poatsy, Mary Anne S.
2013
Prentice Hall - PEARSONISBN-10: 0132873605
ISBN-13: 9780132873604
  PGS: N/AList: 154.20     YOUR PRICE: 146.49

Exploring Microsoft Office Access 2010 Comprehensive, 1st Ed.
Grauer, Robert T.
Poatsy, Mary Anne
2011
Prentice Hall - PEARSONSISBN-10: 0135098254
ISBN-13: 9780135098257
  PGS: N/AList: 122.00     YOUR PRICE: 115.90

Exploring Microsoft Office Access 2010 Introductory, 1st Ed.
Grauer, Robert T.
Poatsy, Mary Anne
2011
Prentice Hall - PEARSONSISBN-10: 0132092271
ISBN-13: 9780132092272
  PGS: N/AList: 85.60     YOUR PRICE: 81.32

Exploring Microsoft Office Excel 2010 Comprehensive, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne S.
2011

OFFICE FUNDAMENTALS AND FILE MANAGEMENT

CHAPTER ONE + Office Fundamentals and File Management

CASE STUDY: RAILS AND TRAILS

OBJECTIVES

FILES AND FOLDERS

Using Windows Explorer

Working with Folders and Files

Selecting, Copying, and Moving Multiple Files and Folders

HANDS-ON EXERCISE 1: Files and Folders

MICROSOFT OFFICE SOFTWARE

Identifying Common Interface Components

Getting Office Help

HANDS-ON EXERCISE 2: Microsoft Office Software

BACKSTAGE VIEW TASKS

Opening a File

Printing a File

Closing a File and Application

HANDS-ON EXERCISE 3: Backstage View Tasks

HOME TAB TASKS

Selecting and Editing Text

Using the Clipboard Group Tasks

Using the Editing Group Tasks

HANDS-ON EXERCISE 4: Home Tab Tasks

INSERT TAB TASKS

Inserting Objects

REVIEW TAB TASKS

Reviewing a File

PAGE LAYOUT TAB TASKS

Changing Page Settings

HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

MICROSOFT OFFICE EXCEL 2010

CHAPTER ONE + Introduction to Excel

CASE STUDY: OK OFFICE SYSTEMS

OBJECTIVES

INTRODUCTION TO SPREADSHEETS

Planning for Effective Workbook and Worksheet Design

Exploring the Excel Window

Entering and Editing Cell Data

HANDS-ON EXERCISE 1: Introduction to Spreadsheets

MATHEMATICS AND FORMULAS

Using Symbols and the Order of Precedence

Using Auto Fill

Displaying Cell Formulas

HANDS-ON EXERCISE 2: Mathematics and Formulas

WORKBOOK AND WORKSHEET MANAGEMENT

Managing Worksheets

Managing Columns and Rows

Selecting, Moving, Copying, and Pasting

HANDS-ON EXERCISE 3: Workbook and Worksheet Management

FORMATTING

Applying Alignment and Font Options

Applying Number Formats

HANDS-ON EXERCISE 4: Formatting

PAGE SETUP AND PRINTING

Selecting Page Setup Options

Printing a Worksheet

HANDS-ON EXERCISE 5: Page Setup and Printing

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER TWO + Formulas and Functions

CASE STUDY: DENVER MORTGAGE COMPANY

OBJECTIVES

FORMULA BASICS

Using Semi-Selection to Create a Formula

Using Relative, Absolute, and Mixed Cell References in Formulas

Avoiding Circular References

HANDS-ON EXERCISE 1: Formula Basics

FUNCTION BASICS

Inserting a Function

Totaling Values with the SUM Function

Inserting Basic Statistical Functions

Using Date Functions

HANDS-ON EXERCISE 2: Function Basics

LOGICAL, LOOKUP, AND FINANCIAL FUNCTIONS

Determining Results with the IF Function

Using Lookup Functions

Calculating Payments with the PMT Function

HANDS-ON EXERCISE 3: Logical, Lookup, and Financial Functions

RANGE NAMES

Creating and Maintaining Range Names

Using Range Names in Formulas

HANDS-ON EXERCISE 4: Range Names

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER THREE + Charts

CASE STUDY: HORT UNIVERSITY MAJORS

OBJECTIVES

CHART BASICS

Deciding Which Chart Type to Create

Creating a Chart

HANDS-ON EXERCISE 1: Chart Basics

CHART DESIGN

Changing the Chart Type

Changing the Data Source and Structure

Applying a Chart Layout and a Chart Style

Moving a Chart

Printing Charts

Inserting and Customizing a Sparkline

HANDS-ON EXERCISE 2: Chart Design

CHART LAYOUT

Selecting and Formatting Chart Elements

Customizing Chart Labels

Formatting the Axes and Gridlines

Adding a Trendline

HANDS-ON EXERCISE 3: Chart Layout

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER FOUR + Datasets and Tables

CASE STUDY: THE SPA EXPERTS

OBJECTIVES

LARGE DATASETS

Freezing Rows and Columns

Printing Large Datasets

HANDS-ON EXERCISE 1: Large Datasets

EXCEL TABLES

Understanding Table Design

Creating a Table

Applying a Table Style

HANDS-ON EXERCISE 2: Excel Tables

TABLE MANIPULATION AND AGGREGATION

Sorting Data

Filtering Data

Using Structured References and a Total Row

HANDS-ON EXERCISE 3: Table Manipulation and Aggregation

CONDITIONAL FORMATTING

Applying Conditional Formatting

Creating a New Rule

Sorting and Filtering Using Conditional Formatting

HANDS-ON EXERCISE 3: Conditional Formatting

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER FIVE + Subtotals, PivotTables, and PivotCharts

CASE STUDY: IVORY HALLS PUBLISHING COMPANY

OBJECTIVES

OUTLINES AND SUBTOTALS

Grouping and Ungrouping Data

Subtotaling Data

HANDS-ON EXERCISE 1: Outlines and Subtotals

PIVOTTABLE BASICS

Creating a PivotTable

Changing the Values Field

Modifying a PivotTable

HANDS-ON EXERCISE 2: PivotTable Basics

PIVOTTABLE OPTIONS

Sorting, Filtering, and Slicing a PivotTable

Creating a Calculated Field

HANDS-ON EXERCISE 3: PivotTable Options

PIVOTTABLE DESIGN AND PIVOTCHARTS

Formatting a PivotTable

Creating a PivotChart

HANDS-ON EXERCISE 4: PivotTable Design and PivotCharts

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER SIX + What-If Analysis

CASE STUDY: PERSONAL FINANCE: BUYING A CAR

OBJECTIVES

ONE- AND TWO-VARIABLE DATA TABLES

Creating a One-Variable Data Table

Creating a Two-Variable Data Table

HANDS-ON EXERCISE 1: One- and Two-Variable Data Tables

GOAL SEEK AND SCENARIO MANAGER

Identifying an Input Value with Goal Seek

Using Scenario Manager

Generating Scenario Summary Reports

HANDS-ON EXERCISE 2: Goal Seek and Scenario Manager

SOLVER

Loading the Solver Add-In

Optimizing Results with Solver

HANDS-ON EXERCISE 3: Solver

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER SEVEN + Specialized Functions

CASE STUDY: STANWORTH, INC.

OBJECTIVES

MATH AND STATISTICAL FUNCTIONS

Using Conditional Math and Statistical Functions

Calculating Relative Standing with Statistical Functions

HANDS-ON EXERCISE 1: Math and Statistical Functions

LOGICAL AND LOOKUP FUNCTIONS

Creating a Nested Logical Function

Using MATCH and INDEX Lookup Functions

HANDS-ON EXERCISE 2: Logical and Lookup Functions

DATABASE FILTERING AND FUNCTIONS

Using Advanced Filtering

Manipulating Data with Database Functions

HANDS-ON EXERCISE 3: Database Filtering and Functions

FINANCIAL FUNCTIONS

Creating a Loan Amortization Table

Performing Other Financial Calculations

HANDS-ON EXERCISE 4: Financial Functions

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER EIGHT + Multiple-Sheet Workbook Management

CASE STUDY: HEARTLAND DEPARTMENT STORE

OBJECTIVES

MULTIPLE WORKSHEETS

Working with Grouped Worksheets

Managing Windows and Workspaces

Inserting Hyperlinks

HANDS-ON EXERCISE 1: Multiple Worksheets

3-D FORMULAS AND LINKED WORKBOOKS

Inserting a 3-D Formula

Linking Workbooks

HANDS-ON EXERCISE 2: 3-D Formulas and Linked Workbooks

FORMULA AUDITS AND DATA VALIDATION

Auditing Formulas

Setting Up a Watch Window

Validating Data

HANDS-ON EXERCISE 3: Formula Audits and Data Validation

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER NINE + Imports, Web Queries, and XML

CASE STUDY: STOCK ANALYSIS

OBJECTIVES

EXTERNAL DATA

Importing Data from External Sources

Creating a Web Query

Managing Connections

HANDS-ON EXERCISE 1: External Data

TEXT MANIPULATION

Converting Text to Columns

Manipulating Text with Functions

HANDS-ON EXERCISE 2: Text Manipulation

XML

Understanding XML Syntax

Importing XML Data into Excel

HANDS-ON EXERCISE 3: XML

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER TEN + Collaboration and Workbook Distribution

CASE STUDY: CULINARY ARTS SCHOLARSHIP DINNER

OBJECTIVES

CUSTOMIZATION AND PERSONALIZATION

Customizing Excel

Changing Properties

HANDS-ON EXERCISE 1: Customization and Personalization

COLLABORATION

Sharing and Merging Workbooks

Inserting Comments

Tracking Changes

HANDS-ON EXERCISE 2: Collaboration

WORKBOOK INFORMATION

Checking for Issues

Protecting a Workbook

HANDS-ON EXERCISE 3: Workbook Information

WORKBOOK DISTRIBUTION

Saving a Workbook in Different Formats

Sending a Workbook to Others

HANDS-ON EXERCISE 3: Workbook Distribution

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER ELEVEN + Templates, Styles, and Macros

CASE STUDY: PERSONAL FINANCIAL CONSULTANT

OBJECTIVES

TEMPLATES, THEMES, AND STYLES

Selecting a Template

Applying Themes and Backgrounds

Applying Cell Styles

HANDS-ON EXERCISE 1: Templates, Themes, and Styles

CUSTOM TEMPLATES AND WORKBOOK PROTECTION

Creating and Using a Template

Protecting a Cell, a Worksheet, and a Workbook

HANDS-ON EXERCISE 2: Custom Templates and Workbook Protection

MACROS

Creating a Macro

Creating Macro Buttons

Setting Macro Security

HANDS-ON EXERCISE 3: Macros

CHAPTER OBJECTIVES REVIEW

Prentice Hall - PEARSONISBN-10: 0135098599
ISBN-13: 9780135098592
  PGS: N/AList: 122.00     YOUR PRICE: 115.90

Exploring Microsoft Office Excel 2010 Introductory, 1st Ed.
Grauer, Robert T.
Poatsy, Mary Anne
2011
Prentice Hall - PEARSONSISBN-10: 0135098475
ISBN-13: 9780135098479
  PGS: N/AList: 85.60     YOUR PRICE: 81.32

Exploring Microsoft Office PowerPoint 2010 Comprehensive, 1st Ed.
Grauer, Robert
Poatsy, Mary Anne S.
2011

OFFICE FUNDAMENTALS AND FILE MANAGEMENT

CHAPTER ONE + Office Fundamentals and File Management

CASE STUDY: RAILS AND TRAILS

OBJECTIVES

FILES AND FOLDERS

Using Windows Explorer

Working with Folders and Files

Selecting, Copying, and Moving Multiple Files and Folders

HANDS-ON EXERCISE 1: Files and Folders

MICROSOFT OFFICE SOFTWARE

Identifying Common Interface Components

Getting Office Help

HANDS-ON EXERCISE 2: Microsoft Office Software

BACKSTAGE VIEW TASKS

Opening a File

Printing a File

Closing a File and Application

HANDS-ON EXERCISE 3: Backstage View Tasks

HOME TAB TASKS

Selecting and Editing Text

Using the Clipboard Group Tasks

Using the Editing Group Tasks

HANDS-ON EXERCISE 4: Home Tab Tasks

INSERT TAB TASKS

Inserting Objects

REVIEW TAB TASKS

Reviewing a File

PAGE LAYOUT TAB TASKS

Changing Page Settings

HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

MICROSOFT OFFICE POWERPOINT 2010

CHAPTER ONE + Introduction to PowerPoint

CASE STUDY: BE A TRAINER

OBJECTIVES

INTRODUCTION TO POWERPOINT

Using PowerPoint Views

Saving as a Slide Show

HANDS-ON EXERCISE 1: Introduction to PowerPoint

PRESENTATION CREATION

Planning a Presentation

Assessing Presentation Content

Using Slide Layouts

Applying Themes

Reviewing the Presentation

HANDS-ON EXERCISE 2: Presentation Creation

PRESENTATION DEVELOPMENT

Inserting Media Objects

Adding a Table

Using Animations and Transitions

Inserting a Header or Footer

HANDS-ON EXERCISE 3: Presentation Development

NAVIGATION AND PRINTING

Running and Navigating a Slide Slow

Printing in PowerPoint 101

HANDS-ON EXERCISE 4: Navigation and Printing

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER TWO + Presentation Development

CASE STUDY: THE WELLNESS EDUCATION CENTER

OBJECTIVES

TEMPLATES

Creating a Presentation Using a Template

Modifying a Template

HANDS-ON EXERCISE 1: Templates

OUTLINES

Creating a Presentation in Outline View

Modifying an Outline Structure

Printing an Outline

HANDS-ON EXERCISE 2: Outlines

DATA IMPORTS

Importing an Outline

Adding Existing Content to a Presentation

HANDS-ON EXERCISE 3: Data Imports

DESIGN

Using Sections

Examining Slide Show Design Principles

Modifying a Theme

HANDS-ON EXERCISE 4: Design

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER THREE + Presentation Design

CASE STUDY: ILLUSTRATIONS AND INFOGRAPHICS

MINI-CAMP 1

OBJECTIVES 1

SHAPES

Creating Shapes

Applying Quick Styles and Customizing Shapes

HANDS-ON EXERCISE 1: Shapes

SMARTART AND WORDART

Creating SmartArt

Modifying SmartArt

Creating WordArt

Modifying WordArt

HANDS-ON EXERCISE 2: SmartArt and WordArt

OBJECT MANIPULATION

Modifying Objects

Arranging Objects

HANDS-ON EXERCISE 3: Object Manipulation

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER FOUR + PowerPoint Rich Media Tools

CASE STUDY: WEDDING ALBUMS

OBJECTIVES

PICTURES

Inserting a Picture

Transforming a Picture

Using the Internet as a Resource

HANDS-ON EXERCISE 1: Pictures

VIDEO

Adding Video

Using Video Tools 

HANDS-ON EXERCISE 2: Video

AUDIO

Adding Audio

Changing Audio Settings

HANDS-ON EXERCISE 3: Audio

PHOTO ALBUMS

Creating a Photo Album

Setting Photo Album Options

HANDS-ON EXERCISE 4: Photo Albums

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER FIVE + Infographics

CASE STUDY: HEALTHY LIVING: ANTIOXIDANTS

OBJECTIVES

TEXT-BASED CHARTS

Creating a Poster or a Banner

Drawing a Table

Creating a Table Structure

HANDS-ON EXERCISE 1: Text-Based Charts

TABLE DESIGN

Formatting Table Components

Changing Table Layout

Sharing Information Between Applications

HANDS-ON EXERCISE 2: Table Design

STATISTICAL CHARTS AND GRAPHS

Identifying Chart Types and Elements

Creating and Inserting a Chart

HANDS-ON EXERCISE 3: Statistical Charts and Graphs

CHART MODIFICATION

Changing a Chart Type

Changing the Chart Layout

Formatting Chart Elements

HANDS-ON EXERCISE 4: Chart Modification

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER SIX + Interactivity and Advanced Animation

CASE STUDY: TEACHING AIDS

OBJECTIVES

HYPERLINKS AND ACTION BUTTONS

Inserting and Using Hyperlinks

Adding Action Buttons

Using a Trigger

HANDS-ON EXERCISE 1: Hyperlinks and Action Buttons

ADVANCED ANIMATION

Applying Multiple Animations to an Object

Applying a Motion Path Animation

Specifying Animation Settings and Timing

Animating Text

Using the Animation Pane

HANDS-ON EXERCISE 2: Advanced Animation

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER SEVEN + Customization

CASE STUDY: SURVIVAL SOLUTIONS

OBJECTIVES

POWERPOINT CUSTOMIZATION

Setting PowerPoint Options

Customizing the Ribbon

Using Combine Shape Commands

HANDS-ON EXERCISE 1: PowerPoint Customization

MASTER BASICS

Modifying Handout and Notes Masters

Modifying a Slide Master

Saving a Slide Master as a Template

HANDS-ON EXERCISE 2: Master Basics

CUSTOM SHOWS

Creating a Custom Slide Show

Running and Navigating a Custom Slide Show

Designating and Displaying Hidden Slides

HANDS-ON EXERCISE 3: Custom Shows

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

 

CHAPTER EIGHT + Collaboration and Distribution

CASE STUDY: THE HARBOR BUSINESS CENTER

OBJECTIVES

PRESENTATION COLLABORATION

Working with Comments and Ink Annotations

Showing, Hiding, and Printing Markup

Comparing and Merging Presentations

Viewing Presentation Properties

HANDS-ON EXERCISE 1: Presentation Collaboration

PREPARATION FOR SHARING AND PRESENTATION

SECURITY

Checking a Presentation for Issues

Protecting a Presentation

HANDS-ON EXERCISE 2:

Preparation for Sharing and Presentation Security

PRESENTATION SHARING

Selecting a Presentation File Type

Saving and Sending a Presentation

HANDS-ON EXERCISE 3: Presentation Sharing

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

GLOSSARY

INDEX

 

Prentice Hall - PEARSONISBN-10: 0135091004
ISBN-13: 9780135091005
  PGS: N/AList: 122.00     YOUR PRICE: 115.90

Your search found 182 books
Now viewing Books 1 - 25
In stock items ship IMMEDIATELY.
Other titles usually ship within 2-3 days.

ALTERNATE SEARCHES
Browse Subject         ISBN Search         Table of Contents Search    
Title and/or Author Search       Publisher Search       Advanced Search  

Only a Partial Listing of Our Stock!
2 Week Return Policy (disks must be unopened)


Location/Hours/General Info. Ordering & Shipping Search Techniques/Examples
Corporate Accounts Government Buyers Librarians
Universities & Colleges Training Accounts International Orders
Technical Books on these areas & more:
Computer Business Electronics
Engineering Uniform & Code Construction
Film & TV Industry Legal Medical
Recording Industry Math & Science Classic & Out-Of-Print Titles

Opamp Technical has one of the largest selections of technical books in the country. Our bookstore was started over 20 years ago. We supply all types of professional & educational technical books to individuals, government agencies, schools, corporate libraries, & many industries.
 

OPAMP Technical Books
1033 N. Sycamore Avenue
Los Angeles, California    90038   USA
800-468-4322 / 323-464-4322     FAX 323-464-0977
Copyright © 1997-2007 Opamp Technical Books, Inc.