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

ISBN-10: 0137133448

ISBN-13: 9780137133444

Pub. Date: 08/28/2007

Publisher: Prentice Hall

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

## 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

## Product Details

ISBN-13:
9780137133444
Publisher:
Prentice Hall
Publication date:
08/28/2007
Edition description:
New Edition
Product dimensions:
9.00(w) x 10.90(h) x 0.70(d)

Chapter 1 Introduction

What is Excel?

Why Are We Here?

A Decision-Making Tool

An Overview of Excel

Ribbons, Tabs, and Icons

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

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

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

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

## Customer Reviews

Average Review:

Write a Review

and post it to your social network