Engineering with Excel

<p><strong>1. Introduction to Excel</strong><br>1.1 Introduction<br>1.2 What's New in Excel 2016?<br>1.3 A Little Windows®<br>1.4 Excel Basics<br>1.5 Organizing Your Worksheets<br>1.6 Printing the Worksheet<br>1.7 Saving and Opening Workbooks, Exiting Excel<br><strong>2. Using Excel's Ribbon</strong><br>2.1 Navigating the Ribbon<br>2.2 Using the Clipboard Group<br>2.3 Using the Font Group<br>2.4 Using the Alignment Group<br>2.5 Formatting Numbers<br>2.6 Using the Styles Group<br>2.7 Inserting, Deleting, and Formatting Rows and Columns<br><strong>3. Graphing with Excel</strong><br>3.1 Introduction<br>3.2 Getting Ready to Graph<br>3.3 Creating an Xy Scatter Graph<br>3.4 Editing an Existing Graph<br>3.5 Printing the Graph<br>3.6 Other Types of Graphs<br>3.7 Graphing Web Data<br>3.8 Importing Text Files <br><strong>4. Excel Functions</strong><br>4.1 Introduction to Excel Functions<br>4.2 Excel's Built-in Functions<br>4.3 Using the Convert Function to Convert Units<br>4.4 Simple Math Functions<br>4.5 Computing Sums<br>4.6 Trigonometric Functions<br>4.7 Advanced Math Functions<br>4.8 Error Function<br>4.9 Bessel Functions<br>4.10 Working with Complex Numbers<br>4.11 Working with Binary, Octal, and Hexadecimal Values<br>4.12 Miscellaneous Functions<br><strong>5. Matrix Operations in Excel</strong><br>5.1 Introduction<br>5.2 Matrices, Vectors, and Arrays<br>5.3 How Excel Handles Matrix Math<br>5.4 Basic Matrix Operations<br>5.5 Solving Systems of Linear Equations<br><strong>6. Linear Regression in Excel</strong><br>6.1 Introduction<br>6.2 Linear Regression Using Excel Functions<br>6.3 Linear Regression Using Excel's Trendlines<br>6.4 Other Two-Coefficient Linear Regression Models<br>6.5 Polynomial Regression<br>6.6 Linear Regression Using Excel's Regression Analysis Package<br><strong>7. Excel's Statistics Functions</strong><br>7.1 Overview<br>7.2 Populations and Samples<br>7.3 Standard Deviations and Variances<br>7.4 Errors, Deviations, and Distributions<br>7.5 Confidence Intervals<br><strong>8. Excel's Financial Functions</strong><br>8.1 Time, Money, and Cash Flows<br>8.2 Interest Rates and Compounding<br>8.3 Moving Amounts Through Time<br>8.4 Net Present Value<br>8.5 Internal Rate of Return<br>8.6 Economic Alternatives: Making Decisions<br>8.7 Depreciation of Assets<br><strong>9. Iterative Solutions Using Excel</strong><br>9.1 Introduction<br>9.2 Iterative Solutions<br>9.3 Using a Plot to Search for Roots<br>9.4 Simple "Guess and Check" Iteration<br>9.5 Direct Substitution Technique<br>9.6 Using Goal Seek in Excel<br>9.7 Introduction to Excel's Solver<br>9.8 Optimization Using the Solver<br>9.9 Nonlinear Regression<br>9.10 Linear Programming<br><strong>10. Sharing Excel Information with Other Programs</strong><br>10.1 Introduction to Sharing Excel Information with other Programs<br>10.2 Using Copy and Paste to Move Information<br>10.3 Embedded and Linked Objects<br>10.4 External Data Sources<br><strong>11. Excel Pivot Tables</strong><br>11.1 Introduction<br>11.2 Preparing to Create a Pivot Table<br>11.3 A Basic Pivot Table<br>11.4 Sorting and Filtering a Pivot Table<br>11.5 Pivoting the Pivot Table<br>11.6 What Can Be Done with a Pivot Table?<br>11.7 Pivot Charts<br><strong>12. Macros and User-Written Functions for Excel</strong><br>12.1 Introduction<br>12.2 Macros and Viruses<br>12.3 Recorded Macros<br>12.4 Programmed Macros (Vba)<br><strong>13. User-Written Functions for Excel</strong><br>13.1 Introduction<br>13.2 Macro-Enabled Worksheets<br>13.3 Introduction to Visual Basic for Applications (Vba)<br>13.4 Writing Your Own Function<br>13.5 Using Your Functions in Other Workbooks<br>13.6 Examples of User-Written Functions<br><strong>14. Programming in Excel with VBA</strong><br>14.1 Introduction<br>14.2 Virus Protection and Macro-Enabled Workbooks<br>14.3 Visual Basic for Applications (VBA)<br>14.4 Projects, Forms, and Modules<br>14.5 Flowcharts<br>14.6 Fundamental Elements of Programming<br>14.7 Working with Forms<br><strong>15. Numerical Differentiation Using Excel</strong><br>15.1 Introduction<br>15.2 Finite Differences<br>15.3 Filtering Data<br>15.4 Curve Fitting and Differentiation<br><strong>16. Numerical Integration Using Excel</strong><br>16.1 Introduction<br>16.2 Integrating for Area Under a Curve<br>16.3 Integrating for Area Between Two Curves<br>16.4 Numerical Integration Methods<br>16.5 Using Regression Equations for Integration<br><strong>17. Numerical Integration Techniques for Differential Equations Using Excel</strong><br>17.1 Introduction<br>17.2 Euler's Method<br>17.3 Fourth-Order Runge--Kutta Method<br>17.4 Integrating Two Simultaneous Odes by Using the Runge--Kutta Method<br>17.5 Implicit Integration Methods</p>