| |
| |
| About This Book | |
| |
| |
| |
| Introduction To Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| What's new in Excel 2010? | |
| |
| |
| |
| A Starting Excel | |
| |
| |
| |
| A Little Windows“ | |
| |
| |
| |
| Excel Basics | |
| |
| |
| |
| Organizing Your Worksheets | |
| |
| |
| |
| Printing the Worksheet | |
| |
| |
| |
| Saving and Opening Workbooks, Exiting Excel | |
| |
| |
| |
| Using Excel's Ribbon | |
| |
| |
| |
| Navigating the Ribbon | |
| |
| |
| |
| Using the Clipboard Group | |
| |
| |
| |
| Using the Font Group | |
| |
| |
| |
| Using the Alignment Group | |
| |
| |
| |
| Formatting Numbers | |
| |
| |
| |
| Using the Styles Group | |
| |
| |
| |
| Inserting, Deleting and Formatting Rows and Columns | |
| |
| |
| |
| Graphing With Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Getting Ready to Graph | |
| |
| |
| |
| Creating an XY Scatter Graph | |
| |
| |
| |
| Editing an Existing Graph | |
| |
| |
| |
| Printing the Graph | |
| |
| |
| |
| Other Types of Graphs | |
| |
| |
| |
| Graphing Web Data | |
| |
| |
| |
| Importing Text Files | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Advanced Math Functions | |
| |
| |
| |
| Error Function | |
| |
| |
| |
| Bessel Functions | |
| |
| |
| |
| Working with Complex Numbers | |
| |
| |
| |
| Working with Binary, Octal, and Hexadecimal Values | |
| |
| |
| |
| Miscellaneous Functions | |
| |
| |
| |
| Matrix Operations In Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Matrices, Vectors, 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 Trendlines | |
| |
| |
| |
| Other Two-Coefficient Linear Regression Models | |
| |
| |
| |
| Polynomial Regression | |
| |
| |
| |
| Linear Regression Using Excel's Regression Analysis Package | |
| |
| |
| |
| Excel's Statistics Functions | |
| |
| |
| |
| Overview | |
| |
| |
| |
| Populations and Samples | |
| |
| |
| |
| Standard Deviations and Variances | |
| |
| |
| |
| Errors, Deviations, and Distributions | |
| |
| |
| |
| Confidence Intervals | |
| |
| |
| |
| Excel's Financial Functions | |
| |
| |
| |
| Time, Money, and Cash Flows | |
| |
| |
| |
| Interest Rates and Compounding | |
| |
| |
| |
| Moving Amounts Through Time | |
| |
| |
| |
| Net Present Value | |
| |
| |
| |
| Internal Rate of Return | |
| |
| |
| |
| Economic Alternatives: Making Decisions | |
| |
| |
| |
| Depreciation of Assets | |
| |
| |
| |
| Iterative Solutions Using Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Iterative Solutions | |
| |
| |
| |
| Using a Plot to Search for Roots | |
| |
| |
| |
| Simple "Guess and Check" Iteration | |
| |
| |
| |
| Direct-Substitution Technique | |
| |
| |
| |
| Using Goal Seek in Excel | |
| |
| |
| |
| Introduction to Excel's Solver | |
| |
| |
| |
| Optimization Using the Solver | |
| |
| |
| |
| Nonlinear Regression | |
| |
| |
| |
| Linear Programming | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Excel Pivot Tables | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Preparing to Create a Pivot Table | |
| |
| |
| |
| A Basic Pivot Table | |
| |
| |
| |
| Sorting and Filtering a Pivot Table | |
| |
| |
| |
| Pivoting the Pivot Table | |
| |
| |
| |
| What Can Be Done with a Pivot Table? | |
| |
| |
| |
| Pivot Charts | |
| |
| |
| |
| Macros And User-Written Functions For Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Macros and Viruses | |
| |
| |
| |
| Recorded Macros | |
| |
| |
| |
| Programmed Macros (VBA) | |
| |
| |
| |
| User-Written Functions For Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Macro-Enabled Worksheets | |
| |
| |
| |
| Introduction to Visual Basic for Applications | |
| |
| |
| |
| Writing Your Own Function | |
| |
| |
| |
| Using Your Functions in Other Workbooks | |
| |
| |
| |
| Examples of User-Written Functions | |
| |
| |
| |
| Programming In Excel With VBA | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Virus Protection and Macro-Enabled Workbooks | |
| |
| |
| |
| Visual Basic for Applications (VBA) | |
| |
| |
| |
| Projects, Forms, and Modules | |
| |
| |
| |
| Flowcharts | |
| |
| |
| |
| Fundamental Elements of Programming | |
| |
| |
| |
| Working with Forms | |
| |
| |
| |
| Numerical Differentiation Using Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Finite Differences | |
| |
| |
| |
| Filtering Data | |
| |
| |
| |
| Curve Fitting and Differentiation | |
| |
| |
| |
| Numerical Integration Using Excel | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Euler's Method | |
| |
| |
| |
| Fourth-Order Runge-Kutta Method | |
| |
| |
| |
| Integrating Two Simultaneous ODEs by Using the Runge-Kutta Method | |
| |
| |
| |
| Implicit Integration Methods | |