Microsoft Office Excel 2007 In Business / Edition 1

Microsoft Office Excel 2007 In Business / Edition 1

by Joseph J. Manzo
     
 

View All Available Formats & Editions

ISBN-10: 013199171X

ISBN-13: 2900131991711

Pub. Date: 08/21/2007

Publisher: Prentice Hall

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

Overview

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.

Product Details

ISBN-13:
2900131991711
Publisher:
Prentice Hall
Publication date:
08/21/2007
Series:
Custom PHIT: the Pearson Custom Program for CIS Series
Edition description:
New Edition
Pages:
592

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >