Description
Book Synopsis: With the latest fifth edition of this popular book, you will learn how to supercharge 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.
This new edition builds on the success of previous editions with new content and updated features in Excel!
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 that 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.
Details
Looking to supercharge your computational power in Excel? Look no further than our latest edition of Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 5th Edition. With this book, you'll uncover the secrets of VBA and learn how to perform advanced numerical calculations right within Excel. From finding roots of equations to optimizing objective functions, this book covers it all. Get ready to take your Excel skills to the next level!
What sets this edition apart from the rest? Updated features and new content specific to Excel make this the most comprehensive resource yet. Whether you're an engineer or a scientist, Practical Numerical Methods will show you how to harness the power of VBA to tackle complex modeling and analysis. Say goodbye to specialized math software and hello to the convenience of Excel.
Ready to dive in? Visit our companion website to access additional content and details: https://z.umn.edu/pnm5. Download the book's Excel and VBA files to customize your own workbooks and learn hands-on. But that's not all, we also offer the PNMSuite, a macro-enabled Excel workbook with over 225 VBA user-defined functions, macros, and user forms. You'll have everything you need to master VBA and implement advanced numerical methods in Excel.
Don't just read about it, practice it! Our book includes downloadable Excel files with hundreds of examples, illustrations, and animations. You'll get to see real-life applications of numerical methods in action. Plus, you can customize the example worksheets and VBA code to tackle your own unique problems. It's the perfect opportunity to sharpen your Excel and VBA skills through self-guided study.
Starting from the basics, Practical Numerical Methods sets the stage for practical problem-solving using numerical methods. You'll then explore the often overlooked features of Excel and VBA that enable seamless implementation of numerical methods. The remaining chapters dive deep into powerful techniques such as finding roots, evaluating derivatives, performing optimization, modeling data, and solving differential equations. This book is your ticket to becoming a numerical methods pro in Excel.
Don't miss out on this game-changing resource! Get your copy of Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 5th Edition today and unlock the full potential of Excel for your modeling and analysis needs.
Get Practical Numerical Methods for Chemical Engineers: Using Excel with VBA, 5th Edition now and start revolutionizing the way you work with numerical methods in Excel!
Discover More Best Sellers in Engineering
Shop Engineering
$80.00
Engineering - Standard Guideline for Recording and Exchanging Utility Infrastructure Data (Standard ASCE/UESI/CI 75‐22) (Standards, ASCE/UESI/CI 75-22)
$37.61
Engineering - Drone Technology in Architecture, Engineering and Construction: A Strategic Guide to Unmanned Aerial Vehicle Operation and Implementation
Technical Thermodynamics for Engineers: Basics and Applications
$80.00
Engineering - Technical Thermodynamics for Engineers: Basics and Applications
Practical Design Calculations for Groundwater and Soil Remediation
$170.00
Engineering - Practical Design Calculations for Groundwater and Soil Remediation
PPI PE Mechanical Thermal and Fluid Systems Six-Minute Problems with Solutions, 4th Edition
$95.00
Engineering - PPI PE Mechanical Thermal and Fluid Systems Six-Minute Problems with Solutions, 4th Edition
CRC Materials Science and Engineering Handbook
$75.00
Engineering - CRC Materials Science and Engineering Handbook
