Formulas and functions with Microsoft Office Excel 2007 /

Formulas and functions with Microsoft Office Excel 2007 /

Saved in:

Bibliographic Details
Main Author:	McFedries, Paul
Format:	Electronic eBook
Language:	English
Published:	Indianapolis, Ind. : Que, 2007.
Series:	Business solutions.
Subjects:	Microsoft Excel (Computer file) Microsoft Excel (Fichier d'ordinateur) Business > Computer programs. Electronic spreadsheets. Microsoft software. Electronic spreadsheets > Computer programs.
Online Access:	CONNECT

Table of Contents:

Introductio
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
Understanding 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 tables
Analyzing data with PivotTables
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
Building discount formulas
Index.