| Document Type
|
:
|
BL
|
| Record Number
|
:
|
962514
|
| Doc. No
|
:
|
b716884
|
| Main Entry
|
:
|
McFedries, Paul.
|
| Title & Author
|
:
|
Formulas and functions with Microsoft Office Excel 2007 /\ Paul McFedries.
|
| Publication Statement
|
:
|
Indianapolis, Ind. :: Que,, ©2007.
|
| Series Statement
|
:
|
Business solutions
|
| Page. NO
|
:
|
xvi, 523 pages :: illustrations ;; 23 cm.
|
| ISBN
|
:
|
0789736683
|
|
|
:
|
: 9780789736680
|
| Notes
|
:
|
Includes index.
|
| 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.
|
| Abstract
|
:
|
Provides instructions on the formula-building techniques of Microsoft Excel, covering such topics as ranges, text functions, logical and information functions, list data, regression methods, and working with bonds.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
Gestion-- Logiciels.
|
| Subject
|
:
|
Logiciels Microsoft.
|
| Subject
|
:
|
Tableurs-- Logiciels.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets.
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
|
|
:
|
Microsoft Excel (Logiciel)
|
|
|
:
|
Microsoft Excel (Computer file)
|
| Dewey Classification
|
:
|
005.54
|
| LC Classification
|
:
|
HF5548.4.M523M3756 2007
|