The latest 6th Edition is now available at https://z.umn.edu/pnm6.

Learn to boost Excel's computational power using VBA to perform advanced numerical calculations to find roots of systems of linear and nonlinear equations, determine eigenvalues and vectors, optimize multimodal objective functions, apply the calculus of derivatives, integrals, and differential equations, conduct uncertainty analysis, and model data by regression and interpolation.

Practical Numerical Methods (PNM) shows engineers and scientists how to use VBA to boost Excel's power for modeling and analysis using the same numerical techniques found in specialized math software.

Visit the companion website for more details and additional content:

https://z.umn.edu/pnm5

Download the book's Excel and VBA files and learn how to customize your own Excel workbooks:

• Get the PNMSuite: A feature-rich macro-enabled Excel workbook with a suite of over 225 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, which demonstrate applied numerical methods in Excel and VBA. 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 single 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.