We Need Diverse Ya Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | June 11, 2015

    Michelle Goldberg: IMG How Authentic Is Modern Yoga?

    My decision to embark on The Goddess Pose: The Audacious Life of Indra Devi, the Woman Who Helped Bring Yoga to the West, began with a question. I'd... Continue »
    1. $18.87 Sale Hardcover add to wish list

Qualifying orders ship free.
List price: $93.20
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
3 Partner Warehouse General- General

This title in other editions

Microsoft Excel 2007 in Business - Core Text (08 Edition)


Microsoft Excel 2007 in Business - Core Text (08 Edition) Cover


Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

The In Business system is the only series that prepares you expressly for your core business classes such as Accounting, Economics, Marketing, Finance and Business Statistics by doing the following:  exposing you to real business files that meet professional standards; providing a useful reference to be used in your business classes;  instructing how to use the software as a tool to accomplish business goals; coverage of the core Office skills that you will need in your business courses. In Business includes tools that will benefit any style of learning. Whether you need to reference specific skills for another course or understand how to utilize Microsoft Office to complete your business objectives, In Business will allow you to apply these skills directly to your own education and career aspirations. Microsoft Office Excel 2007 In Business, Core, 1/e covers the following topics: introduction to Excel; calculating data through formulas and functions; evaluating data; presenting information with charts; applying core competency skills for financial planning and accounting.  Ideal for business students and professionals.


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

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)


Data Formats

Data Alignment

Number Formats

Borders (Line Formats)

Cell Colors (Fill Color)


Editing Data in a Cell

Moving Data

Deleting Columns and Rows

Deleting Worksheets

Inserting Columns and Rows

Inserting, Moving, and Renaming Worksheet Tabs


Page Setup

Printing a Worksheet


Chapter 3      Calculating Data: Formulas and Functions


Basic Formulas

Copy and Pasting Formulas (Relative Reference and Paste Special)

Complex Formulas

Auditing Formulas

Basic Functions

Basic Statistical Functions


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




Trial Balance and Work Sheets


Product Details

Manzo, Joseph
Prentice Hall
Manzo, Joseph M.
Manzo, Joseph J.
Computer programs
Spreadsheets - General
Business -- Computer programs.
Personal Computers-Desktop Applications-Spreadsheets
Business Software - General
Edition Description:
Trade paper
Publication Date:
May 2007
Grade Level:
College/higher education:
10.8 x 9 x 0.8 in 816 gr

Other books you might like

  1. The Fast Forward MBA in Finance... New Trade Paper $34.00
  2. Financial Intelligence: A Manager's... Used Hardcover $12.50
  3. Statistics for Business and... Used Hardcover $145.00
  4. Statistics Unplugged (2ND 07 - Old... Used Trade Paper $37.00
  5. Cartoon Guide to Statistics Sale Trade Paper $9.98

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Microsoft Excel 2007 in Business - Core Text (08 Edition) Used Trade Paper
0 stars - 0 reviews
$63.00 In Stock
Product details 336 pages Prentice Hall - English 9780131743441 Reviews:
"Synopsis" by , 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

  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.