From: Academic Press
Completely updated guide for scientists, engineers and students who want to use Microsoft Excel 2007 to its full potential.
Electronic spreadsheet analysis has become part of the everyday work of researchers in all areas of engineering and science. Microsoft Excel, as the industry standard spreadsheet, has a range of scientific functions that can be utilized for the modeling, analysis and presentation of quantitative data. This text provides a straightforward guide to using these functions of Microsoft Excel, guiding the reader from basic principles through to more complicated areas such as formulae, charts, curve-fitting, equation solving, integration, macros, statistical functions, and presenting quantitative data.
“A Guide to Microsoft Excel 2007 for Scientists and Engineers,” by Dr. Bernard V. Liengme provides a practical and straightforward guide to using these functions of Microsoft Excel to their full potential. This will guide the reader from basic principles through to more complicated areas, such as formulae, charts, curve-fitting, equation solving, integration, macros, classical functions, and reporting/formatting results.
This book incorporates Microsoft’s changes in the 2007 version of Excel. Gone are the once familiar menus and toolbars. In their place are tabbed ribbons. All commands are in one place and arranged in a logical manner. The chart engine has undergone a major overhaul and now produces a better output. Furthermore, what you learn about charts in Excel is now applicable to Microsoft Word and PowerPoint. Excel 2007 introduces a number of useful new functions, such as ISERROR and AVERAGEIFS. For presentation work we now have themes to help in the selection of complementary colors for Excel reports. Another good feature is the extension of conditional formatting.
The book, copyright 2008, is published by Academic Press. Price of the softcover book is $39.95.
