Engineering with Excel

Ronald W. Larsen, Ph.D., P.E., is the Department Head of the Chemical and Biological Engineering Department at Montana State University.

• 1. Introduction to Excel1.1 Introduction1.2 What's New in Excel 2016?1.3 A Little Windows®1.4 Excel Basics1.5 Organizing Your Worksheets1.6 Printing the Worksheet1.7 Saving and Opening Workbooks, Exiting Excel2. Using Excel's Ribbon2.1 Navigating the Ribbon2.2 Using the Clipboard Group2.3 Using the Font Group2.4 Using the Alignment Group2.5 Formatting Numbers2.6 Using the Styles Group2.7 Inserting, Deleting, and Formatting Rows and Columns3. Graphing with Excel3.1 Introduction3.2 Getting Ready to Graph3.3 Creating an Xy Scatter Graph3.4 Editing an Existing Graph3.5 Printing the Graph3.6 Other Types of Graphs3.7 Graphing Web Data3.8 Importing Text Files 4. Excel Functions4.1 Introduction to Excel Functions4.2 Excel's Built-in Functions4.3 Using the Convert Function to Convert Units4.4 Simple Math Functions4.5 Computing Sums4.6 Trigonometric Functions4.7 Advanced Math Functions4.8 Error Function4.9 Bessel Functions4.10 Working with Complex Numbers4.11 Working with Binary, Octal, and Hexadecimal Values4.12 Miscellaneous Functions5. Matrix Operations in Excel5.1 Introduction5.2 Matrices, Vectors, and Arrays5.3 How Excel Handles Matrix Math5.4 Basic Matrix Operations5.5 Solving Systems of Linear Equations6. Linear Regression in Excel6.1 Introduction6.2 Linear Regression Using Excel Functions6.3 Linear Regression Using Excel's Trendlines6.4 Other Two-Coefficient Linear Regression Models6.5 Polynomial Regression6.6 Linear Regression Using Excel's Regression Analysis Package7. Excel's Statistics Functions7.1 Overview7.2 Populations and Samples7.3 Standard Deviations and Variances7.4 Errors, Deviations, and Distributions7.5 Confidence Intervals8. Excel's Financial Functions8.1 Time, Money, and Cash Flows8.2 Interest Rates and Compounding8.3 Moving Amounts Through Time8.4 Net Present Value8.5 Internal Rate of Return8.6 Economic Alternatives: Making Decisions8.7 Depreciation of Assets9. Iterative Solutions Using Excel9.1 Introduction9.2 Iterative Solutions9.3 Using a Plot to Search for Roots9.4 Simple "Guess and Check" Iteration9.5 Direct Substitution Technique9.6 Using Goal Seek in Excel9.7 Introduction to Excel's Solver9.8 Optimization Using the Solver9.9 Nonlinear Regression9.10 Linear Programming10. Sharing Excel Information with Other Programs10.1 Introduction to Sharing Excel Information with other Programs10.2 Using Copy and Paste to Move Information10.3 Embedded and Linked Objects10.4 External Data Sources11. Excel Pivot Tables11.1 Introduction11.2 Preparing to Create a Pivot Table11.3 A Basic Pivot Table11.4 Sorting and Filtering a Pivot Table11.5 Pivoting the Pivot Table11.6 What Can Be Done with a Pivot Table?11.7 Pivot Charts12. Macros and User-Written Functions for Excel12.1 Introduction12.2 Macros and Viruses12.3 Recorded Macros12.4 Programmed Macros (Vba)13. User-Written Functions for Excel13.1 Introduction13.2 Macro-Enabled Worksheets13.3 Introduction to Visual Basic for Applications (Vba)13.4 Writing Your Own Function13.5 Using Your Functions in Other Workbooks13.6 Examples of User-Written Functions14. Programming in Excel with VBA14.1 Introduction14.2 Virus Protection and Macro-Enabled Workbooks14.3 Visual Basic for Applications (VBA)14.4 Projects, Forms, and Modules14.5 Flowcharts14.6 Fundamental Elements of Programming14.7 Working with Forms15. Numerical Differentiation Using Excel15.1 Introduction15.2 Finite Differences15.3 Filtering Data15.4 Curve Fitting and Differentiation16. Numerical Integration Using Excel16.1 Introduction16.2 Integrating for Area Under a Curve16.3 Integrating for Area Between Two Curves16.4 Numerical Integration Methods16.5 Using Regression Equations for Integration17. Numerical Integration Techniques for Differential Equations Using Excel17.1 Introduction17.2 Euler's Method17.3 Fourth-Order Runge--Kutta Method17.4 Integrating Two Simultaneous Odes by Using the Runge--Kutta Method17.5 Implicit Integration Methods