# Exploring Microsoft Office Excel 2007 Comprehensive / Edition 2

ISBN-10: 0135119804

ISBN-13: 9780135119808

Pub. Date: 12/09/2009

Publisher: Prentice Hall

For introductory Office Application courses that cover Excel 2007.

The goal of the Exploring Series has been to move students beyond the point and click, helping them understand the why and how behind each skill. Students go to college now with a different set of skills than they did 5 years ago. The new edition of Exploring moves students beyond the basics of

## Overview

For introductory Office Application courses that cover Excel 2007.

The goal of the Exploring Series has been to move students beyond the point and click, helping them understand the why and how behind each skill. Students go to college now with a different set of skills than they did 5 years ago. The new edition of Exploring moves students beyond the basics of the software at a faster pace, without sacrificing fundamental skills to ensure that they will be engaged throughout the book.

## Product Details

ISBN-13:
9780135119808
Publisher:
Prentice Hall
Publication date:
12/09/2009
Edition description:
New Edition
Pages:
784
Product dimensions:
8.10(w) x 10.60(h) x 1.30(d)

## Related Subjects

Chapter 1 - Introduction to Excel

Defining Worksheets and Workbooks
Planning for Good Workbook and Worksheet Design
Identifying Excel Window Components
Entering and Editing Data in Cells
Hands-On Exercise #1: Introduction to Microsoft Excel

Section 2: Mathematics and Formulas
Describing and Using Symbols and the Order of Precedence
Displaying Cell Formulas
Inserting and Deleting Rows and Columns
Using Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFill
Hands-On Exercise #2: Jakes Gym Continued

Section 3: Workbook and Worksheet Enhancements
Managing Worksheets
Formatting Worksheets
Hands-On Exercise #3: Formatting Jake's Gym Worksheet

Section 4: Page Setup and Printing
Selecting Page Setup Options for Printing
Hands-On Exercise #4: Printing Jake's Gym Worksheet

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 2 - Microsoft Excel: Formulas and Functions

Section 1: Formula Basics
Creating and Copying Formulas
Using Relative and Absolute Cell Addresses
Hands-On Exercise #1: Smithtown Hospital Radiology Department Payroll

Section 2:Function Basics
Using AutoSum
Inserting Basic Statistical Functions
Using Date Functions
Hands-On Exercise #2: Completing the Smithtown Hospital Radiology Department

Section 3: Logical and Lookup Functions
Using the IF Function
Using the VLOOKUP Function
Hands-On Exercise #3: Athletic Department Eligibility Gradebook

Section 4: Financial Functions
Using the PMT Function
Using the FV Function
Hands-On Exercise #4: Purchasing a Van for the School for Exceptional Children

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 3 - Microsoft Excel: Charts

Section 1: A Picture is the Message
Choosing A Chart Type
Creating a Chart
Hands-on Exercise 1: The First Chart

Section 2: Chart Enhancements
Modifying a Chart
Enhancing Charts with Graphic Shapes
Hands-on Exercise 2: Multiple Data Series

Section 3: Chart Distribution
Embedding Charts
Printing Charts
Hands-on Exercise 3: Embedding, Printing, And Saving Chart as a Web Page

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 4: Microsoft Excel: Working with Large Worksheets and Tables

Section 1: Large Worksheet Preparation
Freezing Rows and Columns
Hiding and Unhiding Rows, Columns, and Worksheets
Protecting a Cell, a Worksheet and a Workbook
Controlling Calculation
Printing Large Worksheets
Hands-On Exercise #1: Marching Band Roster

Section 2: Excel Data Tables
Exploring Basic Table Management
Sorting Data
Filtering and Totaling Data
Hands-On Exercise #2: Marching Band Roster Revisited

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 5 - Data to Information

Section 1 Table Management
Designing Tables Based on Table Data Theory
Importing Data from Text Files and Other Sources
Applying Conditional Formatting
Hands-on Exercise 1: Gee Airlines Human Resources Department

Section 2 Data Management
Applying Advanced Filtering and Sorting Methods
Creating and Using Range Names
Using Database Functions
Hands-on Exercise 2: Gee Airlines Human Resources Department Revisited

Section 3 Data Analysis with PivotTables and PivotCharts
Creating and Deleting PivotTables and PivotChart Reports
Formatting, Sorting, Filtering, Subtotaling, and Refreshing a PivotTable
Hands-on Exercise 3: Eye First Advertising Department Sales

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 6 — Data Tables and Amortization Tables

Section 1 Tables
Separating and Combining Text
Manipulating Text with Functions
Hands-on Exercise 1: IT Department String Manipulation

Section 2 Data Analysis and Windows
Identifying and Removing Duplicate Rows
Grouping and Subtotaling Data
Working with Windows
Hands-on Exercise 2: Ajax College Band

Section 3 Conditional and Logical Functions
Using Conditions in Functions
Creating Nested IF Functions
Using AND, OR, NOT and IFERROR Functions
Hands-on Exercise 3: Classic Cars and Security

Section 4 Amortization Table
Defining the Amortization Table
Using Functions in Amortization Tables
Hands-on Exercise 4: Purchase a New House

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 7 — Data Consolidation, Links, and Formula Auditing

Section 1 Data Consolidation
Consolidating Data from Multiple Worksheets
Defining the Three-Dimensional Workbook
Creating Three-Dimensional References in Formulas
Hands-on Exercise 1: Consolidating Best Restaurant Corporate Sales

Section 2 Workbook Linking and Documentation
Creating the Documentation Worksheet
Hands-on Exercise 2: Consolidating Workbooks for Corporate Sales and Adding Documentation

Section 3 Workbook Auditing
Restricting Values to a Drop-Down List
Validating Data
Auditing Formulas
Setting up a Watch Window
Hands-on Exercise 3: JAS Manufacturing

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 8 — What-If Analysis

Section 1 One- and Two- Variable Data Tables
Creating a One-Variable Data Table
Creating a Two-Variable Data Table
Hands-on Exercise 1: Can You Afford It?

Section 2 Goal Seek and Scenario Manager
Defining Forecasting
Solving Problems with Goal Seek
Using Scenario Manager
Hands-on Exercise 2: Purchase Golf Cars and Manufacture Golf Clubs

Section 3 Solver
Solving Problems with Solver
Hands-on Exercise 3: FAL Computing Manufacturing

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

Chapter 9 - Collaboration and Workbook Distribution

Section 1 Excel Collaboration and Workbook Sharing
Tracking Changes
Enabling Simultaneous Changes by Multiple Users
Saving Workbooks in Different Formats
Sending a Workbook by E-mail
Copying Data to Word and PowerPoint
Hands-on Exercise 1: Collaborate and Share

Section 2 Workbook Distribution
Finalizing Documents
Preparing Workbooks for Distribution
Hands-on Exercise 2: Distribute and Secure Workbooks

Section 3 Excel Options and Add-ins
Understanding Excel Options
Hands-on Exercise 3: Customizing Excel

Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Project
Mini Cases

Chapter 10 — Templates, Styles, Web, and Macros

Section 1 Worksheet Automation
Working with Existing Templates, Themes, and Styles
Creating a Template
Hands-on Exercise 1: Use and Create Themes, Styles, and Templates

Section 2 Web Pages and Queries
Creating a Web Page
Creating Web Queries
Hands-on Exercise 2: Query the Web and Create a Web Page

Working with Macros
Creating Macro Buttons
Understanding the Basics of VBA
Hands-on Exercise 3: Work with Macros and Visual Basic for Applications

Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases

## Customer Reviews

Average Review:

Write a Review

and post it to your social network