9780131574656

Exploring Microsoft Office Excel 2007 Comprehensive

by ;
  • ISBN13:

    9780131574656

  • ISBN10:

    0131574655

  • Edition: 1st
  • Format: Spiral Bound
  • Copyright: 1/1/2008
  • Publisher: Pearson College Div
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $94.67

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.

Rewards Program

Write a Review