Exploring Microsoft Office Excel 2007 Volume 1 / Edition 7

Exploring Microsoft Office Excel 2007 Volume 1 / Edition 7

by Robert Grauer, Judy Scheeren, Keith Mulbery, Keith Mulbery
     
 

ISBN-10: 0132330776

ISBN-13: 9780132330770

Pub. Date: 06/14/2007

Publisher: Prentice Hall

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page

Overview

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired. Exploring Microsoft Office Excel 2007 Volume 1, 1/e covers the following topics: introduction to Excel; formulas and functions; chart enhancement and distribution; working with large worksheets and tables. Ideal for students and individuals seeking comprehensive instruction for Excel 2007.

Product Details

ISBN-13:
9780132330770
Publisher:
Prentice Hall
Publication date:
06/14/2007
Series:
Exploring Ser.
Edition description:
New Edition
Pages:
352
Product dimensions:
8.86(w) x 10.62(h) x 0.48(d)

Table of Contents

Chapter 1 - Introduction to Excel

Section 1: Introduction to Spreadsheets

Defining Worksheets and Workbooks

Using Spreadsheets Across Disciplines

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

Managing Cell Comments

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >