Advanced Excel for Scientific Data Analysis |
|
| Author:
| De Levie, Robert |
| ISBN: | 978-0-19-537022-5 |
| Publication Date: | Aug 2008 |
| Publisher: | Oxford University Press, Incorporated
|
| Book Format: | Paperback |
| List Price: | USD $59.50 |
Book Description:
|
Fully revised and expand the new edition contains three new chapters addressing common but often poorly used mathematical methods; linear algebra on the spreadsheet with Volpis extensive matrix toolbox of custom functions and macros; and how to set up the spreadsheet to make it less error-prone, and how to get superaccurate answers in Excel. The chapter on writing functions has been substantially enlarged and now includes a set of MacroMorsels. All this is presented in an easily...
More DescriptionFully revised and expand the new edition contains three new chapters addressing common but often poorly used mathematical methods; linear algebra on the spreadsheet with Volpis extensive matrix toolbox of custom functions and macros; and how to set up the spreadsheet to make it less error-prone, and how to get superaccurate answers in Excel. The chapter on writing functions has been substantially enlarged and now includes a set of MacroMorsels. All this is presented in an easily digestible format, illustrated with many examples from the literature, and supported by a large collection of open-access (i.e., fully transparent and user-modifiable) custom functions and macros.