Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

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

Tour our stores


    Recently Viewed clear list


    What I'm Giving | December 2, 2014

    Cary Elwes: IMG Cary Elwes: What I'm Giving



    At Powell's, we feel the holidays are the perfect time to share our love of books with those close to us. For this special blog series, we reached... Continue »

    spacer
Qualifying orders ship free.
$84.00
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)

by

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)

    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

 

Chapter 7 Date, Text and Error Functions

    Date Functions

        Today

        Year

        Month

        Date and Day

    Text Functions

        Concatenate

        Search, Left, Len and Mid

    IS Functions

        Is Number and Is Text

        Is Error

 

Chapter 8 Managing Large Volumes of Data

    PivotTables

        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

        PivotCharts

    Tools for Selecting and Summarizing Data

        Filters

        Subtotals

        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

        Add-Ins

        Descriptive Statistics

        Histograms

        Regression

    Solver

      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

    Macros

        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

ISBN:
9780131991712
Author:
Manzo, Joseph
Publisher:
Prentice Hall
Author:
Manzo, Joseph J.
Subject:
Spreadsheets - General
Subject:
Business -- Computer programs.
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Trade paper
Publication Date:
August 2007
Binding:
TRADE PAPER
Grade Level:
College/higher education:
Language:
English
Illustrations:
Y
Pages:
592
Dimensions:
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
$84.00 In Stock
Product details 592 pages Prentice Hall - English 9780131991712 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
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.