Ebook373 pages6 hours
Excel for Scientists and Engineers: Numerical Methods
Rating: 3.5 out of 5 stars
3.5/5
()
About this ebook
Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations
With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform:
*
Use worksheet functions to work with matrices
*
Find roots of equations and solve systems of simultaneous equations
*
Solve ordinary differential equations and partial differential equations
*
Perform linear and non-linear regression
*
Use random numbers and the Monte Carlo method
This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix.
The CD-ROM that accompanies this text provides several useful features:
*
All the spreadsheets, charts, and VBA code needed to perform the examples from the text
*
Solutions to most of the end-of-chapter problems
*
An add-in workbook with more than twenty custom functions
This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.
With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform:
*
Use worksheet functions to work with matrices
*
Find roots of equations and solve systems of simultaneous equations
*
Solve ordinary differential equations and partial differential equations
*
Perform linear and non-linear regression
*
Use random numbers and the Monte Carlo method
This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix.
The CD-ROM that accompanies this text provides several useful features:
*
All the spreadsheets, charts, and VBA code needed to perform the examples from the text
*
Solutions to most of the end-of-chapter problems
*
An add-in workbook with more than twenty custom functions
This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.
Related to Excel for Scientists and Engineers
Related ebooks
MATLAB Demystified Rating: 5 out of 5 stars5/5Essentials of Scientific Computing: Numerical Methods for Science and Engineering Rating: 0 out of 5 stars0 ratingsAdvanced Theoretical Mechanics: A Course of Mathematics for Engineers and Scientists Rating: 0 out of 5 stars0 ratingsOptimal Design with Advanced Materials Rating: 0 out of 5 stars0 ratingsNX 9 for Beginners - Part 4 (Assemblies and Drawings) Rating: 0 out of 5 stars0 ratingsA Student's Introduction to Engineering Design: Pergamon Unified Engineering Series Rating: 0 out of 5 stars0 ratingsFundamentals of Probability and Statistics for Engineers Rating: 5 out of 5 stars5/5Control and Optimal Control Theories with Applications Rating: 0 out of 5 stars0 ratingsAn Introduction to Organic Lasers Rating: 0 out of 5 stars0 ratingsApplied Elasticity: Matrix and Tensor Analysis of Elastic Continua Rating: 0 out of 5 stars0 ratingsBASIC MATH: An Introduction to Calculus Rating: 0 out of 5 stars0 ratingsNonlinear Mechanics: A Supplement to Theoretical Mechanics of Particles and Continua Rating: 4 out of 5 stars4/5Extended Finite Element Method: Tsinghua University Press Computational Mechanics Series Rating: 0 out of 5 stars0 ratingsSolved Problems in Engineering Mechanics Rating: 0 out of 5 stars0 ratingsFluid Mechanics DeMYSTiFied Rating: 0 out of 5 stars0 ratingsHighway Contractor: Passbooks Study Guide Rating: 0 out of 5 stars0 ratingsIntroduction To Lagrangian Dynamics Rating: 0 out of 5 stars0 ratingsNumerical Prediction of Flow, Heat Transfer, Turbulence and Combustion Rating: 4 out of 5 stars4/5Beginning MATLAB and Simulink: From Novice to Professional Rating: 0 out of 5 stars0 ratingsMicrofluidic Biosensors Rating: 0 out of 5 stars0 ratingsSolidWorks 2015 Learn by doing-Part 1 Rating: 4 out of 5 stars4/5Optimal Design of Flexural Systems: Beams, Grillages, Slabs, Plates and Shells Rating: 5 out of 5 stars5/5Hybrid Rocket Propulsion Design Handbook Rating: 0 out of 5 stars0 ratingsAn Introduction to Engineering Systems: Pergamon Unified Engineering Series Rating: 0 out of 5 stars0 ratingsEngineering Physics Rating: 0 out of 5 stars0 ratingsHow To Prepare Defense-Related Scientific and Technical Reports: Guidance for Government, Academia, and Industry Rating: 0 out of 5 stars0 ratingsDesigner's Guide to the Cypress PSoC Rating: 0 out of 5 stars0 ratingsHands-On ZigBee: Implementing 802.15.4 with Microcontrollers Rating: 0 out of 5 stars0 ratings
Enterprise Applications For You
Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5Learn Windows PowerShell in a Month of Lunches Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5The New Email Revolution: Save Time, Make Money, and Write Emails People Actually Want to Read! Rating: 5 out of 5 stars5/5Microsoft Power Platform A Deep Dive: Dig into Power Apps, Power Automate, Power BI, and Power Virtual Agents (English Edition) Rating: 0 out of 5 stars0 ratingsExcel 2019 Bible Rating: 4 out of 5 stars4/5Excel Guide for Success Rating: 5 out of 5 stars5/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratingsExcel 2019 For Dummies Rating: 3 out of 5 stars3/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsExperts' Guide to OneNote Rating: 5 out of 5 stars5/5Building Web Services with Microsoft Azure Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Tips and Tricks Rating: 0 out of 5 stars0 ratingsLearning Microsoft Azure Rating: 4 out of 5 stars4/5Managing Humans: Biting and Humorous Tales of a Software Engineering Manager Rating: 4 out of 5 stars4/5The Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratings
Reviews for Excel for Scientists and Engineers
Rating: 3.5 out of 5 stars
3.5/5
2 ratings0 reviews
Book preview
Excel for Scientists and Engineers - E. Joseph Billo
Enjoying the preview?
Page 1 of 1