| |
| |
| |
| Introduction to Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Starting Excel | |
| |
| |
| |
| A Little Windows | |
| |
| |
| |
| Spreadsheet Basics | |
| |
| |
| |
| Printing the Spreadsheet | |
| |
| |
| |
| Saving, Opening Workbooks, and Exiting | |
| |
| |
| |
| Graphing with Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Getting Ready to Graph: Importing Text Files | |
| |
| |
| |
| Creating an XY Scatter Plot | |
| |
| |
| |
| Editing an Existing Graph | |
| |
| |
| |
| Creating Graphs with Multiple Curves | |
| |
| |
| |
| Printing the Graph | |
| |
| |
| |
| Types of Graphs | |
| |
| |
| |
| Excel Functions | |
| |
| |
| |
| Introduction to Excel Functions | |
| |
| |
| |
| Excel's Built-in Functions | |
| |
| |
| |
| Using the Convert ( ) Function to Convert Units | |
| |
| |
| |
| Simple Math Functions | |
| |
| |
| |
| Computing Sums | |
| |
| |
| |
| Trigonometric Functions | |
| |
| |
| |
| Inverse Trigonometric Functions | |
| |
| |
| |
| Advanced Math Functions | |
| |
| |
| |
| Conditional Formatting | |
| |
| |
| |
| Error Function | |
| |
| |
| |
| Bessel Functions | |
| |
| |
| |
| Working with Complex Numbers | |
| |
| |
| |
| Working with Binary, Octal, and Hexadecimal Values | |
| |
| |
| |
| Miscellaneous Functions | |
| |
| |
| |
| Matrix Operations in Excel | |
| |
| |
| |
| Matrix Manipulations: Vectors, Matrices, and Arrays | |
| |
| |
| |
| How Excel Handles Matrix Math | |
| |
| |
| |
| Basic Matrix Operations | |
| |
| |
| |
| Solving Systems of Linear Equations | |
| |
| |
| |
| Linear Regression in Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Linear Regression Using Excel Functions | |
| |
| |
| |
| Linear Regression Using Excel's Trend Line Capability | |
| |
| |
| |
| Other Two-Coefficient Linear Regression Models | |
| |
| |
| |
| Polynomial Regression | |
| |
| |
| |
| Linear Regression Using Excel's Regression Analysis Package | |
| |
| |
| |
| Iterative Solutions Using Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Iterative Solutions | |
| |
| |
| |
| Introduction to Excel's Solver | |
| |
| |
| |
| Optimization Using the Solver | |
| |
| |
| |
| Nonlinear Regression | |
| |
| |
| |
| Testing the Regression Result | |
| |
| |
| |
| Using Macros in Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Macros and Viruses | |
| |
| |
| |
| Recorded Macros | |
| |
| |
| |
| Programmed Macros (VBA) | |
| |
| |
| |
| Programming in Excel with VBA | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Visual Basic for Applications (VBA) Overview | |
| |
| |
| |
| Forms and Modules | |
| |
| |
| |
| Working with Forms | |
| |
| |
| |
| Using the Form from the Spreadsheet | |
| |
| |
| |
| Sharing Excel Information with Other Programs | |
| |
| |
| |
| Introduction to Sharing Excel Information with Other Programs | |
| |
| |
| |
| Using Copy and Paste to Move Information | |
| |
| |
| |
| Embedded and Linked Objects | |
| |
| |
| |
| External Data Sources | |
| |
| |
| |
| Time Value of Money with Excel | |
| |
| |
| |
| Time, Money, and Cash Flows | |
| |
| |
| |
| Interest Rates and Compounding | |
| |
| |
| |
| Moving Amounts through Time | |
| |
| |
| |
| Economic Alternatives: Making Decisions | |
| |
| |
| |
| Financial Calculations with Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Internal Rate of Return and Net Present Value | |
| |
| |
| |
| Depreciation of Assets | |
| |
| |
| |
| Excel's Statistics Functions | |
| |
| |
| |
| Overview | |
| |
| |
| |
| Populations and Samples | |
| |
| |
| |
| Standard Deviations and Variances | |
| |
| |
| |
| Errors, Deviations, and Distributions | |
| |
| |
| |
| Confidence Intervals | |
| |
| |
| |
| Numerical Differentiation Using Excel | |
| |
| |
| |
| Finite Differences | |
| |
| |
| |
| Filtering Data | |
| |
| |
| |
| Curve-Fitting and Differentiation | |
| |
| |
| |
| Numerical Integration Using Excel | |
| |
| |
| |
| Integrating for Area under a Curve | |
| |
| |
| |
| Integrating for Area Between Two Curves | |
| |
| |
| |
| Numerical Integration Methods | |
| |
| |
| |
| Using Regression Equations for Integration | |
| |
| |
| |
| Numerical Integration Techniques for Differential Equations Using Excel | |
| |
| |
| |
| Euler's Method | |
| |
| |
| |
| Fourth-Order Runge-Kutta Method | |
| |
| |
| |
| Integrating Two Simultaneous ODEs Using the Runge-Kutta Method | |
| |
| |
| |
| Implicit Methods | |
| |
| |
| Index | |