Publisher's Synopsis
A new edition of this popular textbook is now available: https: //z.umn.edu/pnm5
This latest edition expands Practical Numerical Methods (PNM) with more VBA to boost Excel's power for modeling and analysis using the same numerical techniques found in specialized math software. Visit the companion web site for more details and additional content:
www.d.umn.edu/ rdavis/PNM
Download the book's Excel and VBA files and learn how to customize your own Excel workbooks:
- Get the PNMSuite A refined macro-enabled Excel workbook with a suite of over 200 VBA user-defined functions, macros, and user-forms for learning VBA and implementing advanced numerical methods in Excel.
- Work through the hundreds of examples, illustrations, and animations from the book available in downloadable Excel files that demonstrate applied numerical methods in Excel. Customize the example Excel worksheets and VBA code to tackle your own problems.
- Try the practice problems for a self-guided study to sharpen your Excel and VBA skills.
The first chapter sets up the background for practical problem solving using numerical methods. The next two chapters cover frequently overlooked features of Excel and VBA for implementing numerical methods in Excel and documenting results. The remaining chapters present powerful numerical techniques using Excel and VBA to find roots to individual and systems of linear and nonlinear equations, evaluate derivatives, perform optimization, model data by regression and interpolation, assess model fidelity, analyze risk and uncertainty, perform integration, and solve ordinary and partial differential equations.
This new edition builds on the success of previous editions with 20% new content and updated features in the latest editions of Excel!
