Engineering with Excel

ABOUT THIS BOOK vii1 * INTRODUCTION TO EXCEL 11.1 Introduction 11.2 What\'s new in Excel 2010? 41.2A Starting Excel 51.3 A Little Windows (R) 61.4 Excel Basics 161.5 Organizing Your Worksheets 351.6 Printing the Worksheet 361.7 Saving and Opening Workbooks, Exiting Excel 412 * USING EXCEL\'S RIBBON 532.1 Navigating the Ribbon 542.2 Using the Clipboard Group 542.3 Using the Font Group 712.4 Using the Alignment Group 792.5 Formatting Numbers 852.6 Using the Styles Group 932.7 Inserting, Deleting and Formatting Rows and Columns 1043 * GRAPHING WITH EXCEL 1223.1 Introduction 1223.2 Getting Ready to Graph 1233.3 Creating an XY Scatter Graph 1243.4 Editing an Existing Graph 1283.5 Printing the Graph 1463.6 Other Types of Graphs 1463.7 Graphing Web Data 1563.8 Importing Text Files 1594 * EXCEL FUNCTIONS 1754.1 Introduction to Excel Functions 1754.2 Excel\'s Built-in Functions 1764.3 Using the CONVERT Function to Convert Units 1794.4 Simple Math Functions 1814.5 Computing Sums 1834.6 Trigonometric Functions 1874.7 Advanced Math Functions 1954.8 Error Function 1974.9 Bessel Functions 1984.10 Working with Complex Numbers 1984.11 Working with Binary, Octal, and Hexadecimal Values 1984.12 Miscellaneous Functions 2005 * MATRIX OPERATIONS IN EXCEL 2215.1 Introduction 2215.2 Matrices, Vectors, and Arrays 2225.3 How Excel Handles Matrix Math 2235.4 Basic Matrix Operations 2235.5 Solving Systems of Linear Equations 2376 * LINEAR REGRESSION IN EXCEL 2566.1 Introduction 2566.2 Linear Regression Using Excel Functions 2576.3 Linear Regression Using Excel\'s Trendlines 2596.4 Other Two-Coefficient Linear Regression Models 2636.5 Polynomial Regression 2656.6 Linear Regression Using Excel\'s Regression Analysis Package 2667 * EXCEL\'S STATISTICS FUNCTIONS 2917.1 Overview 2917.2 Populations and Samples 2917.3 Standard Deviations and Variances 2947.4 Errors, Deviations, and Distributions 2977.5 Confidence Intervals 3048 * EXCEL\'S FINANCIAL FUNCTIONS 3188.1 Time, Money, and Cash Flows 3188.2 Interest Rates and Compounding 3218.3 Moving Amounts Through Time 3258.4 Net Present Value 3358.5 Internal Rate of Return 3388.6 Economic Alternatives: Making Decisions 3408.7 Depreciation of Assets 3449 * ITERATIVE SOLUTIONS USING EXCEL 3579.1 Introduction 3579.2 Iterative Solutions 3589.3 Using a Plot to Search for Roots 3599.4 Simple \"Guess and Check\" Iteration 3619.5 Direct-Substitution Technique 3639.6 Using Goal Seek in Excel 3689.7 Introduction to Excel\'s Solver 3719.8 Optimization Using the Solver 3789.9 Nonlinear Regression 3839.10 Linear Programming 39410 * SHARING EXCEL INFORMATION WITH OTHER PROGRAMS 41510.1 Introduction to Sharing Excel Information with Other Programs 41510.2 Using Copy and Paste to Move Information 41610.3 Embedded and Linked Objects 42810.4 External Data Sources 43811 * EXCEL PIVOT TABLES 45111.1 Introduction 45111.2 Preparing to Create a Pivot Table 45211.3 A Basic Pivot Table 45311.4 Sorting and Filtering a Pivot Table 45511.5 Pivoting the Pivot Table 45911.6 What Can Be Done with a Pivot Table? 46111.7 Pivot Charts 46412 * MACROS AND USER-WRITTEN FUNCTIONS FOR EXCEL 47012.1 Introduction 47012.2 Macros and Viruses 47112.3 Recorded Macros 47312.4 Programmed Macros (VBA) 50413 * USER-WRITTEN FUNCTIONS FOR EXCEL 52413.1 Introduction 52413.2 Macro-Enabled Worksheets 52613.3 Introduction to Visual Basic for Applications 52913.4 Writing Your Own Function 53413.5 Using Your Functions in Other Workbooks 53713.6 Examples of User-Written Functions 53814 * PROGRAMMING IN EXCEL WITH VBA 54714.1 Introduction 54714.2 Virus Protection and Macro-Enabled Workbooks 54814.3 Visual Basic for Applications (VBA) 54914.4 Projects, Forms, and Modules 55114.5 Flowcharts 55614.6 Fundamental Elements of Programming 56014.7 Working with Forms 58315 * NUMERICAL DIFFERENTIATION USING EXCEL 60515.1 Introduction 60515.2 Finite Differences 60515.3 Filtering Data 61315.4 Curve Fitting and Differentiation 62016 * NUMERICAL INTEGRATION USING EXCEL 63116.1 Introduction 63116.2 Integrating for Area under a Curve 63216.3 Integrating for Area between Two Curves 63216.4 Numerical Integration Methods 63316.5 Using Regression Equations for Integration 646