Exploring Microsoft Office Excel 2007 Volume 1

by Grauer, Robert; Scheeren, Judy

• ISBN13: 9780132330770
• ISBN10: 0132330776
• Edition: 1st
• Format: Paperback
• Copyright: 2007-05-30
• Publisher: Prentice Hall

Summary

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/ecovers 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.

Table of Contents

Introduction to Excel

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

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

Workbook and Worksheet

Enhancements

Managing Worksheets

Formatting Worksheets

Hands-On Exercise #3: Formatting Jake's Gym Worksheet

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

Microsoft Excel: Formulas and Functions

Formula Basics Creating and Copying Formulas

Using Relative and Absolute Cell Addresses

Hands-On Exercise #1: Smithtown Hospital Radiology Department Payroll

Function Basics

Using AutoSum Inserting

Basic Statistical Functions

Using Date Functions

Hands-On Exercise #2: Completing the Smithtown

Hospital Radiology Department

Logical and Lookup Functions

Using the IF Function

Using the Vlookup Function

Hands-On Exercise #3: Athletic Department Eligibility Gradebook

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

Microsoft Excel: Charts

A Picture is the Message

Choosing A Chart Type

Creating a Chart

Hands-on Exercise 1: The First Chart

Chart Enhancements

Modifying a Chart Enhancing

Charts with Graphic Shapes

Hands-on Exercise 2: Multiple Data Series

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

Microsoft Excel: Working with Large Worksheets and Tables

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

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

Table of Contents provided by Publisher. All Rights Reserved.