Exploring Microsoft Office Excel 2007 Comprehensive

by Grauer, Robert T.; Scheeren, Judy

• ISBN13: 9780131574656
• ISBN10: 0131574655
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2008-01-01
• Publisher: Pearson College Div

Summary

The Exploring series helps students master theHow and Whyof performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles featurePerfect pageswhere 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 Comprehensive, 1/e, covers the following topics: introduction to Excel; using formulas, functions, and charts; working with large worksheets and tables; converting data to information; consolidating data and linking files; What-If analysis, forecasting, and amortization; employing templates, themes, and web pages; collaboration and macros; data analysis; VBA.Ideal for students and individuals seeking a comprehensive introduction to 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

Usin

Table of Contents provided by Publisher. All Rights Reserved.