Microsoft Office Excel 2007 in Business, Core with Microsoft Office Excel 2007 in Business, Core Student Resource DVD [With CDROM] / Edition 1

Other Format (Print)
Buy New
Buy New from BN.com
$82.63
Buy Used
Buy Used from BN.com
$62.43
(Save 34%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $4.06
Usually ships in 1-2 business days
(Save 95%)
Other sellers (Other Format)
  • All (19) from $4.06   
  • New (9) from $28.14   
  • Used (10) from $4.06   

More About This Textbook

Overview

This package contains the following components:

-0131743449: Microsoft Office Excel 2007 In Business, Core

-0131743457: Microsoft Office Excel 2007 In Business, Core Student Resource DVD

Read More Show Less

Product Details

  • ISBN-13: 9780137133444
  • Publisher: Prentice Hall
  • Publication date: 8/28/2007
  • Format: Spiral Bound
  • Edition description: New Edition
  • Edition number: 1
  • Product dimensions: 9.00 (w) x 10.90 (h) x 0.70 (d)

Table of Contents

Excel Core Table of Contents

Chapter 1 Introduction

What is Excel?

Why Are We Here?

A Decision-Making Tool

An Overview of Excel

Ribbons, Tabs, and Icons

The File Menu

Excel 97-2003 File Format

Right Click and Control Keys

Settings and Status Bar

Excel Help

Chapter 2 Excel Basics

Data Management

Data Entry

Auto Fill

Adjusting Columns and Rows

Hiding Columns and Rows

Copy and Paste

Sorting Data (Single Level)

Sorting Data (Multiple Levels)

Formatting

Data Formats

Data Alignment

Number Formats

Borders (Line Formats)

Cell Colors (Fill Color)

Editing

Editing Data in a Cell

Moving Data

Deleting Columns and Rows

Deleting Worksheets

Inserting Columns and Rows

Inserting, Moving, and Renaming Worksheet Tabs

Printing

Page Setup

Printing a Worksheet

Chapter 3 Calculating Data: Formulas and Functions

Formulas

Basic Formulas

Copy and Pasting Formulas (Relative Reference and Paste Special)

Complex Formulas

Auditing Formulas

Basic Functions

Basic Statistical Functions

AutoSum

Absolute References (Turning Off Relative References)

Financial Functions

The Future Value Function

The Payment Function

The Function Library

Chapter 4 Evaluating Data

Logical Functions (The IF Function)

IF Function

Nested IF Function

Logical Functions (AND OR)

AND Function

OR Function

Combining AND, OR, and IF Functions

Lookup Functions

VLookup Function

HLookup Function

Chapter 5 Presenting Information with Charts

Creating Charts

Column Charts (Data Comparisons)

Stacked Column Charts (Percent to Total Over Time)

Line Charts (Trends Over Time)

Pie Charts (Percent to Total)

Formatting Charts

Titles and Legends

Plot Area and Data Series

X- and Y-Axes Labels

Adding Annotations and Objects

Advanced Chart Options

Defining the X- and Y-Axes Manually

The Scatter Plot Chart

Pasting Charts into PowerPoint and Word

Chapter 6 Applying Core Competency Skills: Financial Planning and Accounting

Linking Data

Linking Worksheets and Workbooks

Updating Workbook Links

SUMIF Function

Financial Planning

Financial Assumptions

Freeze Panes

Financial Data

Cash Analysis (The NPV Function)

Financial Accounting

T-Accounts

Journals

Ledgers

Trial Balance and Work Sheets

Statements

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)