This is Real Life Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Interviews | March 9, 2015

    Rhianna Walton: IMG Erik Larson: The Interview

    Erik LarsonI've been a fan of Erik Larson's riveting brand of narrative history for years, and his latest book, Dead Wake: The Last Crossing of the Lusitania,... Continue »
    1. $19.60 Sale Hardcover add to wish list

Qualifying orders ship free.
List price: $104.45
Used Spiral
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
25 Partner Warehouse General- General

This title in other editions

Microsoft Excel 2007 in Business, Comprehensive - Text Only (08 Edition)


Microsoft Excel 2007 in Business, Comprehensive - Text Only (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. Communicating with Microsoft Office Word 2007 In Business, Core, 1/e covers the following topics: introduction to Word basics; creating a basic report; Word document enhancements; sharing objects and adding references.   Ideal for business students and professionals.

Table of Contents

Microsoft Office Excel 2007 In Business, Comprehensive, 1/e

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



Chapter 7 Date, Text and Error Functions

    Date Functions




        Date and Day

    Text Functions


        Search, Left, Len and Mid

    IS Functions

        Is Number and Is Text

        Is Error


Chapter 8 Managing Large Volumes of Data


        Creating A New PivotTable

        Adding Fields and Changing Field Settings

        Applying Filters to Fields

        Adding and Removing Report Totals

        Adding Formulas (Calculated Fields)

        Sorting Data


    Tools for Selecting and Summarizing Data



        Adding the Developer Tab

        List Boxes


Chapter 9 Scenarios and Advanced Statistics

    Scenario Tools

        Scroll Bar

        Conditional Formatting

        Data Tables

        Goal Seek

        Scenario Manager

    Data Analysis Tools


        Descriptive Statistics




      Defining Constraints

        Defining Solver Parameters


Chapter 10 Advanced Excel: Importing External Data

    Importing Text Files

        Importing Delimited Text Files

        Importing Fixed Width Text Files

    Importing Data from a Database

        Database Queries

        Editing a Database Query

        Advanced Database Queries (Microsoft Query)

    Importing Data from the Internet

        Web Queries


APPENDIX  - Macros and VBA


        Recording a Macro

        Action Buttons

        Editing Action Buttons

    VBA (Visual Basic for Applications)

        The Visual Basic Editor

        Adding a Procedure

        Defining Variables

        Referencing and Assigning Values in Cell Locations

        For Next Loops

        If Statements

        Running a Program

        Initiating VBA Code through User Events

Product Details

Manzo, Joseph
Prentice Hall
Manzo, Joseph J.
Spreadsheets - General
Business -- Computer programs.
Personal Computers-Desktop Applications-Spreadsheets
Edition Description:
Trade paper
Publication Date:
August 2007
Grade Level:
College/higher education:
10.9 x 9 x 1 in 1170 gr

Related Subjects

Business » Start Up Business
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Microsoft Excel 2007 in Business, Comprehensive - Text Only (08 Edition) Used Spiral
0 stars - 0 reviews
$70.00 In Stock
Product details 592 pages Prentice Hall - English 9780131991712 Reviews:
  • 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