Microsoft Office Excel 2007 In Business, Comprehensive

by Manzo, Joseph J.

• ISBN13: 9780131991712
• ISBN10: 013199171X
• Edition: 1st
• Format: Paperback
• Copyright: 2008-01-01
• Publisher: Prentice Hall

Summary

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 Access 2007 In Business, Adv., 1/ecovers the following topics: advanced techniques for managing and using tables; date, text, and error functions; forms; and macros. Ideal for business students and professionals.

Table of Contents

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

Managing Large Volumes of Data

PivotTables

PivotTable and PivotChart Wizard

Adding Fields and Setting Field Properties

Isolating Specific Categories of Data

Adding and Removing Report Totals

Adding Formulas

Sorting Data

PivotCharts

Tools for Selecting and Summarizing Data

AutoFilter

Subtotals

Freezing Panes

List Box

Scenarios and Advanced Statistics

Scenario Tools

Scroll Bar

Conditional Formatting

Data Tables

Goal Seek

Scenario Manager

Data Analysis Tool Pack

Descriptive Statistics

Histograms

Regression

Solver

Working with Data from Other Sources

Linking to Information on the Web

Excel Query (Integrating Excel and Access)

Introduction to Developing Applications with Excel

Basic Macros

Table of Contents provided by Publisher. All Rights Reserved.