Formulas and functions with Microsoft Office Excel 2007
General Material Designation
[Electronic]
First Statement of Responsibility
/ Paul McFedries
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Indianapolis, Ind.
Name of Publisher, Distributor, etc.
: Que
Date of Publication, Distribution, etc.
, c2007.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
xvi, 523 p.
Other Physical Details
: , ill. , 23 cm.
SERIES
Series Title
(Business solutions)
INTERNAL BIBLIOGRAPHIES/INDEXES NOTE
Text of Note
Includes index.
CONTENTS NOTE
Text of Note
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.