Formulas and functions with Microsoft Excel 2003 / Paul McFedries.

Format:

Book

Author/Creator:

McFedries, Paul.

Series:

Business solutions

Business solutions.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Business.

Electronic spreadsheets.

Physical Description:

1 online resource (xvi, 486 p. ) ill. ;

Edition:

1st edition

Place of Publication:

Indianapolis, IN : Que Pub., c2005.

Language Note:

English

System Details:

text file

Summary:

The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating for even advanced computer users. Perhaps like you, a majority of users find it difficult to get the most they can out of this very valuable program. Formulas and Functions with Microsoft Excel 2003 strives to break down the complexities by focusing on the four primary technologies to master: ranges, formulas, data analysis tools and lists. Chapters such as “Getting the Most Out of Ranges,” “Building Your Own Functions Using VBA,” and “Solving Complex Problems with Solver” will teach you practical skills and solutions that you can put to work immediately. Frustration will become a thing of the past as you begin to master the complex world of Excel!

Contents:

Intro

Contents

Mastering Excel Ranges and Formulas

Getting the Most Out of Ranges

Using Range Names

Building Basic Formulas

Creating Advanced Formulas

Troubleshooting Formulas

Harnessing the Power of Functions

Using Functions

Working with Text Functions

Working with Logical and Information Functions

Working with Lookup Functions

Working with Date and Time Functions

Working with Math Functions

Working with Statistical Functions

Building Business Models

Analyzing Data with Lists

Using Excel's Business- Modeling Tools

Using Regression to Track Trends and Make Forecasts

Solving Complex Problems with Solver

Building Financial Formulas

Building Loan Formulas

Building Investment Formulas

Working with Bonds

Building Discount Formulas

Index.

Notes:

Includes index.

Description based on publisher supplied metadata and other sources.

ISBN:

9786610902934

9780132713771

0132713772

9781280902932

1280902930

9780768663037

0768663032

OCLC:

1027171587