Microsoft Office Excel 2007 In Business, Core

by Manzo, Joseph J.

• ISBN13: 9780131743441
• ISBN10: 0131743449
• Edition: 1st
• Format: Paperback
• Copyright: 2007-05-03
• 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 Excel 2007 In Business, Core, 1/ecovers 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.

Table of Contents

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

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

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

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

Table of Contents provided by Publisher. All Rights Reserved.