Formulas and functions with Microsoft Office Excel 2007 /
McFedries, Paul
Formulas and functions with Microsoft Office Excel 2007 / Paul McFedries - Indianapolis, Ind. : Que, 2007 - 523 p. : ill. ; 23 cm. - Business solutions .
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
0789736683 9780789736680
Microsoft Excel (Computer file)
Business--Computer programs
Electronic spreadsheets
Formulas and functions with Microsoft Office Excel 2007 / Paul McFedries - Indianapolis, Ind. : Que, 2007 - 523 p. : ill. ; 23 cm. - Business solutions .
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
0789736683 9780789736680
Microsoft Excel (Computer file)
Business--Computer programs
Electronic spreadsheets