Formulas and functions with Microsoft Office Excel 2007
.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. , ill. , 23 cm.
SERIES
Series Title
Business solutions
GENERAL NOTES
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.